How to make a query statement using php-PHP Problem-php.cn

Home

Backend Development

PHP Problem

How to make a query statement using php

Nov 18, 2022 am 09:23 AM

php

How to use PHP to make a query statement: 1. Create a PHP sample file; 2. Use mysqli_connect to connect to the database; 3. Pass "$q = "SELECT * FROM user WHERE gender = '".$gender ."'";$result = mysqli_query($db,$q);" statement can be used to implement the query.

How to make a query statement using php

The operating environment of this tutorial: Windows 7 system, PHP version 8.1, Dell G3 computer.

How to use php to make a query statement?

php uses select statements to query data information

&lt;html&gt;
&lt;head&gt;
   &lt;title&gt;Finding User&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
  &lt;h2&gt;Finding users from mysql database.&lt;/h2&gt;
  &lt;form action=&quot;selectformhandler.php&quot; method=&quot;post&quot;&gt;
     Select gender:
     &lt;select name=&quot;gender&quot;&gt;
       &lt;option value=&quot;male&quot;&gt;man&lt;/option&gt;
       &lt;option value=&quot;female&quot;&gt;woman&lt;/option&gt;
     &lt;/select&gt;&lt;br /&gt;    
     &lt;input name=&quot;submit&quot; type=&quot;submit&quot; value=&quot;Find&quot;/&gt;
  &lt;/form&gt;
&lt;/body&gt;
&lt;/html&gt;

Copy after login

&lt;html&gt;
&lt;head&gt;
   &lt;title&gt;User found&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
   &lt;h2&gt;User found from mysql database.&lt;/h2&gt;
&lt;?php
    $gender = $_POST[&#39;gender&#39;];
    if(!$gender){
        echo &quot;Error: There is no data passed.&quot;;
        exit;
    }
    if(!get_magic_quotes_gpc()){
        $gender = addslashes($gender);
    }
        @ $db = mysqli_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;12345678&#39;);
        mysqli_select_db($db,&#39;testphp&#39;);
        if(mysqli_connect_errno()){
         echo &quot;Error: Could not connect to mysql database.&quot;;
         exit;
        }
        $q = &quot;SELECT * FROM user WHERE gender = &#39;&quot;.$gender.&quot;&#39;&quot;;
        $result = mysqli_query($db,$q);
        $rownum = mysqli_num_rows($result);
        for($i=0; $i&lt;$rownum; $i++){
           $row = mysqli_fetch_assoc($result);
           echo &quot;Id:&quot;.$row[&#39;id&#39;].&quot;&lt;br /&gt;&quot;;
           echo &quot;Name:&quot;.$row[&#39;name&#39;].&quot;&lt;br /&gt;&quot;;
           echo &quot;Age:&quot;.$row[&#39;age&#39;].&quot;&lt;br /&gt;&quot;;
           echo &quot;Gender:&quot;.$row[&#39;gender&#39;].&quot;&lt;br /&gt;&quot;;
           echo &quot;Info:&quot;.$row[&#39;info&#39;].&quot;&lt;br /&gt;&quot;;
        }
        mysqli_free_result($result);
        mysqli_close($db);
?&gt;
&lt;/body&gt;
&lt;/html&gt;

Copy after login

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to make a query statement using php. For more information, please follow other related articles on the PHP Chinese website!

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