Si cum as putea sa atasez un script php la un link dintr-un cadru care ma duce la un tabel cu date din baza de date astfel incat el sa se reactualizeze cu ajutorul scriptului de fiecare data cand se introduc date in baza de date?
De exemplu scriptul:
Cod: Selectaţi tot
<html>
<body background="texture3643174.gif" width="600" height="600" link="6666aa" vlink="#7757D7"alink="#7757D7">
<?php
mysql_connect("localhost", "root", "")or die("Nu ma pot conecta la server");
mysql_select_db("sitegrid")or die("Nu pot selecta baza de date");
$query="SELECT sites.id_site, sites.name, sites.id_middleware, location.id_site, location.abbrew_institute, middleware.id_middleware, middleware.middleware, vos.id_vo, vos.vo, site_vos.id_site, site_vos.id_vo, contacts.id_site, contacts.contact_name FROM sites, location, middleware, vos, site_vos, contacts WHERE((sites.id_site = location.id_site))AND ((sites.id_middleware=middleware.id_middleware))AND((vos.id_vo = site_vos.id_vo))AND ((sites.id_site = site_vos.id_site))AND((sites.id_site=contacts.id_site))ORDER BY sites.id_site ASC";
$result = mysql_query($query)or die(mysql_error());
echo "<table background=texture4991919.gif align=center width=750 frame=border bordercolor=#6666aa border=3 rules=all>";
echo "<tr align=center background=texture4991919.gif ><th align=center><font face=arial size=2 color=#6666aa><b><i>SITE</i></b></font></th><th align=center><font face=arial size=2 color=#6666aa><b><i>ABBREW. INSTITUTE</i></b></font></th><th align=center><font face=arial size=2 color=#6666aa><b><i>VOs</i></b></font></th><th align=center><font face=arial size=2 color=#6666aa><b><i>CONTACT</i></b></font></th><th align=center><font face=arial size=2 color=#6666aa><b><i>MIDDLEWARE</i></b></font></th></tr>";
while ($row = mysql_fetch_array($result))
{
echo "<tr align=center><td>";
echo $row["name"];
echo "</td><td>";
echo $row["abbrew_institute"];
echo "</td><td>";
echo $row["vo"];
echo "</td><td>";
echo $row["contact_name"];
echo "</td><td>";
echo $row["middleware"];
echo "</td></tr>";
}
echo "</table>";
?>
</body>
</html>