Accueil Tutoriaux Installation
Installation of PHPSIMPLEDB
Written by Hidalgo Emmanuel   

Necessary meadows :

Here the list of the necessary meadows concerning the installation of PHPSIMPLEDB:

An Apache Web server/Mysql/Php must be present on your computer.

I advise you the use of WAMP under Windows or LAMP under Linux.

You must have a database, this one must obviously have tables.

If you do not have basic data, script below will help you with the creation of a base of test named “test” :

 

--
-- Structure de la table `produits`
--

DROP TABLE IF EXISTS `produits`;
CREATE TABLE IF NOT EXISTS `produits` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`position` int(11) default NULL,
`users_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Contenu de la table `produits`
--

INSERT INTO `produits` (`id`, `name`, `position`, `users_id`) VALUES
(1, 'un produit', 1, 2),
(3, 'jolie maison', 2, 2),
(4, 'Pavillon', 4, 2),
(5, 'Pavillon aa', 3, 2);

-- --------------------------------------------------------

--
-- Structure de la table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`id` bigint(20) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`level` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id`, `name`, `level`) VALUES
(2, 'durant', 2),
(4, 'John Do', 2);

 


Remote loading and installation :

Remote loading :

To download file PHPSIMPLEDB presents on the http://www.phpsimpledb.com official site.

To decompress the file in the site of your “DocumentRoot”, this repertory represents the site root of files PHP for Apache.

Parameter setting :

Once decompressed, to publish the file “configuration.php”

<?php
//définition des constantes de bases
define( "AUTO_URL_BASE", "http://localhost/phpsimpledb_v2/" );
define( "TEMPLATE_NAME", "smarty" );
define( "TAG_LANG", "fr" );
?>

To modify key “AUTO_URL_BASE” in order to make it correspond to the way of the URL from which the resource will be accessible.

You have the possibility of changing the language with key “TAG_LANG” (“en” or “fr”).


Test of installation :

To test if the installation of PHPSIMPLEDB were carried out correctly, to use your navigator and to inform the basic URL of the project.

Here  : http://localhost/phpsimpledb_v2/


If the installation were held well, you must see appearing the gate of PHPSIMPLEDB with the image of the logo of the homepage.