Re: [nyphp-talk] Mysql question!

Ben Sgro (sk) Mon, 30 Oct 2006 15:57:33 -0800

Hello Paul

if exists(!Customer_Info) //Here it doesn't work, error!!!!

Is 'Customer_Info' a constant?

Otherwise I dont see how this works, its not a function (), its not a variable $..I'm not big on OOPHP some if that is some sorta construct

ignore my message.

- Ben

ps: These are some wrappers I use to make my code simpler to look at.

/* DBAS_MySQLConnect

$sqlInfo is an array that holds values particular to the app this is used in.

ex: $sqlInfo = array('databaseUser' => mysql, 'databasePass' => 's3cr3t');

*/
function DBAS_MySQLConnect(&$db, $sqlInfo)
{
    $cIp    = $_SERVER["REMOTE_ADDR"];
    $dbName = $sqlInfo['databaseUser'];
    $dbPass = $sqlInfo['databasePass'];
    $db = mysql_pconnect("", $dbName, $dbPass);
    if ( $db )
    {
        error_log("DBAS: $cIp connected to mysql server");
    }
    else
    {
        error_log("DBAS: error connecting to mysql server");
    }
}

/* DBAS_MySQLUseDB

*/
function DBAS_MySQLUseDB($dbName, $db)
{
    $res = mysql_select_db($dbName, $db);
    if ( $res )
    {
        error_log("DBAS: using database $dbName");
    }
    else
    {
        error_log("DBAS: cannot use database $dbName");
    }
}

/* DBAS_MySQLQuery

*/
function DBAS_MySQLQuery($query, $db)
{
    $result = mysql_query($query, $db);
    if ( !$result )
    {
        $errorStr = mysql_error( $db );
        $errorNum = mysql_errno( $db );
        $errorStr = "error($errorStr):error no($errorNum)";
        error_log("DBAS: MySQL $errorStr");
    }
    return $result;
}

----- Original Message -----

From: [EMAIL PROTECTED]

To: talk@lists.nyphp.org

Sent: Monday, October 30, 2006 6:21 PM

Subject: [nyphp-talk] Mysql question!

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

_______________________________________________
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

Re: [nyphp-talk] Mysql question!

Reply via email to