How to use PHP & Access (odbc) Random Rows Data This is tutorial php developers how to using PHP connect to Microsft Access and ramdom data from table.
ShotDev Focus:
- PHP & Microsoft Access (Random data)
Example
php_access_random.php
- <html>
- <head>
- <title>ShotDev.Com Tutorial</title>
- </head>
- <body>
- <?
- $objConnect = odbc_connect("mydatabase","","");
- $strSQL = "SELECT TOP 2 * FROM customer ORDER BY Rnd([CustomerID]) ";
- $objExec = odbc_exec($objConnect, $strSQL) or die ("Error Execute [".$strSQL."]");
- ?>
- <table width="600" border="1">
- <tr>
- <th width="91"> <div align="center">CustomerID </div></th>
- <th width="98"> <div align="center">Name </div></th>
- <th width="198"> <div align="center">Email </div></th>
- <th width="97"> <div align="center">CountryCode </div></th>
- <th width="59"> <div align="center">Budget </div></th>
- <th width="71"> <div align="center">Used </div></th>
- </tr>
- <?
- while($objResult = odbc_fetch_array($objExec))
- {
- ?>
- <tr>
- <td><div align="center"><?=$objResult["CustomerID"];?></div></td>
- <td><?=$objResult["Name"];?></td>
- <td><?=$objResult["Email"];?></td>
- <td><div align="center"><?=$objResult["CountryCode"];?></div></td>
- <td align="right"><?=$objResult["Budget"];?></td>
- <td align="right"><?=$objResult["Used"];?></td>
- </tr>
- <?
- }
- ?>
- </table>
- <?
- odbc_close($objConnect);
- ?>
- </body>
- </html>
Create a php file and save to path root-path/myphp/
Run
http://localhost/myphp/php_access_random.php
Screenshot