Home > php教程 > php手册 > body text

MYsqli 绑定插入与查询实例,mysqli实例

WBOY
Release: 2016-06-13 09:29:42
Original
1144 people have browsed it

MYsqli 绑定插入与查询实例,mysqli实例

<?<span>php
    </span><span>$conn</span> = <span>new</span> mysqli('localhost','root','','orders'); <span>//</span><span>连接</span>
    <span>$prepare</span> = "insert into t100 values (?,?,?)";<span>//</span><span>预设插入sql</span>
    <span>$bind</span> = <span>$conn</span>->prepare(<span>$prepare</span><span>);
    </span><span>$t1</span> = <span>NULL</span><span>;
    </span><span>$t2</span> = 'Www'<span>;
    </span><span>$t3</span> = <span>date</span>('Y-m-d H:i:s'<span>);
    </span><span>$bind</span>->bind_param('iss',<span>$t1</span>,<span>$t2</span>,<span>$t3</span>); <span>//</span><span>绑定
    //注意iss:
    //i为int,s为string类型;意思是强制这几个参数的类型</span>
    <span>$bind</span>->execute();<span>//</span><span>执行</span>

    <span>$prepare</span> = "select * from t100"; <span>//</span><span>准备要查询的语句</span>
    <span>$bind</span> = <span>$conn</span>->prepare(<span>$prepare</span>);<span>//</span><span>预处理</span>
    <span>$t1</span> = 10<span>;
    </span><span>$bind</span>->execute();<span>//</span><span>执行</span>
    <span>$bind</span>->bind_result(<span>$id</span>, <span>$name</span>, <span>$date</span>);<span>//</span><span>将字段列绑定到变量上</span>
    <span>$bind</span>->store_result();<span>//</span><span>获取结果集</span>
    <span>while</span> (<span>$bind</span>->fetch()){<span>//</span><span>遍历</span>
        <span>printf</span>("%d == %s == %s<br />",<span>$id</span>,<span>$name</span>,<span>$date</span>);<span>//</span><span>输出</span>
    }
Copy after login

 

Gridview绑定数据后怎实现数据的查询功可以?

string cmdText="select * from 表 where 字段==所查询数据"
SqlConnection con = new SqlConnection(ConnString);

SqlDataAdapter sda = new SqlDataAdapter(cmdText, con);
DataSet dt = new DataSet();
sda.Fill(dt);
this.GridView1.DataSource = dt.table[0];//dt.DefaultView();
this.GridView1.DataBind();
你试试,我一般是这样写绑定的。
 

怎让PHP 在HTML中数据绑定 实例 贡献所有解

不就是分页咯,有现成的 要的话 给你
462626946
 

Related labels:
source:php.cn
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
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!