How does php display mysql database records. Php Tutorial how to show mysql tutorial database tutorial record ** Createdon2010-4-25 ** Tochangethetemplateforthisgeneratedfilegoto * Window-Preferences-PHPeclips tutorial e-php Tutorial how to show mysql tutorial database tutorial record
/*
* Created on 2010-4-25
*
* To change the template for this generated file go
* Window-Preferences-PHPeclips tutorial e-PHP-Code Templates
*/
$ Conn = mysql_connect ('localhost', 'root ','');
Mysql_select_db ('member', $ conn );
$ SQL = "select * from user_list ";
$ Query = mysql_query ($ SQL );
While ($ row = mysql_fetch_array ($ query ))
{
?>
Id: User: |
Password: |
"> Delete
Database structure, copy this code to phpmyadmin to run
SET SQL _MODE = "NO_AUTO_VALUE_ON_ZERO ";
--
-- Database: 'member'
--
----------------------------------------------------------
--
-- Table structure 'user _ list'
--
Create table 'user _ list '(
'Uid' int (11) not null auto_increment,
'M _ id' varchar (5) not null,
'Username' varchar (25) not null,
'Password' varchar (64) not null,
Primary key ('uid ')
) ENGINE = MyISAM default charset = gb2312 AUTO_INCREMENT = 11;
--
-- Export the table data 'user _ list'
--
Insert into 'user _ list' ('uid', 'M _ id', 'username', 'password') VALUES
(9, '1', 'admin', '75cf565ad38d0f837c43363e402b1a00 '),
(10, '2', 'admin2', '75cf565ad38d0f837c43363e402b1a00 ');
Creating/** Created on ** To change the template for this generated file go to * Window-Preferences-PHPeclips tutorial e -...