Hi, everybody!
I want to ask you all to help me out in solving my database question.
Here is what I want to accomplish:
I want to add my users, one by one, to my Mysql database via a registration form.
When a user fills out a registration form, my script should gather all the information
and add them to the database. I pretty much got all that part working, but I want my
script to check to see whether a table exists or not. If it doesn't exist, my script
should create a table and then proceed to add the information to the database;
and if it does exist, then it should not create one and proceed to use the existed table.
1) Is there a php function that take care of this job that I can use?
I tried to use: if exists(mytablename)
but, it doesn't work.
Here is my code: (some codes are left out for illustration purpose.)
<?php
include("dbinfo.inc.php");
class TableInfo
{
function _construct() //A Constructor
{
/* Initialize database */
mysql_connect($localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
if exists(!Customer_Info) //Here it doesn't work, error!!!!
{
$query = "CREATE TABLE Customer_Info
(
FirstNameCol VARCHAR(15) NOT NULL,
LastNameCol VARCHAR(20) NOT NULL,
AddressCol VARCHAR(40) NOT NULL,
CityCol VARCHAR(20) NOT NULL,
StateCol VARCHAR(20) NOT NULL,
ZipCodeCol INT(5) NOT NULL,
AreaCodeCol INT(3) NOT NULL,
PhoneCol INT(15) NOT NULL,
EmailCol VARCHAR(30) NOT NULL,
LoginNameCol VARCHAR(20) NOT NULL,
PasswordCol VARCHAR(20) NOT NULL
)";
mysql_query($query);
}
//Add new customer to database
function AddNewCustomer($FirstName, $LastName, $Address,
$City, $State, $ZipCode,
$AreaCode, $Phone, $Email,
$WebsiteURL, $LoginName, $Password
)
{
$query = 'INSERT INTO Customer_Info (FirstNameCol,
LastNameCol, AddressCol, CityCol, StateCol,
ZipCodeCol, AreaCodeCol, PhoneCol,
EmailCol, WebsiteURLCol,
LoginNameCol, PasswordCol
)
VALUES ("'. $FirstName . '", "' . $LastName . '",
"' . $Address . '", "' . $City . '",
"' . $State . '", "' . $ZipCode . '",
"' . $AreaCode . '", "' . $Phone . '",
"' . $Email . '",
"' . $WebsiteURL . '", "' . $LoginName . '",
"' . SHA1($Password) . '")';
}
Feel free to correct my code and give suggestions for better techniques.
Thanks!
Paul
_______________________________________________ New York PHP Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
