|
|
|
|
<?PHP
define ("HOST", "127.0.0.1"); // server MySQL
define ("USER", "root");// user MySQL
define ("PASS", "");// password MySQL
define ("DB", "test");// dataBase MySQL
// Get the id. www.test.com/?category=21
$id = $_GET['category'];
$mysqli = mysqli_init();// create a connection object
@$mysqli->real_connect (HOST, USER, PASS, DB); // connect
if ( mysqli_connect_errno () )
{
printf ("Connect failed: %s\n", mysqli_connect_error());
exit();
}
$sql = "SELECT name, age FROM users WHERE categ = ?";
$users = $mysqli->prepare($sql);
$users->bind_param("s", $id);
$users->execute();
$users->store_result();
if ( $users->num_rows() > 0 )
{
$users->bind_result($nameUser, $ageUser);
while ( $users->fetch() )
{
printf ("User name: %s, Age: %s", $nameUser, $ageUser);
}
printf ("Total users: %s", $users->num_rows());
}
else
{
printf ("Zero users found.");
}
$users->free_result();
$users->close();
$mysqli->close();
?> | |
|
| for each record, do this to the first record, and do that to any subsequent record
Categories : PHP, Databases, MySQL, Beginner Guides | | | Convert a File database into MySQL
Categories : PHP, Filesystem, Databases, MySQL, Beginner Guides | | | Newbie Notes #4 - Trapping dumb MySQL query errors
Categories : PHP, Databases, MySQL, Debugging, Beginner Guides | |
| | email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | How to Insert a Date Format Into MySQL from PHP
Categories : PHP, Databases, MySQL, Date Time, Beginner Guides | | | Newbie Notes #10 - Generating drop downs
Categories : PHP, MySQL, HTML, Beginner Guides, Databases | | | This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server.
Categories : Databases, MySQL, Complete Programs, PHP, Databases | | | Making a simple Hit-Log using PHP and MySql
Categories : PHP, Log Files, Beginner Guides, Databases, MySQL | | | Specify your connection settings and create a link to a MySQL database.
Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | phpFormGenerator for Dynamic Form Generation from MySQL
Categories : PHP, PHP Classes, MySQL, Databases, HTML and PHP | | | Zip code range and distance calculation class v1.0.0
Categories : PHP, Databases, MySQL, Zip Code | | | PHP Calendar Web App
Categories : PHP, Databases, MySQL, Date Time, Calendar | |
|
|
