SQL connect
Posted: Sat Jun 01, 2002 1:39 pm
I need a small bit of script that will let a page connect to my db and then select the table and id...what is that code 
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
<?php
<?php
$dbhost = 'yourhost';
$dbusername = 'yourusername';
$dbuserpassword = 'yourpassword';
$default_dbname = 'yourdb';
$MYSQL_ERRNO = ' ';
$MYSQL_ERROR = ' ';
function db_connect()
{
global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
global $MYSQL_ERRNO, $MYSQL_ERROR;
$link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
if(!$link_id)
{
$MYSQL_ERRNO = 0;
$MYSQL_ERROR = "Connection failed to the host $dbhost.";
return 0;
}
else if(empty($dbname) && !mysql_select_db($default_dbname))
{
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else return $link_id;
}
$link_id=db_connect();
$query = mysql_query("SELECT * FROM table WHERE id='$id'", $link_id);
?>
?>Code: Select all
<?php
$db = mysql_connect("localhost","username","password");
mysql_select_db("database");
$result = mysql_query("SELECT * FROM table");
while($row= mysql_fetch_array($result))
{
echo "$rowї0]<br />";
}
mysql_close($db);
?>Works so nm :p<?php
$db = mysql_connect("localhost","unknownz","password");
mysql_select_db("unknownz");
$result = mysql_query("SELECT * FROM $table");
while($row = mysql_fetch_array($result))
{
echo "$row[0]<br />";
}
mysql_close($db);
?>