new mysqli("localhost","root","","maxx");
referer of connection:
$conn=new mysqli("localhost","root","","maxx");
check connection is made or not:
The connect_error() function returns the error description from the last connection error, if any.
if($conn->connect_error)
{
echo"the error is ",$conn->connect_error;
}
else
{
echo"connection is created";
}
type the query to fetch(extract) the data from a table of the selected database
$sql = "SELECT empid, name, salary FROM emp";
then execute the query and store all the entries into a variable like $result:
$qry=$conn->prepare($sql);
$qry=$conn->prepare($sql);
$qry->execute();
$result=$qry->get_result();
check the no of rows extracted from table>0 , then show the data
if ($result->num_rows > 0)
{
}
fetch data
$row=$result->fetch_assoc() is a method that is used to fetch a row at a time in the form of an associative array
example:
$row={
"id":101
"name":"sam"
"lastname": "Kumar"
}
while($row=$result->fetch_assoc())
{
echo$row["empid"];
}
at last close the connection:
$conn->close();
final code:
$conn=new mysqli("localhost","root","","maxx");
if($conn->connect_error)
{
echo"the error is ",$conn->connect_error;
}
else
{
{
echo"the error is ",$conn->connect_error;
}
else
{
$sql = "SELECT empid, name, salary FROM emp";
$qry=$conn->prepare($sql);
$qry->execute();
$result=$qry->get_result();
if ($result->num_rows > 0)
{
// output data of each row
while($row = $result->fetch_assoc())
while($row = $result->fetch_assoc())
{
echo "id: " . $row["empid"]. " - Name: " . $row["name"]. " " . $row["salary"]. "<br>";
}
}
}
}
else
{
echo "0 results";
}
echo "0 results";
}
$qry->close();
}
$conn->close();
?>
2. stop the back button of the browser:
note:
1. stop the resubmission on refreshing the page:
if ( window.history.replaceState ) {
window.history.replaceState( null, null, window.location.href );
}
2. stop the back button of the browser:
function preventBack()
{
window.history.forward();
}
setTimeout("preventBack()", 0);
window.onunload = function ()
{
null
};
0 Comments