PHP 连数据库代码段

最新推荐文章于 2024-11-09 21:51:58 发布

faith_zerg

最新推荐文章于 2024-11-09 21:51:58 发布

阅读量689

点赞数

分类专栏： PHP 文章标签：数据库 php database mysql iterator query

本文链接：https://blog.csdn.net/faith_zerg/article/details/1847244

版权

PHP 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

$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: ". mysql_error());
}

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

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

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

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

// get row with iterator
while ($result_row = mysql_fetch_row($result)){
echo $result_row[2] . ' ';
$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";