Python
JavaScript
Java
C++
PHP
Sunday, November 17, 2024
Monday, August 15, 2022
Update Records Into Tables Using SQL Join Query
this query is used for update record into tables with join and where query which update all matching records.
UPDATE `product`
inner join `category` on `category`.`id` = `product`.`category_id` and `category`.`deleted_at` IS NULL
SET `product`.`category_id` = category.id WHERE `product`.`deleted_at` IS NULL AND `id` = '1'
How To install PHP 7.0 Into Ubuntu And Its Maths Functions Using CMD
this commands is used for install php 7.0 with cmd and various type of maths function
sudo apt install -y php7.0
sudo apt install -y php7.0-cli php7.0-fpm php7.0-common php7.0-json php7.0-opcache php7.0-mysql php7.0-phpdbg php7.0-mbstring php7.0-gd php7.0-pgsql php7.0-intl php7.0-curl php7.0-zip php7.0-xml php7.0-mcrypt php7.0-sqlite3 php7.0-xmlrpc php7.0-xsl
sudo sed -i "s#user = www-data#user = username#" /etc/php/7.0/fpm/pool.d/www.conf
sudo sed -i "s#group = www-data#group = username#" /etc/php/7.0/fpm/pool.d/www.conf
sudo sed -i "s#;cgi.fix_pathinfo=1#cgi.fix_pathinfo=0#" /etc/php/7.0/fpm/php.ini
sudo service php7.0-fpm restart
How To Count Duplicate Records Using SQL Query.
SELECT count_id, COUNT(count_id)
FROM select_table_name
where where_id > 1 and
GROUP BY count_id
HAVING COUNT(count_id) > 1
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>
Subscribe to:
Posts (Atom)