Table of Contents
php中一些常用的语句收集,php常用语句收集
Home php教程 php手册 php中一些常用的语句收集,php常用语句收集

php中一些常用的语句收集,php常用语句收集

Jun 13, 2016 am 08:54 AM
php

php中一些常用的语句收集,php常用语句收集

清空数据表   truncate 表名;

http://blog.knowsky.com/234205.htm    常用的SQL语句实例

http://blog.csdn.net/vericlongmore/article/details/7431029   php mysql数据库常用sql语句命令集合

http://www.banghui.org/10064.html     PHP新手必学的常用SQL语句 数据库

http://blog.163.com/lgh_2002/blog/static/440175262007102511246481/    SQL语句大全  

 

 

 

1:连接数据库:


$conn = mysql_connect("localhost","root","www.xunjobs.com") or die("数据库连接失败".mysql_error());
mysql_select_db("db_pursey",$conn) or die("数据库访问失败".mysql_error());
mysql_query("set names gb2312");
?>

2:插入数据:


include("conn/conn.php");
$type=$_POST[type];
$title=$_POST[title];
$content=$_POST[content];
$linkman=$_POST[linkman];
$tel=$_POST[tel];
//$edate=date("Y-m-d h:i:s");获得系统日期
$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){
//php中输出<script>语句的方法</script>
echo "<script>alert('恭喜您,信息发布成功!');window.location.href='release.php';</script>";
}else{
echo "<script>alert('对不起,信息发布失败!');history.back();</script>";
}
?>

3:查询数据


    include("conn/conn.php");
    $type=$_POST[type];
    $content=$_POST[content];
    $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{
     ?>
             
                   
                     
                   
                 
您检索的信息资源不存在!

   
     }
    }
      ?>

转自:http://blog.csdn.net/aerchi

 

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

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

CakePHP Date and Time

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

CakePHP Project Configuration

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

CakePHP File upload

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

CakePHP Routing

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

Discuss CakePHP

How To Set Up Visual Studio Code (VS Code) for PHP Development How To Set Up Visual Studio Code (VS Code) for PHP Development Dec 20, 2024 am 11:31 AM

How To Set Up Visual Studio Code (VS Code) for PHP Development

CakePHP Quick Guide CakePHP Quick Guide Sep 10, 2024 pm 05:27 PM

CakePHP Quick Guide

See all articles