Mysqli examples

Comments:

• Dude, 02.08.21 15:39

  Hello ,I need subcategory when I click in category(food,milk) then show me subcategory(food1,food2), Do you know how I can fix this?

• eljaydee, 12.04.20 04:28

  I cannot make this work: I have been told a million times to "review you query" but cannot find the issue. The query returns desired results on cmd line: <?php

       $dbhost = 'localhost:3306';
       $dbuser = 'root';
       $dbpass = 'oreo';
       $dbname = '650M';
       $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbname);
  
       if(! $conn ) {
          die('Could not connect: ' . mysqli_error());
       }
       echo 'Connected successfully. <br> Here are the results of your query:<br><br>';
       $A=$_POST["A"];
       $B=$_POST["B"];
  
       $sql = 'SELECT * FROM blah1 WHERE A = $_POST["A"]=2 AND B = $_POST["B"]';
       $result = mysqli_query($conn, $sql);
  
       if (mysqli_num_rows($result) > 0) {
          while($row = mysqli_fetch_array($result)) {
             echo $row["blah2"]. ", &nbsp;";
          }
       } else {
          echo "0 results";
       }
       mysqli_close($conn);
        ?>