Friday, June 15, 2018
Wednesday, May 30, 2018
Create Program Using MySQLi & PHP To Insert, Select, Update, Delete In MySQL Database Table.
This tutorial will help you that how to perform insert, update and delete operations using PHP & MySQLi, using short functions and so low code.
I have create on insert.php file and i have all the program code write in this single file
insert.php
following are the my php and html code:
<?php
include "db.php";
if(isset($_POST['submit']) && $_POST['action'] == "add"){
extract($_POST);
$que = $con->query("insert into student(stud_name,email,password) values('$nm','$email','$pass')");
if($que){header('location:insert.php');exit();}
else{ echo "not added";}
}
if(isset($_GET['delete'])){
$del_res= $con->query("delete from student where id =".$_GET['delete']);
header('location:insert.php');
exit();
}
if(isset($_GET['edit'])){
$get_rec = $con->query('select * from student where id='.$_GET['edit'])->fetch_assoc();
//print_r($get_rec);
}
if(isset($_POST['submit']) && $_POST['action'] == "edit"){
extract($_POST);
$que = $con->query("update student set stud_name = '$nm',email='$email',password='$pass' WHERE id=".$_GET['edit']);
header('location:insert.php');
exit();
}
$result = $con->query("select * from student");
?>
<html>
<body>
<form action="" method="post">
<div>name :<input type="text" name="nm" value="<?= (isset($get_rec['stud_name'])) ? $get_rec['stud_name'] : ''; ?>"></div>
<div>email :<input type="email" name="email" value="<?= (isset($get_rec['email'])) ? $get_rec['email'] : ''; ?>"> </div>
<div>password :<input type="password" name="pass" value="<?= (isset($get_rec['password'])) ? $get_rec['password'] : ''; ?>"></div>
<div>
<input type="hidden" name="action" value="<?= isset($_GET['edit']) ? "edit":"add" ?>">
<input type="submit" name="submit">
<input type="reset" name="reset">
</div>
</form>
<table border='1' cellpadding='10' cellspacing='0'>
<tr>
<th>NO</th>
<th>Name</th>
<th>email</th>
<th>password</th>
<th>action</th>
</tr>
<?php
$i=1;
while($row = $result->fetch_assoc())
{
?>
<tr>
<td><?php echo $i; ?></td>
<td><?= $row['stud_name']; ?></td>
<td><?php echo $row['email']; ?></td>
<td><?php echo $row['password']; ?></td>
<td><a href="insert.php?delete=<?php echo $row["id"] ;?>">Delete</a> | <a href="insert.php?edit=<?php echo $row["id"] ;?>">EDIT</a></td>
</tr>
<?php
$i++;
}
?>
</table>
</body>
</html>
Thursday, April 26, 2018
What Is Layout In Android
XML-Based Layouts in Android. In Android, an XML-based layout is a file that defines the different widgets to be used in the UI and the relations between those widgets and their containers
Download PPT Here
Tuesday, April 24, 2018
What Is API In Android
There are many types of APIs. One of the most common types of APIs are Web APIs; these APIs, otherwise known as Web Services, provide an interface for web applications, or applications that need to connect to each other via the Internet to communicate.
Download PPT Here
Sunday, April 22, 2018
What is manifest file in android?
Every application must have an AndroidManifest.xml file (with precisely that name) in its root directory. The manifest presents essential information about the application to the Android system, information the system must have before it can run any of the application's code.
Download PPT Here
Friday, April 20, 2018
What is Data Mart In Data warehouse And Data mining
this PPT is about what is data mart in data warehouse and data mining learn developing.
Download PPT Here
Subscribe to:
Posts (Atom)