Hey there,
I was just looking at your code, and I also look at other's code, and I
think people are making life difficult for themselves. Sure a lot of
people on this list are beginners, but thats more te reason to simplify
code...
One thing you should always do, is write functions... I have written a
few functions to connect to a database, execute queries and return
results, and insert and update queries. Using functions like these make
it a lot easier to write working code, and because it's less typing, its
a lesser chance of an error occurring...
for example... here is a portion of my lib.php which I include() on each
page I create (some comments are removed to save space)
putting the below code into an external file and including it on every
page makes everything a lot cleaner, and if you need to connect to a
database, just call
dbConnect();
in your php script... you must make sure that in the external file, the
constants are set with your server details... or you can do it in the
actual page with the function, like so:
dbConnect("dbname","localhost","username","password");
and if you need the connection ID, it is in the variable $DB_CONN.
If you want some more functions like this (i have a few more called
getData(), dbInsert(), dbUpdate() which all make it a LOT easier to
transport data to and from a mysql database), email me and I will send
them to you directly. If you don't run mySQL, then you can just modify
the functions to suit your DB, or you can add and delete things inside
the functions for your own setup.
Adam
/******** DEFINE CONSTANTS ********/
// Connecting to a database
define( "DB_SERVER" , "localhost" ); // used for dbConnect()
define( "DB_USERNAME" , "username" ); // used for dbConnect()
define( "DB_PASSWORD" , "password" ); // used for dbConnect()
define( "DB_DATABASE" , "dbname" ); // used for dbConnect()
/******** DATABASE FUNCTIONS ********/
function dbConnect($dbDatabase=DB_DATABASE, $dbServer=DB_SERVER,
$dbUsername=DB_USERNAME, $dbPassword=DB_PASSWORD){
global $DB_CONN;
$DB_CONN = @mysql_connect($dbServer, $dbUsername, $dbPassword) or
die("Couldn't connect to database server.");
$db = @mysql_select_db($dbDatabase) or die("Couldn't select
database.");
return $DB_CONN;
}
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
