search

Home >Backend Development >PHP Tutorial >The relationship between php and Mysql and some simple operations

The relationship between php and Mysql and some simple operations

WBOY
WBOYOriginal
2016-08-08 09:29:26869browse

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>

The key content is

1. Link database

2. Create table

3. Enrich the content of the table according to your needs

The above introduces the relationship between php and Mysql and some simple operations, including the content. I hope it will be helpful to friends who are interested in PHP tutorials.

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：PHP performance analysis (001)-str_repeat ($input, $multiplier)Next article：PHP performance analysis (001)-str_repeat ($input, $multiplier)

Related articles

See more