Example of simple reading of mysql by php, phpmysql example_PHP tutorial

An example of php simply reading mysql, phpmysql example

Reading mysql database

Example.

Copy the code as follows
$link=mysql_connect("localhost","root","previous administrator password");
if(!$link) echo " No connection successful!";
mysql_select_db("infosystem", $link); //Select database
$q = "SELECT * FROM info"; //SQL query statement
mysql_query("SET NAMES GB2312 ");
$rs = mysql_query($q); //Get the data set
if(!$rs){die("Valid result!");}
echo "

" ;
echo "";
while($row = mysql_fetch_array($rs)) echo "< td>$row[3]"; //Display data
echo "

Department name	Employee name	PC name
$row[1]	$row[2]

";
mysql_free_result($rs); //Close the data set
?>

Chinese display garbled problem

When we access the MySQL database through PHP in the original way, even if we set the default character set of the table to utf8 and send the query through UTF-8 encoding, you will find that the data stored in the database is still garbled.
In fact, the simplest way (www.111cn.net) is to set it up through phpMyAdmin.
Set the following items:

1: The language is set to chinese (zh-utf-8)

2: MySQL character set: UTF-8 Unicode (utf8)
3: MySQL connection proofreading: utf8_general_ci
4: When adding a new database and data table, select utf8_general_ci

With the above settings, Chinese characters will not be garbled when operating and querying in phpMyAdmin.
But you will find that the results obtained by using the previous SQL statement in the PHP program are still garbled. The problem lies in the connection layer.

The solution is to send a query statement after successfully connecting to the database:

Copy the code as follows
1: $this->LinkID = mysql_connect($this->Host, $this->User, $this->Password);
2: mysql_query( 'SET NAMES 'utf8'', $this->LinkID);
or:

DEFINE ('LINK', mysql_connect (DB_HOST, DB_USER, DB_PASSWORD));
mysql_query("SET NAMES 'utf8'", LINK);

gbk encoded

Copy the code as follows
$mysql_mylink = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
mysql_query("SET NAMES 'GBK'");

from:http:/ /www.111cn.net/phper/php-database/57069.htm

A simple PHP database insertion/reading example

if(isset($ _POST['tj']))//If you click submit
{

$conn=mysql_connect("localhost","username","password");
mysql_select_db("eastses" ,$conn);
mysql_query("set names utf8",$conn);
date_default_timezone_set("asia/chongqing");
$sql = "INSERT INTO `eastses`.`classmate` (` id`, `name`, `nickname`, `birthday`, `home`, `blood`, `qq`, `weibo`, `email`, `phone`, `hobby`, `food`, `sentence` , `gift`, `lover`, `keenon`, `unforgettable`, `wanttobecome`, `ideal`, `other`) VALUES ('".$_POST['id']."', '".$_POST ['name']."', '".$_POST['nickname']."', '".$_POST['birthday']."', '".$_POST['home']."' , '".$_POST['blood']."', '".$_POST['qq']......The rest of the text>>

php write to database example

If your database is set up, it’s easy. Use PHP to connect to your database!
$link = mysql_connect('localhost','user','pwd');//Your database username and password
mysql_query('set names utf8'); Set character set
mysql_select_db(' db');//Select your database
$sql="Here is your sql statement";
mysql_query($sql);//Send sql statement
mysql_close();//Close the connection

http://www.bkjia.com/PHPjc/886000.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/886000.htmlTechArticleAn example of simple reading of mysql by php, an example of reading mysql database by phpmysql instance. The code is as follows Copy the code ?php $link=mysql_connect("localhost","root","Previous administrator password"); if(...