SystemWebTech Online: April 2017

MySqli_2 Edit Update Records

New PHP MySQL Tutorials in Urdu/Hindi part 32 editing-updating records in database

<?php

mysql_connect("localhost","root","");
mysql_select_db("school");
$edit_record = $_GET['edit'];

$query = "select * from students where id='$edit_record'";

$run = mysql_query($query);

while ($row=mysql_fetch_array($run)){

$edit_form = $row['id']; $s_name = $row['student_name'];
$school_name = $row['school_name'];
$roll_no = $row['roll_no '];
$result = $row['result'];

}

?> <html>
<head><title>Student's Data</title></head>
<body>
<form action="edit.php?edit_form=<?php echo $edit_id;?>" method="post">
<table width="500" border="5" align="center">
<tr>
<td align="center" colspan="5" bgcolor="yellow"><h1>Updating Records</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" value="<?php echo $school_name; ?>"></td>
</tr>
<tr>
<td align="right">Roll No:</td>
<td><input type="text" name="roll" value="<?php echo $roll; ?>"></td>

</tr>
<tr>
<td align="right">Result:</td>
<td><input type="text" name="result" value="<?php echo $result; ?>"></td>
</tr>

<td align="center" colspan="5"><input type="submit" name="update" value="Update Now"></td>

</tr>

</table>
</form>

<h1 align="center"><?php echo @$_GET['deleted'];?></h1>
<h1 align="center"><?php echo @$_GET['Updated'];?></h1>

<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><a href="delete.php?del=<?php echo $id;?>">Delete</a></td>
<td><a href="Edit.php?edit=<?php echo $id;?>">Edit</a></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>";
}
}

?>

<?php

if (isset($_POST['update'])){

$edit_id1 = $_GET['edit_form'];

$name= $_POST['name'];
$school= $_POST['school'];
$roll= $_POST['roll'];
$result= $_POST['result'];

$query1 = "update students set student_name='$name', school_name='$school', roll_no='$roll', result='$result' where id= '$edit_id1' ";

if (mysql_query($query1)){

header("location: students.php?updated=Data has been updated..")

}

}

?>

Edit.php
<?php
mysql_connect("localhost","root","");
mysql_select_db("school");

$delete_id= $_GET['del'];
$query = "delete from students where id= '$delete_id'";

if (mysql_query($query)){

echo "<script>window.open('students.php?deleted=data has been deleted...','_self')</script>";

}

?>

MySqli_1 Delete

New PHP MySQL Tutorials in Urdu/Hindi part 30 deleting 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>

<h1 align="center"><?php echo @$_GET['deleted'];?></h1><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><a href="delete.php?del=<?php echo $id;?>">Delete</td>
<td>Edit<a href="Edit.php?edit=<?php echo $id;?>"></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>";
}
}

?>

Delete.php
<?php
mysql_connect("localhost","root","");
mysql_select_db("school");

$delete_id= $_GET['del'];
$query = "delete from students where id= '$delete_id'";

if (mysql_query($query)){

echo "<script>window.open('students.php?deleted=data has been deleted...','_self')</script>";

}
?>

MySqli

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>";
}
}

?>

Java

Java Programming in Urdu/Hindi Part 2 of 60 Installation & Path Setting

Text Editor- Notepad++
Jdk- Java developer kit
JRE- Java Runtime Environment
Setting path

google jdk download
download jdk according to your system - 32bit/64bit
It will download automatically at C Drive
Goto C Drive then Program Files then Java folder then Click jdk folder then Click Bin Folder and Copy Path: C:\Program Files\Java\jdk1.8.0_91\bin

At Windows 10 , Network & Settings then System then Advance System Settings then Advance then Environment Variables then System Variable Click New

Give Vaiable Name: Path Variable value: C:\Program Files\Java\jdk1.8.0_91\bin

Java Programming in Urdu/Hindi Part 3 of 60 Hello World

How to write a program
How to Compile Java Program
How to Run a Program

public class Example
{

public static void main(String args[])
{

System.out.println("Hello World");
}

}

Save as your class name like Example.java

Open command prompt

cd desktop
javac Example.java
Write down java Example then get Output

Java Programming in Urdu/Hindi Part 4 of 60 Variables & Data Types

Variable
Data Types
Keyword

public class Example1
{

public static void main(String args[])
{
int a= 5;
double a= 5.6;
System.out.println("Value is -"+a);
}

}

Compile:
command prompt
cd desktop
javac Example1.java
java Example1

Java Programming in Urdu/Hindi Part 5 of 60 Arithmatic Operators

public class Example1
{

public static void main(String args[])
{
int a= 5;
int b= 2;
int c= a+b;
int d= a-b;
int e= a*b;
int f= a/b;
int g= a%b;
int h= a++;
int i= a+-;
System.out.println("Value is -"+c);
System.out.println("Value is -"+d);
System.out.println("Value is -"+e);
System.out.println("Value is -"+f);
System.out.println("Value is -"+g);
System.out.println("Value is -"+h);
System.out.println("Value is -"+i);
}
}

Java Programming in Urdu/Hindi Part 7 of 60 If-else statement

public class Example1
{

public static void main(String args[])
{
int marks= 56;

if (marks>=50){System.out.println("Passed");}
else {System.out.println("Failed");}
}

}

Pages

MySqli_2 Edit Update Records

MySqli_1 Delete

MySqli

Java