install.php

avatar_alex

i am creating a script that requires mysql but i want it to be as easy as possible for people that hardly know php so i am creating an install.php file to install the DB tables for them but i kinda need help. so if anyone has a code to help me out or knows where I can find the code I would apperiate it

Houdini

Alter and modify for your ouw purposes.

<?php
//###################################################################################
//Using PHP with MySQL database short tutorial this is for those using a local PC
//to connect to the MySQL with PHP to develop scripts locally before uploading to the 
//www server.
//###################################################################################
//Filename mysql.php
//create variables for a connection to the database
$host='localhost';//this is normally OK
$user='root';//this is the default (root) for a new install of MySQL 
$password='';//this is the default
//Connect to the server (MySQL server) this is the first thing you must do
$connect=mysql_connect($host,$user,$password)
	or die("Could not connect to server, MySQL said: ".mysql_error());
//Now create a database on the server using PHP
$db=mysql_query("CREATE DATABASE mydatabase");//This sets up the query
//Now select to use the database (mydatabase)
$db2 =mysql_select_db('mydatabase')//This executes the query set up by the 
//above query and reports errors if any occur with the or die statement below
	or die("Could not select the new database. MySQL said: ".mysql_error());
//Now set up a new query to create atable on the new database (mydatabase)	
$table="CREATE TABLE mytable(
	id INT(5) AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(30),
	email VARCHAR(40),
	website VARCHAR(50),
	hobby VARCHAR(50),
	country VARCHAR(45)
	)";
$maketable=mysql_query($table,$connect);//This executes the table creation defined above.	
//now set up a query to insert data in to mytable	
$insert ="INSERT INTO mytable (name,email,website,hobby,country) VALUES ('Joe Blow','joe@email.com','http://mysite.com','bowling','USA')";
//execute the query
$result =mysql_query($insert)
	or die("Query failed. MySQL said: ".mysql_error());//kill script and print errors if they occur
//Set up a query to show the all data in mytable right now
$query2 ="SELECT * FROM mytable";
//execute the query below
$result2 =mysql_query($query2)
	or die("Query failed. MySQL said: ".mysql_error());
//fetch the resultset array data from mytable
$row = mysql_fetch_array($result2,MYSQL_ASSOC)
	or die("Query failed".mysql_error());
echo "User {$row['name']} with email {$row['email']} with website {$row['website']} and has the hobby of {$row['hobby']} and is from {$row['country']}";		
?>

bradgrafelman

You could also do some error prevention, by adding keywords such as "IF NOT EXISTS" to the CREATE DATABASE query, and by using "DROP TABLE IF EXISTS" on the table you intend to use.

avatar_alex

ok this is what i ulered:

<?php 

//create variables for a connection to the database 

$host='localhost';   //this is normally OK 

$user='TEST';   //this is the default (root) for a new install of MySQL 

$password='TEST';   //this is the default 

//Connect to the server (MySQL server) this is the first thing you must do 

$connect=mysql_connect($host,$user,$password) 

or die("Could not connect to server, MySQL said: ".mysql_error()); 

//Now create a database on the server using PHP 

$db=mysql_query("TEST");//This sets up the query 

//Now select to use the database (mydatabase) 

$db2 =mysql_select_db('TEST')//This executes the query set up by the 

//you dont need to edit beyond this point 

or die("Could not select the new database. MySQL said: ".mysql_error()); 
//Now set up a new query to create atable on the new database (mydatabase)     

$table="CREATE TABLE `hompage` (
`id` int(6) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`content` varchar(255) NOT NULL default ,
PRIMARY KEY  (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;''

$maketable=mysql_query($table,$connect);//This executes the table creation defined above.     

//now set up a query to insert data in to mytable

$insert ="INSERT INTO hompage (title,content) VALUES ('test test test test test','test test test test test test')"; 
//execute the query 
$result =mysql_query($insert) 
    or die("Query failed. MySQL said: ".mysql_error());//kill script and print errors if they occur 
//Set up a query to show the all data in mytable right now 
$query2 ="SELECT * FROM mytable"; 
//execute the query below 
$result2 =mysql_query($query2) 
    or die("Query failed. MySQL said: ".mysql_error()); 

?>

ok im still learning php but I dont know about the table if I put all i need to in the right place there is also an error

Parse error: syntax error, unexpected T_STRING in /home/mystrh00
/domains/witchin.net/public_html/layout/cms/install.php on line 41

i dont know can someone help me.

and also I already have a connection to my DB. so is there a way i can use and include to connect so people dont have to fill out 2 DB connections.

heres the code if there is a way then tell me if I need to add something or not:

<?php
/// For the following details,
/// please contact your server vendor

$hostname='localhost'; //// specify host, i.e. 'localhost'
$user='mystrh00_content'; //// specify username
$pass='803161'; //// specify password
$dbase='mystrh00_content'; //// specify database name
$connection = mysql_connect("$hostname" , "$user" , "$pass") 
or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database.");
?>

bradgrafelman

Few things:

$db=mysql_query("TEST");//This sets up the query

What is this code supposed to do?

avatar.alex wrote:
there is also an error
If you look at the code you posted, notice how the syntax highlighting goes crazy around after the "CREATE TABLE" query? You never added an ending double quote to close that string.
avatar.alex wrote:
so is there a way i can use and include to connect so people dont have to fill out 2 DB connections.
If you have this in a different PHP file, sure, why not [man]include[/man] it? In fact, since you pretty much need a connection to continue, you might even tell PHP that you [man]require[/man] this file.

el_timm

Line 41 doesn't end it's

$table="CREATE

syntax with a double quote. You've used two single ' quotes instead.

avatar_alex

Im creating a simple CMS and i just need alittle help with it.

avatar_alex

el_timm wrote:
Line 41 doesn't end it's
$table="CREATE
syntax with a double quote. You've used two single ' quotes instead.

do i use 2 signle quotes of keep it how it is

bradgrafelman

You use the same delimiter to end the string as the one that you used to start the string.

avatar_alex

sorry im new at the php thing but where would the string end

el_timm

$table="CREATE TABLE `hompage` ( 
`id` int(6) NOT NULL auto_increment, 
`title` varchar(255) NOT NULL default '', 
`content` varchar(255) NOT NULL default , 
PRIMARY KEY  (`id`), 
UNIQUE KEY `id` (`id`) 
) TYPE=MyISAM AUTO_INCREMENT=1 ;"