Skip to main content

Fetching data into mysql AND php

LIST DATA FROM MYSQL TABLE USED PHP


<html>
<head>
<title>php and mysql by sam saifi</title>
</head>
<body>
Fetching data into mysql table on localhost
step by step
step1:- create connection to data  like $con.
step2:-select database like $db.
step3:- write query like $sql.
step4:-fetching  data in loop like while loop
step5:- create object in loop like $row.
step6:-execute object with table colum name like $row['name'];

<?
$con = mysql_connect("localhost","sam","") or die(mysql_error());// here  sam is  user name
$db = mysql_select_db("sam");//here sam is data base name
$sql = "SELECT * FROM cust";
$query = mysql_query($sql) or die ("error Query [".$sql."]");
?>
<table   >
  <tr>
    <th  > <div >id </div></th>
    <th  > <div >name </div></th>
    <th  > <div >e-mail </div></th>
    <th  > <div >School </div></th>
   </tr>
<?
while($row = mysql_fetch_array($query))
{
?>
  <tr>
    <td><div ><?php $row["id"];?></div></td>
    <td><?php $row["name"];?></td>
    <td><?php $row["e-mail"];?></td>
    <td><div ><?php $row["School"];?></div></td>
   </tr>
<?
}
?>
</table>
<?
mysql_close($con);
?>
</body>
</html>
<!--- php tutorials with sam saifi -->

Comments

Popular posts from this blog

how send mail using Swift mailer | switmailer send mail tutorial

how send mail using Swift mailer | switmailer send mail tutorial  <?php /* step 1 include Swift mailer file ;  */ include("vendor/swiftmailer/swiftmailer/lib/swift_required.php"); /* step 2 create your user details */ $senderEmail="saddam1234321@gmail.com"; $senderPassword="****Your password****"; $senderName="Saddam huassin"; /* step 3 set SMTP host  for sending mail  */ $user = Swift_SmtpTransport::newInstance('smtp.gmail.com','587','tls'); /* step 4 set your user details  */ $user->setUsername($senderEmail); $user->setPassword($senderPassword); /* step 5 create swift  mailer instance with a variable */ $mailer = Swift_Mailer::newInstance($user); /* step 6 Create a message */ $message = Swift_Message::newInstance('Wonderful Subject')   ->setFrom(array($senderEmail => $senderName))   ->setTo(array($senderEmail))   ->setBody('Here is the message itsel...

Minimum and maximum number with - and + 500 in Mysql and Sql query and Find out table scheema of our database in Mysql and sql query and Find out all table name of our database in Mysql and sql query and Find out current date and time in mysql and sql help of sql query

Minimum and maximum number with - and + 500 in Mysql and Sql query:- syntax:-  SELECT MIN(Used)-500 , max(Used)+500 FROM audit Find out current date and time in mysql and sql help of sql query:- syntax:- SELECT now() Find out database name in Mysql and sql query:- syntax:-  SELECT DATABASE(); Find out all table name of our database in Mysql and sql query:- syntax:- SHOW TABLES; Find out   table scheema   of our database in Mysql and sql query:- syntax:- DESCRIBE <table name>;