********小心新手********编辑和删除mysqldatabase [英] ********Caution Newbie********editing and deleting from mysqldatabase
问题描述
Show.php - 用于显示数据库中可用的电影名称
<?php
包括auth.php;
$ query =" SELECT movie_id,movie_name FROM moviesite" ;;
$ result = mysql_query($ query,$ link)或die(不能执行
查询" .mysql_error());
while($ row = mysql_fetch_array($ result))
{
$ movie_id = $ row [''movie_id''];
$ movie_name = $ row [''movie_name''];
echo $ movie_id;
echo $ movie_name;
?>
< a href =" update.php?action = edit& id =<?php echo $ movie_id; ?>
"> [更新]< / a ---我不确定...我该怎么办才能更新和
删除记录'来自数据库 - 用户选择要更新的记录
并删除
< a href =" delete.php?action = delete& id =<? php echo $ movie_id; ?>
"> [DELETE]< / a>
<?php
echo" <峰; br /" ;
}
?>
< a href =" add.php"> [ADD]< ; / a>
Add.php ---这是用于添加电影名称
<?php
包括auth.php ;;
$ id = $ _ POST [''movie_id''];
$ movie_name = $ _ POST [''movie_name''];
$ query =" INSERT INTO moviesite(movie_id,movie_name)VALUES(''$ id
'',''$ movie_name'')" ;
$ sql = mysql_query($ query);
if(!$ sql)
{
die (无法执行querey.mysql_error());
}
echo"已添加到数据库中;;
mysql_close($ link);
?>
< a href =" show.php"> Index< / a>
现在这是我正在努力删除和更新的脚本。
现在据我所知,我必须将Movie_id传递给
删除.php页面,然后使用此变量将其删除..
但是当我执行它时使用此脚本我的整个列表都被删除了。
<?php
包括auth.php;
if($ _ REQUEST [''action''] == delete)
{
$ query =" DELETE FROM moviesite where movie_id =''$ movie_id''LIMIT 1" ;;
$ sql = mysql_query( $ query)或死(不能删除.mysql_error());
}
?>
< a href =" show.php">电影< / a>
让我知道我做错了什么......以及确切的奇怪很喜欢这个概念。
感谢'并且提前。
Baldaris
query =" SELECT movie_id,movie_name FROM moviesite" ;;
result = mysql_query(
查询,
Show.php--This is for showing movie names available in database
<?php
include "auth.php";
$query="SELECT movie_id,movie_name FROM moviesite";
$result=mysql_query($query,$link) or die("Can''t execute
query" .mysql_error());
while($row=mysql_fetch_array($result))
{
$movie_id=$row[''movie_id''];
$movie_name=$row[''movie_name''];
echo $movie_id;
echo $movie_name;
?>
<a href="update.php?action=edit&id=<?php echo $movie_id; ?>
">[UPDATE]</a ---I am not sure... What can i do to update and
delete record''s from database -- User chooses which record to update
and delete
<a href="delete.php?action=delete&id=<?php echo $movie_id; ?>
">[DELETE]</a>
<?php
echo " <br/" ;
}
?>
<a href="add.php">[ADD]</a>
Add.php ---This is for adding movie names
<?php
include "auth.php";
$id=$_POST[''movie_id''];
$movie_name=$_POST[''movie_name''];
$query="INSERT INTO moviesite (movie_id , movie_name) VALUES ('' $id
'' , '' $movie_name'' ) " ;
$sql=mysql_query($query);
if (!$sql)
{
die("Can not execute querey" .mysql_error());
}
echo "Added to the database";
mysql_close($link);
?>
<a href="show.php">Index</a>
Now this is the script which i am struggling with delete and update.
Now as far as i can understand i have to pass Movie_id to the
delete.php page and then use this variable to delete it..
But with this script when i execute it my entire list get''s deleted.
<?php
include "auth.php";
if($_REQUEST[''action'']==delete)
{
$query="DELETE FROM moviesite where movie_id='' $movie_id '' LIMIT 1";
$sql=mysql_query($query) or die("Can not delete" .mysql_error());
}
?>
<a href="show.php">Movie</a>
let me know what i am doing wrong ...and what exact querey will be
like..Atleast the concept.
Thank''s and advance.
Baldaris
query="SELECT movie_id,movie_name FROM moviesite";
result=mysql_query(
query,
这篇关于********小心新手********编辑和删除mysqldatabase的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!