Design
Technology
Circle Gallery
‹
›
Shooting
Racing
News
Bottom
<?
mysql_connect("localhost","root","") or die("connection faild");
mysql_select_db("con") or die ("database not avi");
$id = $_GET['ide'];
$sql = "SELECT * FROM data WHERE id='$id'";
$res = mysql_query($sql);
while($rows = mysql_fetch_array($res))
{
$name = $rows['name'];
$venue = $rows['venue'];
$date = $rows['date'];
echo $name;
echo "<br>";
echo $venue;
}
/*}*/
?>
mysql_connect("localhost","root","") or die("connection faild");
mysql_select_db("con") or die ("database not avi");
$id = $_GET['ide'];
$sql = "SELECT * FROM data WHERE id='$id'";
$res = mysql_query($sql);
while($rows = mysql_fetch_array($res))
{
$name = $rows['name'];
$venue = $rows['venue'];
$date = $rows['date'];
echo $name;
echo "<br>";
echo $venue;
}
/*}*/
?>
<?php
mysql_connect("localhost","root","") or die("connection faild");
mysql_select_db("con") or die ("database not avi");
$sql = "DELETE FROM `data` WHERE `date` <= CURDATE()";
$result = mysql_query($sql) or die("Error connecting to database!");
?>
<!DOCTYPE html>
<html>
<body>
<?php
date_default_timezone_set("America/New_York");
echo "The time is " . date("h:i:sa");
?>
</body>
</html>
mysql_connect("localhost","root","") or die("connection faild");
mysql_select_db("con") or die ("database not avi");
$sql = "DELETE FROM `data` WHERE `date` <= CURDATE()";
$result = mysql_query($sql) or die("Error connecting to database!");
?>
<!DOCTYPE html>
<html>
<body>
<?php
date_default_timezone_set("America/New_York");
echo "The time is " . date("h:i:sa");
?>
</body>
</html>
<table width="1051" height="178" border="0">
<tr>
<td>Date</td>
<td>Name of the conference</td>
<td>Venue</td>
</tr>
<?php
mysql_connect("localhost","root","") or die("connection faild");
mysql_select_db("con") or die ("database not avi");
$sql = "SELECT * FROM data ORDER BY date ASC";
$res=mysql_query($sql);
WHILE($rows = mysql_fetch_object($res))
{
echo "<tr>
<td>$rows->venue</td>
<td><a href='detail.php?ide=$rows->id'>$rows->name</a></td>
<td>$rows->date</td>
</tr>";
}
?>
</table>
<?
mysql_connect("localhost","root","") or die("connection faild");Connection of the the DB
mysql_select_db("con") or die ("database not avi");Select the Database
$qry = "INSERT INTO data (id,name,venue,date) VALUES (' ','Indai','Delhi','2014-12-10')";
This Query is used to insert the datas in DB
$result = mysql_query($qry);
if($result)
{
echo "submitted";
}
else{
echo "your datas are not submitted Try Afetr Some time!";
echo mysql_error();
}
?>
mysql_connect("localhost","root","") or die("connection faild");Connection of the the DB
mysql_select_db("con") or die ("database not avi");Select the Database
$qry = "INSERT INTO data (id,name,venue,date) VALUES (' ','Indai','Delhi','2014-12-10')";
This Query is used to insert the datas in DB
$result = mysql_query($qry);
if($result)
{
echo "submitted";
}
else{
echo "your datas are not submitted Try Afetr Some time!";
echo mysql_error();
}
?>
Subscribe to:
Comments (Atom)
