Home >Backend Development >PHP Tutorial >Collection of some commonly used statements in php

Collection of some commonly used statements in php

WBOYOriginal: 2016-07-29 09:15:251096browse

Clear the data table truncate table name;

http://blog.knowsky.com/234205.htm Commonly used SQL statement examples

http://blog.csdn.net/vericlongmore/article/details /7431029 php mysql database commonly used sql statement command collection

http://www.banghui.org/10064.html Commonly used SQL statement database that PHP novices must learn

http://blog.163.com/ lgh_2002/blog/static/440175262007102511246481/ Complete list of SQL statements

1: Connect to the database:

$conn = mys ql_connect("localhost","root","www .xunjobs.com") or die("Database connection failed".mysql_error());
mysql_select_db("db_pursey",$conn) or die("Database access failed".mysql_error());
mysql_query ("set names gb2312");
?> =$_POST[type];

$title=$_POST[title];

$c/span>

$linkman=$_POST[linkman];
$tel=$_POST[tel];
//$edate=date("Y-m-d h:i:s"); Get the system date
$edate=date("Y-m-d H:i:s");
$sql=mysql_query(" insert into tb_info(type,title,content,linkman,tel,checkstate,edate) values('$type','$title','$content','$linkman','$tel',0,'$edate ')");
if($sql){
//How to output <script> statements in php<br><spanmicrosoft yahei>echo "<script>alert('Congratulations, the information has been published successfully! ');window.location.href='release.php';</script>";
}else{
echo "<script>alert('Sorry, information release failed!');history .back();</script>";
}
?>

3: Query data

    include("conn/conn.php");
    $type=$_POST[type];
    $c/span>
    $sql1=mysql_query("select * from tb_leaguerinfo where checkstate=1 and type='$type' and (content like'%$content%' or title like'%$content%' or linkman like'%$content%' or tel like'%$content%')");
    $info1=mysql_fetch_array($sql1);
    $sql=mysql_query("select * from tb_info where checkstate=1 and type='$type' and (content like'%$content%' or title like'%$content%' or linkman like'%$content%' or tel like'%$content%')");
    $info=mysql_fetch_array($sql);
    ?>

    if($info1){
    do{
      ?>

『".$content."",$info1[type]);?>』 ".$content."",$info1[title]);?> ".$content."",$info1[edate]);?>

".$content."",$info1[content]);?>

联系人：".$content."",$info1[linkman]);?> 联系电话：".$content."",$info1[tel]);?>

    }while($info1=mysql_fetch_array($sql1));
    ?>






     if($info){
     do{
    ?>

『".$content."",$info[type]);?>』 ".$content."",$info[title]);?> ".$content."",$info[edate]);?>

".$content."",$info[content]);?>

联系人：".$content."",$info[linkman]);?> 联系电话：".$content."",$info[tel]);?>

     } while($info=mysql_fetch_array($sql));
     }
    }else{
    ?>

     if($info){
     do{
    ?>

『".$content."",$info[type]);?>』 ".$content."",$info[title]);?> ".$content."",$info[edate]);?>

".$content."",$info[content]);?>

联系人：".$content."",$info[linkman]);?> 联系电话：".$content."",$info[tel]);?>

     } while($info=mysql_fetch_array($sql));
     }else{
     ?>



                                                                                                 }
?>
Reprinted from: http://blog.csdn.net /aerchi

The above introduces the collection of some commonly used statements in PHP, including related 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：Reverse proxy Nagios with NginxNext article：Reverse proxy Nagios with Nginx

See more

您检索的信息资源不存在！

Collection of some commonly used statements in php

Related articles