PHP 连数据库代码段

$db_host='localhost';
$db_database='pubs';
$db_username='root';
$db_password='123';

$ReturnToFlex = "<?xml version="1.0" encoding="utf-8"?><Root>";

// get connection case
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
}

// selected database
$db_select = mysql_select_db($db_database);
if (!$db_select){
die ("Could not select the database: <br />". mysql_error());
}

//implement SQL statement
$query = "SELECT * FROM books";

$result = mysql_query( $query );
if (!$result)
{
die ("Could not query the database: <br />". mysql_error());
}

//get array with iterator
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
                                echo $row[title]. '<br />';
}

// get row with iterator
while ($result_row = mysql_fetch_row($result)){
       echo $result_row[2] . '<br />';
       $ReturnToFlex .= "<element>".$result_row[2]."</element>";
}

$ReturnToFlex .= "</Root>";

print ($ReturnToFlex)

 

HttpService id="hsDemo"
hsDemo.method = "GET";
hsDemo.url = "http://www.usetracks.de/php/ig.php?delId="+cbxId.selectedIndex;

hsDemo.method = "POST";
hsDemo.url = "http://www.usetracks.de/php/ig.php";