jueves, 12 de marzo de 2015

MySQLi Procedural

Simple connection to the database using this extension mysqli.
<?php //conection: $link = mysqli_connect("myhost","myuser","mypassw","mybd") or die("Error " . mysqli_error($link));
//consultation:
$query = "SELECT name FROM mytable" or die("Error in the consult.." . mysqli_error($link));
//execute the query.
$result = $link->query($query);
//display information:
while($row = mysqli_fetch_array($result)) {
  echo
$row["name"] . "<br>";
}
?>
or

<?php //conection: $link = mysqli_connect("myhost","myuser","mypassw","mybd") or die("Error " . mysqli_error($link));
//consultation:
$query = "SELECT name FROM mytable" or die("Error in the consult.." . mysqli_error($link));
//execute the query.
$result = mysqli_query($link, $query);
//display information:
while($row = mysqli_fetch_array($result)) {
  echo
$row["name"] . "<br>";
}
?> 



http://php.net/manual/en/function.mysqli-connect.php

http://php.net/manual/en/mysqli.construct.php 

No hay comentarios:

Publicar un comentario