php - Connect MySQL database with webservice -
i want connect mysql database webservice. followed tutorial, not work. have no idea, why it's not workiing. table built, should filled vaues database. want diplay it. anybaody have idea? src-code:
enter code here <!doctype html public "-//w3c//dtd html 4.01 transitional//en" "http://www.w3.org/tr/html4/loose.dtd"> <html> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> <title>insert title here</title> </head> <body> <?php $mysqlhost="localhost"; // mysql-host angeben $mysqluser="root"; // mysql-user angeben $mysqlpwd="webservice"; // passwort angeben $mysqldb="**********"; // gewuenschte datenbank angeben $connection=mysql_connect($mysqlhost, $mysqluser, $mysqlpwd) or die ("verbindungsversuch fehlgeschlagen"); mysql_select_db($mysqldb, $connection) or die("konnte die datenbank nicht waehlen."); mysql_select_db( mysql_datenbank ) or die("auswahl der datenbank fehlgeschlagen"); $sql="select * car"; $adressen_query = mysql_query($sql) or die("anfrage nicht erfolgreich"); ?> <table cellpadding="1" cellspacing="3" border="1"> <tr> <td>id</td> <td>producer</td> <td>type</td> <td>bj</td> <td>hp</td> <td>mileage</td> </tr> <?php while ($adr = mysql_fetch_array($adressen_query)){ ?> <tr> <td><?=$adr['id']?></td> <td><?=$adr['producer']?></td> <td><?=$adr['type']?></td> <td><?=$adr['bj']?></td> <td><?=$adr['hp']?></td> <td><?=$adr['mileage']?></td> </tr> <?php } ?> </table> </body> </html>
Comments
Post a Comment