New PHP MySQL Tutorials in Urdu/Hindi part 25 mysql connection
Save as students.php
Save as students.php
<?php
mysql_connect("localhost ","root "," "); //1st Method
mysql_select_db("school");
$con= mysql_connect("localhost ","root "," "); //2nd Method
$db=mysql_select_db("school");
$server="localhost"; //3rd Method
$user= "root";
$pass= "";
mysql_connect($server,$user,$pass);
?>
New PHP MySQL Tutorials in Urdu/Hindi part 26 inserting data into database
<html>
<head><title>Student's Data</title></head>
<body>
<form action="students.php" method="post">
<table width="500" border="5" align="center">
<tr>
<td align="center" colspan="5" bgcolor="yellow"><h1>Student's Registeration</h1></td>
</tr>
<tr>
<td align="right" >Student Name:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td align="right">School Name:</td>
<td><input type="text" name="school"></td>
</tr>
<tr>
<td align="right">Result:</td>
<td><input type="text" name="result"></td>
</tr>
<tr>
<td align="center" colspan="5"><input type="submit" name="submit" value="Submit Now"></td>
</tr></table>
</form>
</body>
</html>
<html>
<head><title>Student's Data</title></head>
<body>
<form action="students.php" method="post">
<table width="500" border="5" align="center">
<tr>
<td align="center" colspan="5" bgcolor="yellow"><h1>Student's Registeration</h1></td>
</tr>
<tr>
<td align="right" >Student Name:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td align="right">School Name:</td>
<td><input type="text" name="school"></td>
</tr>
<tr>
<td align="right">Result:</td>
<td><input type="text" name="result"></td>
</tr>
<tr>
<td align="center" colspan="5"><input type="submit" name="submit" value="Submit Now"></td>
</tr></table>
</form>
</body>
</html>
<?php
mysql_connect("localhost","root","");
mysql_select_db("localhost");
if (isset($_POST['submit'])){
$name=$_POST['name'];
$school=$_POST['school'];
$roll=$_POST['roll'];
$result=$_POST['result'];
$query= "insert into students(student_name,school_name,roll_no,result) values ('$name','$school','$roll','$result')";
if (mysql_query($query))
{
echo "<h1>Data Inserted</h1>";
}
}
?>
New PHP MySQL Tutorials in Urdu/Hindi part 28 selecting data from database
<html>
<head><title>Student's Data</title></head>
<body>
<form action="students.php" method="post">
<table width="500" border="5" align="center">
<tr>
<td align="center" colspan="5" bgcolor="yellow"><h1>Student's Registeration</h1></td>
</tr>
<tr>
<td align="right" >Student Name:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td align="right">School Name:</td>
<td><input type="text" name="school"></td>
</tr>
<tr>
<td align="right">Result:</td>
<td><input type="text" name="result"></td>
</tr>
<tr>
<td align="center" colspan="5"><input type="submit" name="submit" value="Submit Now"></td>
</tr></table>
</form>
New PHP MySQL Tutorials in Urdu/Hindi part 34 searching data in database
<form action="students.php" method="get">
<div align="right"><input type="text" name="search" placeholder="Search by roll no or name" size="40">
<input type="submit" name="search" value="Search Now"></div></form>
<?php
if(isset($_GET['search'])){
$search = $_POST['search'];
$que = "select * from students where roll_no='search' or student_name='$search'";
$run= mysql_query($que);
while($row=mysql_fetch_array($run)){
$students_name=$row['student_name'];
$school_name=$row['school_name'];
$roll_no=$row['roll_no'];
$result=$row['result'];
}
?>
<table width="600" align="center" border="0" bgcolor="orange">
<tr>
<td><?php echo $student_name; ?></td>
<td><?php echo $school_name; ?></td>
<td><?php echo $roll_no; ?></td>
<td><?php echo $result; ?></td>
</tr>
<tr>
<td colspan="5" align="center"><a href="students.php">Click OK</a></td>
</tr>
</table>
<?php } ?>
<table width="800" border="5" align="center">
<tr>
<th>Serial No:</th>
<th>Student Name:</th>
<th>School No:</th>
<th>Roll No:</th>
<th>Status</th>
<th>Delete</th>
<th>Edit</th>
</tr>
<?php
mysql_connect("localhost","root","");
mysql_select_db("localhost");
$query1 = "select * from students";
$run = mysql_query($query1);
while($row=mysql_fetch_array($run))
{
$id= $row['id'];
$s_name = $row['student_name'];
$school_name = $row['school_name'];
$roll_no = $row['roll_no'];
$s_result= $row['result'];
?>
<tr align="center">
<td><?php echo $id;?></td>
<td><?php echo $s_name;?></td>
<td><?php echo $school_name;?></td>
<td><?php echo $roll_no;?></td>
<td><?php echo $s_result;?></td>
<td>Delete</td>
<td>Edit</td>
</tr>
<?php } ?>
</table>
</body>
</html>
<?php
mysql_connect("localhost","root","");
mysql_select_db("localhost");
if (isset($_POST['submit'])){
$name=$_POST['name'];
$school=$_POST['school'];
$roll=$_POST['roll'];
$result=$_POST['result'];
$query= "insert into students(student_name,school_name,roll_no,result) values ('$name','$school','$roll','$result')";
if (mysql_query($query))
{
echo "<h1>Data Inserted</h1>";
}
}
?>
Save as students.php
Save as students.php
<?php
mysql_connect("localhost ","root "," "); //1st Method
mysql_select_db("school");
$con= mysql_connect("localhost ","root "," "); //2nd Method
$db=mysql_select_db("school");
$server="localhost"; //3rd Method
$user= "root";
$pass= "";
mysql_connect($server,$user,$pass);
?>
New PHP MySQL Tutorials in Urdu/Hindi part 26 inserting data into database
<html>
<head><title>Student's Data</title></head>
<body>
<form action="students.php" method="post">
<table width="500" border="5" align="center">
<tr>
<td align="center" colspan="5" bgcolor="yellow"><h1>Student's Registeration</h1></td>
</tr>
<tr>
<td align="right" >Student Name:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td align="right">School Name:</td>
<td><input type="text" name="school"></td>
</tr>
<tr>
<td align="right">Result:</td>
<td><input type="text" name="result"></td>
</tr>
<tr>
<td align="center" colspan="5"><input type="submit" name="submit" value="Submit Now"></td>
</tr></table>
</form>
</body>
</html>
<html>
<head><title>Student's Data</title></head>
<body>
<form action="students.php" method="post">
<table width="500" border="5" align="center">
<tr>
<td align="center" colspan="5" bgcolor="yellow"><h1>Student's Registeration</h1></td>
</tr>
<tr>
<td align="right" >Student Name:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td align="right">School Name:</td>
<td><input type="text" name="school"></td>
</tr>
<tr>
<td align="right">Result:</td>
<td><input type="text" name="result"></td>
</tr>
<tr>
<td align="center" colspan="5"><input type="submit" name="submit" value="Submit Now"></td>
</tr></table>
</form>
</body>
</html>
<?php
mysql_connect("localhost","root","");
mysql_select_db("localhost");
if (isset($_POST['submit'])){
$name=$_POST['name'];
$school=$_POST['school'];
$roll=$_POST['roll'];
$result=$_POST['result'];
$query= "insert into students(student_name,school_name,roll_no,result) values ('$name','$school','$roll','$result')";
if (mysql_query($query))
{
echo "<h1>Data Inserted</h1>";
}
}
?>
New PHP MySQL Tutorials in Urdu/Hindi part 28 selecting data from database
<html>
<head><title>Student's Data</title></head>
<body>
<form action="students.php" method="post">
<table width="500" border="5" align="center">
<tr>
<td align="center" colspan="5" bgcolor="yellow"><h1>Student's Registeration</h1></td>
</tr>
<tr>
<td align="right" >Student Name:</td>
<td><input type="text" name="name"></td>
</tr>
<tr>
<td align="right">School Name:</td>
<td><input type="text" name="school"></td>
</tr>
<tr>
<td align="right">Result:</td>
<td><input type="text" name="result"></td>
</tr>
<tr>
<td align="center" colspan="5"><input type="submit" name="submit" value="Submit Now"></td>
</tr></table>
</form>
New PHP MySQL Tutorials in Urdu/Hindi part 34 searching data in database
<form action="students.php" method="get">
<div align="right"><input type="text" name="search" placeholder="Search by roll no or name" size="40">
<input type="submit" name="search" value="Search Now"></div></form>
<?php
if(isset($_GET['search'])){
$search = $_POST['search'];
$que = "select * from students where roll_no='search' or student_name='$search'";
$run= mysql_query($que);
while($row=mysql_fetch_array($run)){
$students_name=$row['student_name'];
$school_name=$row['school_name'];
$roll_no=$row['roll_no'];
$result=$row['result'];
}
?>
<table width="600" align="center" border="0" bgcolor="orange">
<tr>
<td><?php echo $student_name; ?></td>
<td><?php echo $school_name; ?></td>
<td><?php echo $roll_no; ?></td>
<td><?php echo $result; ?></td>
</tr>
<tr>
<td colspan="5" align="center"><a href="students.php">Click OK</a></td>
</tr>
</table>
<?php } ?>
<table width="800" border="5" align="center">
<tr>
<th>Serial No:</th>
<th>Student Name:</th>
<th>School No:</th>
<th>Roll No:</th>
<th>Status</th>
<th>Delete</th>
<th>Edit</th>
</tr>
<?php
mysql_connect("localhost","root","");
mysql_select_db("localhost");
$query1 = "select * from students";
$run = mysql_query($query1);
while($row=mysql_fetch_array($run))
{
$id= $row['id'];
$s_name = $row['student_name'];
$school_name = $row['school_name'];
$roll_no = $row['roll_no'];
$s_result= $row['result'];
?>
<tr align="center">
<td><?php echo $id;?></td>
<td><?php echo $s_name;?></td>
<td><?php echo $school_name;?></td>
<td><?php echo $roll_no;?></td>
<td><?php echo $s_result;?></td>
<td>Delete</td>
<td>Edit</td>
</tr>
<?php } ?>
</table>
</body>
</html>
<?php
mysql_connect("localhost","root","");
mysql_select_db("localhost");
if (isset($_POST['submit'])){
$name=$_POST['name'];
$school=$_POST['school'];
$roll=$_POST['roll'];
$result=$_POST['result'];
$query= "insert into students(student_name,school_name,roll_no,result) values ('$name','$school','$roll','$result')";
if (mysql_query($query))
{
echo "<h1>Data Inserted</h1>";
}
}
?>