Snippets Databases
Databases
JQuery - Simplified database queries
by: Rolandz
|
March 20, 2001
Version: 2.0.x
Type: Function
Category: Databases
License: GNU General Public License
Description: A function to perform database queries on MySQL servers. Takes one argument; The SQL statement.
<?PHP
/* Function to simplify doing Database Queries
All that is needed is the query to execute.
Returns true if execution was completed successfully.
Otherwise outputs error messages and returns 0.
Requires 4 global variables:
$db_host The hostname / IP-Adresse
$db_user The username
$db_pass The password
$db_name The database name
Version: 2.0.1
Date: 2000-07-01
Author: Jocke Selin (jocke@selincite.com)
----------------------------------------------
For direct output in the same function
Version: 2.0.x
Date: 2001-03-20
Update: rolandz (rolandhz@hotmail.com)
*/
function jquery($query)
{
$db_host='10.130.148.15';
$db_user='root';
$db_pass='';
$db_name='Focus';
// Connect to DB
if (!$link = @mysql_connect($db_host, $db_user, $db_pass))
{
$result = 0;
print("<FONT COLOR='Red'><BR><BR><HR><CENTER><B>Error connecting to $db_host!<HR></B><BR>\n");
}
else
{
// Select DB
if (!@mysql_select_db($db_name, $link))
{
$result = 0;
print("<FONT COLOR='Red'><BR><BR><HR><CENTER><B>Error selecting $db_name!<HR></B><BR>\n");
}
else
{
// Execute query
if (!$result = @mysql_query($query, $link))
{
$result = 0;
print("<FONT COLOR='Red'><BR><BR><HR><CENTER><B>Error executing query!<HR></B><BR>\n");
}
else
{
$fields = mysql_num_fields($result);
while ($array = mysql_fetch_array($result))
{
for ($i=0; $i <= $fields; $i++)
{
echo $array[$i];
if ( $i < $fields ) echo "; ";
}
echo "<BR>\n";
}
}
}
}
return $result;
}
function bgn_html($title, $author, $header)
{
print ("<HTML>\n");
print (" <HEAD>\n");
printf (" <TITLE>%s</TITLE>\n", $title);
print (" <META HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=windows-1252'>\n");
printf (" <META NAME='AUTHOR' CONTENT='%s'>\n", $author);
print (" </HEAD>\n");
print (" <BODY BGCOLOR='#F1F1F1' TEXT='#364180'>\n");
print (" <BASEFONT FACE='Courier New'>\n");
printf (" <H1><CENTER>%s</CENTER></H1>\n", $header);
printf (" <HR>\n");
}
function end_html ()
{
print (" </BODY>\n");
print ("</HTML>\n");
}
bgn_html ('Test PHP-Site', 'rolandz', 'Output');
jquery('SELECT * FROM table WHERE field = x');
end_html ();
?>
PHPBuilder
Policies
PHP Developer
Topics
PHP Developer
Resources
PHP Developer
References
