Database access: mySQL
A basic example of using mySQL with PHP.

• Home
• ›
• Code snippets
• ›
• PHP
• ›
• Database access: mySQL

Like all PHP on sloppycode.net this example was made in PHP 3.x or 4, so unfortunately isn't guaranteed to be error free anymore.

<? // Over-ride 30 second default to 1 hour set_time_limit(21600); // server params $hostname = "host"; $username = "username"; $password = "password"; $db = "database"; // Start Time echo "Started: " .date("H:i:s A") . "<br>"; // Connect to Database $conn = mysql_connect($hostname,$username,$password); $db = mysql_select_db($db,$conn); // Run query and go through all rows $SQL = "SELECT * FROM table"; $result = mysql_query($SQL) ; $i = 0; while ($RS = mysql_fetch_array($result)) { // do nothing $i++; } // Close connection mysql_close(); // Finish time echo "Finished: " .date("H:i:s A") . "<br>"; echo $i . " records found"; ?>

---

{Name}
Says:

{Date}
{Text}

› Home
› C#
› Snippets
› Articles
› Tools
› Taglines
› ASP
› Dictionary Object
› FSO
› Unix cheat sheet
› Gaming
› CSS
› Yak
› Umbraco
› About
› Contact
› Privacy
› Projects
› Search
› Sitemap