note 84605 modified in function.mysql-query by thiago
| From: | thiago@php.net | Date: | Mon, 21 Jul 2008 20:20:24 +0000 |
| Subject: | note 84605 modified in function.mysql-query by thiago | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-142443@lists.php.net to get a copy of this message | ||
Here is an example of using the mysql_query in the context of connecting to a database.
<?php
function connect( $dbName )
{
do {
$databaseResponse = mysql_connect(
"example.com", "username", "password" );
sleep(1);
} while( $databaseResponse === false );
@ $selectResult = mysql_select_db( $dbName ) or dieFunc();
}
function executeQuery( $query, $db )
{
if( $db != "" ) connect( $db );
else connect( "pascal_crm" );
$result= mysql_query( $query );
$err = mysql_error();
if( $err != "" ) echo "error=$err ";
mysql_close();
return $result;
}
?>
--was--
Here is an example of using the mysql_query in the context of connecting to a database.
function connect( $dbName )
{
do {
$databaseResponse = mysql_connect(
"mysql400.ixwebhosting.com", "username", "password" );
sleep(1);
} while( $databaseResponse === false );
@ $selectResult = mysql_select_db( $dbName ) or dieFunc();
}
function executeQuery( $query, $db )
{
if( $db != "" ) connect( $db );
else connect( "pascal_crm" );
$result= mysql_query( $query );
$err = mysql_error();
if( $err != "" ) echo "error=$err ";
mysql_close();
return $result;
}
for more questions/examples: http://www.codesplunk.com/nr/questions/php3.html
http://php.net/manual/en/function.mysql-query.php