PHP连接MYSQL数据库-php教程-PHP中文网

PHP连接MYSQL数据库

php中文网

发布： 2016-07-29 09:06:05

原创

1346人浏览过

因为前两天某项目需要php连接mysql，虽然以前学过，但是现在基本也忘得一干二净了，不过后来查找大量资料找到了方法:

MTTSHOP包包免费商城系统

一款非常包包、衣服、鞋子类网站，页面干净清洁、一目了然，mttshop打造精致、简单、易用、免费的商城。系统要求：IIS5.1以后，必须安装.net 3.5 安装步骤： 1、下载完成后，直接解压文件mttshop.rar 2、附加数据库：解压后的可以找一个叫db的文件夹，解压后直接附加就可以，支持SQL 2000、2005、2008 3、配置web.config文件，找到key=&qu

查看详情

<?<span>php
    </span><span>//</span><span>设置字符集</span><span>header</span>('Content-Type: text/html; charset=utf8'<span>);

    </span><span>//</span><span>连接数据库</span><span>$link</span> = <span>mysql_connect</span>("localhost","root","123456"<span>);

    </span><span>if</span>(!<span>$link</span><span>){
        </span><span>echo</span> '数据库连接失败...<br>'<span>;
        </span><span>exit</span>(-1<span>);
    }</span><span>else</span><span>{
        </span><span>echo</span> "数据库连接成功...<br>"<span>;
    }

    </span><span>//</span><span>选择一个数据库作为默认数据库</span><span>mysql_select_db</span>('php_sjk'<span>);

    </span><span>//</span><span>执行sql插入语句</span><span>$sql</span> = "INSERT INTO zh VALUES (NULL,'王杰','123456')"<span>;
    </span><span>$cr</span> = <span>mysql_query</span>(<span>$sql</span><span>);

    </span><span>//</span><span>判断是否插入成功</span><span>if</span>(!<span>$cr</span><span>){
        </span><span>echo</span> "数据插入失败。<br>"<span>;
    }</span><span>else</span><span>{
        </span><span>echo</span> "数据插入成功。<br>"<span>;
    }
    
    </span><span>//</span><span>执行sql查询语句</span><span>$sql</span> = "select * from zh"<span>;
    </span><span>$cr</span> = <span>mysql_query</span>(<span>$sql</span><span>);
    
    </span><span>//</span><span>得到返回的结果集,并循环输出</span><span>echo</span> "数据展示：<br><br><br>"<span>;
    </span><span>while</span>(<span>$a</span> = <span>mysql_fetch_row</span>(<span>$cr</span><span>)){
        </span><span>echo</span> "{<span>$a</span>[0]}&mdash;&mdash;{<span>$a</span>[1]}&mdash;&mdash;{<span>$a</span>[2]}<br>"<span>;
    }

    </span><span>//</span><span>关闭数据库连接</span><span>mysql_close</span>(<span>$link</span><span>);
</span>?>

登录后复制

以上就介绍了PHP连接MYSQL数据库，包括了方面的内容，希望对PHP教程有兴趣的朋友有所帮助。