DaniWeb Forum Index > Web Development > PHP

Confused :(

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jan 2009

Posts: 151

Reputation: Phil++ is an unknown quantity at this point

Solved Threads: 3

Phil++

Offline

Junior Poster

Confused :(

Oct 15th, 2009

Hey, I'm working on a College project that means you have to re-do the database each time you work on your assignment. So, what I'm hoping to create is a file called "sql_connect.php" which will check if the table is there, if not.. It will run the function that creates it. Here is my code:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
 
<?php
DEFINE ('DB_USER', 'USERNAME');
DEFINE ('DB_PASSWORD', 'PASSWORD');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'TABLE');
 
// make the connection
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('');
 
// select the database
$tbc = @mysql_select_db (DB_NAME) OR die ('fgddffdfdfd');
 
if(!$tbc)
{
  sql_insert();
}else{
}
 
?>
<?php
DEFINE ('DB_USER', 'USERNAME');
DEFINE ('DB_PASSWORD', 'PASSWORD');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'TABLE');

// make the connection
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('');

// select the database
$tbc = @mysql_select_db (DB_NAME) OR die ('fgddffdfdfd');

if(!$tbc)
{
  sql_insert();
}else{
}

?>

Thanks for any help

•

Join Date: May 2008

Posts: 524

Reputation: Will Gresham is on a distinguished road

Solved Threads: 86

Will Gresham Will Gresham is offline

Offline

Posting Pro

Oct 15th, 2009

This should work...

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
mysql_query("CREATE TABLE IF NOT EXISTS `table_name` (
`field_name` int(11) NOT NULL AUTO_INCREMENT,
`field_name` varchar(65),
...,
...,
...,
PRIMARY KEY (`field_name`)
)");
mysql_query("CREATE TABLE IF NOT EXISTS `table_name` (
`field_name` int(11) NOT NULL AUTO_INCREMENT,
`field_name` varchar(65),
...,
...,
...,
PRIMARY KEY (`field_name`)
)");

Last edited by Will Gresham; Oct 15th, 2009 at 9:00 pm.

AJAX is not a programming language, scripting language or any other sort of language.
It is acheived by using JavaScript http functions.
So, AJAX = JavaScript.

•

Join Date: Mar 2008

Posts: 70

Reputation: forzadraco is an unknown quantity at this point

Solved Threads: 1

forzadraco forzadraco is offline

Offline

Junior Poster in Training

-1

Oct 16th, 2009

•

Originally Posted by Phil++

Hey, I'm working on a College project that means you have to re-do the database each time you work on your assignment. So, what I'm hoping to create is a file called "sql_connect.php" which will check if the table is there, if not.. It will run the function that creates it. Here is my code:
Help with Code Tags

PHP Syntax (Toggle Plain Text)
 
<?php
DEFINE ('DB_USER', 'USERNAME');
DEFINE ('DB_PASSWORD', 'PASSWORD');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'TABLE');
 
// make the connection
$dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die ('');
 
// select the database
$tbc = @mysql_select_db (DB_NAME) OR die ('fgddffdfdfd');
 
if(!$tbc)
{
  sql_insert();
}else{
}
 
?>
<?php DEFINE ('DB_USER', 'USERNAME'); DEFINE ('DB_PASSWORD', 'PASSWORD'); DEFINE ('DB_HOST', 'localhost'); DEFINE ('DB_NAME', 'TABLE'); // make the connection $dbc = @mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die (''); // select the database $tbc = @mysql_select_db (DB_NAME) OR die ('fgddffdfdfd'); if(!$tbc) { sql_insert(); }else{ } ?>
Thanks for any help

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
//check table
function checktable($tablename){
return mysql_query("select * from ".$tablename." limit 0,1");
}
 
$table="table_name_that_want_to_be_check";
if(checktable($table)){
echo"table already created";
}else{
//create table if not exist
mysql_query("CREATE TABLE ".$table." (
         id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
         data VARCHAR(100), 
......................
       );")
echo "table created"
}
 
?>
<?php
//check table
function checktable($tablename){
return mysql_query("select * from ".$tablename." limit 0,1");
}

$table="table_name_that_want_to_be_check";
if(checktable($table)){
echo"table already created";
}else{
//create table if not exist
mysql_query("CREATE TABLE ".$table." (
         id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
         data VARCHAR(100), 
......................
       );")
echo "table created"
}

?>