<?PHP
( "HOST" , "127.0.0.1" ); // server MySQL
define ( "USER" , "root" ); // user MySQL
define ( "PASS" , "" ); // password MySQL
define ( "DB" , "test" ); // dataBase MySQL
$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 ());
$sql = "SELECT name, age FROM users WHERE categ = ?" ;
$users = $mysqli -> prepare ( $sql );
$users -> bind_param ( "s" , $id );
$users -> execute ();
$users -> store_result ();
$users -> num_rows () > 0 )
$users -> bind_result ( $nameUser , $ageUser );
$users -> fetch () )
printf ( "User name: %s, Age: %s" , $nameUser , $ageUser );
printf ( "Total users: %s" , $users -> num_rows ());
printf ( "Zero users found." );
$users -> free_result ();
$users -> close ();
$mysqli -> close ();
?>
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 Specify your connection settings and create a link to a MySQL database. Categories : PHP , PHP Classes , 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 How to Insert a Date Format Into MySQL from PHP Categories : PHP , Databases , MySQL , Date Time , Beginner Guides Making a simple Hit-Log using PHP and MySql Categories : PHP , Log Files , Beginner Guides , Databases , MySQL Newbie Notes #10 - Generating drop downs Categories : PHP , MySQL , HTML , Beginner Guides , Databases for each record, do this to the first record, and do that to any subsequent record Categories : PHP , Databases , MySQL , Beginner Guides Add, Edit /Update & Delete all in one Contact Management Form Categories : PHP , MySQL , Databases , Beginner Guides mySQL/PHP/search with multientry
form and table output with colored rows Categories : PHP , Beginner Guides , MySQL , HTML and PHP , Databases bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL , PHP , MySQL , Complete Programs , Databases Cut your MySQL Connections to 1 line of code Categories : PHP , Beginner Guides , Databases , MySQL Convert a File database into MySQL Categories : PHP , Filesystem , Databases , MySQL , Beginner Guides The simple counter with use MySql and gd. Categories : MySQL , HTTP , Graphics , PHP , Databases A Simple sign up script with PHP and JavaScript validations. Categories : PHP , Java Script , MySQL , Databases
