قواعد البيانات
echo mysql_errno().": ".mysql_error()."<BR>";
?>
<?php
الفصل الخامس
مثال مصفوفة البحث :
//Example Mysql_fetch_array()
mysql_connect ($host, $user, $password);
$result mysql_db_query ("database","select user_id, fullname from table");
while ($row = mysql_fetch_array ($result)) { echo "user_id: ".$row["user_id"]."<br>\n"; echo "user_id: ".$row[0]."<br>\n";
}
echo "fullname: ".$row["fullname"]."<br>\n"; echo "fullname: ".$row[1]."<br>\n";
mysql_free_result ($result);
?>
مثال بحث الحقول :
<?php
// Example Mysql_fetch_field()
mysql_connect ($host, $user, $password)
or die ("Could not connect");
$result = mysql_db_query("database", "select * from table")
or die ("Query failed");
# get column metadata
$i = 0;
while ($i < mysql_num_fields ($result)) {
echo "Information for column $i:<BR>\n"; $meta = mysql_fetch_field ($result);
if (!$meta) {
}
echo "No information available<BR>\n";
echo "<PRE>
blob:
$meta->blob
max_length: $meta->max_length
multiple_key: $meta->multiple_key
name:
149
$meta->name
ص ١٨٩