PHP and SQL

• Please note, we will not worry about sql injection attacks yet.
• So you don't see my password
  • I grabbed this from here

    echo "Password: ";
    system('stty -echo');
    $password = trim(fgets(STDIN));
    system('stty echo');
    // add a new line since the users CR didn't echo
    echo "\n";
    
    echo "Your password is " . $password."\n";
    	 

  • See passwordGet.php
• The rest is compiled from here
• Step 1, connect to the SQL server

  $connection = new mysqli("localhost", $user, $password,$user);
      

• Step two, do a query.

  $res = $connection->query("SELECT * FROM SKU_DATA");
      

• This returns a query context. Step through it.

  while($row =  $res->fetch_assoc())
      foreach(array_keys($row) as $i) {
           print $i.": ".$row[$i]."\n";
      }
  }
      

• Close the query

        $res->close();
      

• See query1.php
• See query2.php