The relationship between php and Mysql and some simple operations, phpmysql relationship

The relationship between php and Mysql and some simple operations, phpmysql relationship_PHP tutorial

WBOY

Release： 2016-07-13 10:06:13

Original

1187 people have browsed it

The relationship between php and Mysql and some simple operations, phpmysql relationship

Post the code first

<html>
    <head>
        <title>数据库相关</title>
    </head>
<body>

<?<span>php

    </span><span>$con</span> = <span>mysql_connect</span>("localhost","root","root"); <span>//</span><span>链接数据库</span>
        <span>if</span>(!<span>$con</span><span>){
            </span><span>die</span>('连接失败！' . <span>mysql_error</span>());       <span>//</span><span>判断是否成功</span>
<span>        }     
        
</span><span>/*</span><span>        if(mysql_query("CREATE DATABASE testdb",$con)){ //通过mysql_query 查询或者发送命令
            echo "创建testdb成功";                   
        }
        else{
            echo "失败原因：" . mysql_error();         //判断是否创建成功
        }
</span><span>*/</span>    
    
        <span>mysql_select_db</span>("testdb",<span>$con</span>);               <span>//</span><span>选择链接刚刚创建的数据库</span>
            
            <span>$sql</span> = "<span>CREATE TABLE Persons               
               (personID int NOT NULL AUTO_INCREMENT, 
                PRIMARY KEY(personID),
                FirstName varchar(15),
                LastName varchar(15),
                Age int)
            </span>";                                        <span>//</span><span>Mysql 语句 创建表</span>
        <span>mysql_query</span>(<span>$sql</span>,<span>$con</span>);                          <span>//</span><span>执行sql语句</span>
        
        
        
    <span>mysql_close</span>(<span>$con</span>);                                <span>//</span><span>关闭mysql连接</span>
    
?> 

</body>
</html>

Copy after login

The key content is

1. Link database

2. Create table

3. Enrich the content of the table according to needs