Collection of some commonly used statements in php-PHP Tutorial-php.cn

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.

Related labels：

content font gt lt nbsp

source：php.cn

Previous article：Reverse proxy Nagios with Nginx Next article：php error message configuration

Statement of this Website

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