كود PHP:
<?
$link = mysql_connect("localhost", "username", "password")
or die ("Could not connect to MySQL");
mysql_select_db ("db_name")
or die ("Could not select database");
$query = "SELECT * FROM personal";
$result = mysql_query ($query)
or die ("Query failed");
$query2 = "SELECT * FROM hosting";
$result2 = mysql_query ($query2)
or die ("Query failed");
$query3 = "SELECT * FROM domains";
$result3 = mysql_query ($query3)
or die ("Query failed");
mysql_close($link);
$num = mysql_numrows($result);
$num2 = mysql_numrows($result2);
$num3 = mysql_numrows($result3);
$i=0;
$i2=0;
$i3=0;
while ($i < $num && $i2 < $num2 && $i3 < $num3) {
$id=mysql_result($result,$i,"id");
$add_date=mysql_result($result,$i,"add_date");
$fname=mysql_result($result,$i,"fname");
$lname=mysql_result($result,$i,"lname");
$email=mysql_result($result,$i,"email");
$phone=mysql_result($result,$i,"phone");
$country=mysql_result($result,$i,"country");
$city=mysql_result($result,$i,"city");
$username=mysql_result($result,$i,"username");
$password=mysql_result($result,$i,"password");
$totalcost=mysql_result($result,$i,"totalcost");
$plan_3=mysql_result($result2,$i2,"plan");
$period_2=mysql_result($result2,$i2,"period");
$plancost_2=mysql_result($result2,$i2,"hosting_cost");
$domain_status=mysql_result($result3,$i3,"domain_status");
$domainname_new=mysql_result($result3,$i3,"domainname_new");
$domainextend_new=mysql_result($result3,$i3,"domainextend_new");
$domainname_old=mysql_result($result3,$i3,"domainname_old");
$domainextend_old=mysql_result($result3,$i3,"domainextend_old");
$domain_cost=mysql_result($result3,$i3,"domain_cost");
?>
الجدول هنا
<?
++$i3;
++$i2;
++$i;
}
?>