Php connection and common code for reading and writing mysql database, php writing mysql database

Php connection and common code for reading and writing mysql database, php writing mysql database_PHP tutorial

WBOY

Release： 2016-07-13 10:21:01

Original

1015 people have browsed it

Common code for Php connection and reading and writing mysql database, php writes mysql database

Since you have read this article now, it means that you must know what PHP and MySQL are, so I won’t go into details. But why are you continuing to read this article? Maybe you were used to copying and pasting some codes before, and didn’t really understand the meaning of the code; maybe you understood it before, but like me, you haven’t been in contact with it for a while and are rusty; or someone asked you something simple like this Question, but you didn’t bother to answer it, just searched online, and happened to find this article, so I recommended it to so and so...

Anyway, here I summarize the commonly used methods of connecting PHP to MySQL database and reading and writing to the database. I hope it can help you, and of course it is also used as a review summary for myself.

1. In order to better set up the data connection, the values involved in the data connection are generally defined as variables.

$mysql_server_name='localhost'; //改成自己的mysql数据库服务器

$mysql_username='root'; //改成自己的mysql数据库用户名

$mysql_password='123456'; //改成自己的mysql数据库密码

$mysql_database='Mydb'; //改成自己的mysql数据库名

Copy after login

You can also put the above variables in a file, which can be called by other files at any time.

For example: put the above content in: db_config.php and call it directly on other pages that need to use the database.

Calling code: require("db_config.php");

2. Connect to the database

$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) or die("error connecting") ; //连接数据库

mysql_query("set names 'utf8'"); //数据库输出编码 应该与你的数据库编码保持一致.南昌网站建设公司百恒网络PHP工程师建议用UTF-8 国际标准编码.

mysql_select_db($mysql_database); //打开数据库

$sql ="select * from news "; //SQL语句

$result = mysql_query($sql,$conn); //查询

Copy after login

　 3. Read the contents of the table. Here we use while, but you can use for or others according to the specific situation.

while($row = mysql_fetch_array($result))

{

echo "<div style=\"height:24px; line-height:24px; font-weight:bold;\">"; //排版代码

echo $row['Topic'] . "<br/>";

echo "</div>"; //排版代码

}

Copy after login

　 4.php writes to database, Mysql data writing

$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); //连接数据库

mysql_query("set names 'utf8'"); //数据库输出编码

mysql_select_db($mysql_database); //打开数据库

$sql = "insert into messageboard (Topic,Content,Enabled,Date) values ('$Topic','$Content','1','2011-01-12')";

mysql_query($sql);

mysql_close(); //关闭MySQL连接

Copy after login

php connects to mysql, how to use php code to write data to the database?》??

Connection: mysql_connect("Host","User","Password");
mysql_select_db("Database name");

Write data: mysql_query("insert into table name(field 1, field 2) values ("data 1", "data 2")");

Your question is too vague, so I can only give you this answer. If you don't understand, ask further.

php reads txt text and writes it to mysql database

/*
Take data.txt as an example
When data is stored in a text document
fputs("data.txt","$str1\t $str2\r\n");
In this form!
*/
$str = file_get_contents("data.txt") or die("File opening failed");
$ r = explode("\r\n",$str);
/*
....Connect to the database
*/
$sql = "insert into `table`('id' ,'num') values ('".$r[0]."','".$r[1]."')";
mysql_query($sql);

// The above code has not been tested. If you have any questions, please ask me
?>