Confused :(

Expand Post »

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:

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

Similar Threads

Confused writing a Java Class in Java
Need help With this C++ Program..Confused.. in C++
confused about SE + SEO. in Search Engine Optimization
Confused about SATA RAID in Storage

Phil++

Reputation Points: 41

Solved Threads: 7

Posting Whiz in Training

Offline

233 posts
since Jan 2009

Permalink

Oct 15th, 2009

Re: Confused :(

This should work...

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.

Will Gresham

Reputation Points: 96

Solved Threads: 124

Master Poster

Offline

728 posts
since May 2008

Permalink

Oct 16th, 2009

-1

Re: Confused :(

Click to Expand / Collapse Quote 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:
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

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"
}

?>

forzadraco

Reputation Points: 10

Solved Threads: 1

Junior Poster in Training

Offline

70 posts
since Mar 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Uploading files to web server...

Next Thread in PHP Forum Timeline: PHP & Apache Server Security Questions

DaniWeb Message

Cancel Changes

User Name
Password