john pfeiffer
  • Home
  • Categories
  • Tags
  • Archives

dbaddtables

<?php
/*
session_start();
if(!session_is_registered('member_ID')) :
header('Location: index.php');
endif;
*/
?>

<?php
include 'dbinfo.php';
include 'dbconnect.php';

$sql = "SHOW DATABASES";
$response = mysql_query($sql,$dbconn);
echo $response ."<br>\n";

$sql = "SHOW TABLES";
$response = mysql_query($sql,$dbconn);
echo $response ."<br>\n";;

$sql = "SHOW TABLES";
$response = mysql_query($sql,$dbconn);
echo $response ."<br>\n";;

$sql = "CREATE TABLE bookmarks( name VARCHAR(80) , url VARCHAR(256) )";
$response = mysql_query($sql,$dbconn);
echo $response ."<br>\n";;

$sql = "SHOW TABLES";
$response = mysql_query($sql,$dbconn);
echo $response ."<br>\n";;


/*
//$sql = "DROP DATABASE bookmarks";
mysql_query("INSERT INTO person (FirstName, LastName, Age)
VALUES ('Peter', 'Griffin', '35')");
*/
mysql_close($dbconn);
?>

  • « dbconnect
  • win button time »

Published

Feb 6, 2010

Category

web

~73 words

Tags

  • dbaddtables 1
  • web 56