有誰可以告訴我我按刪除的時候會跑出一堆空值

bright10130126

====================副程式del.php======================

<?php
header('content-type:text/html;charset=utf-8');
include'mysql.php';
if($_GET['del']!='')
{
$sql="DELETE FROM happytime 
      where number='{$_GET['del']}'";
	  mysqli_query($con,$sql);
	  $rowdeleted = mysqli_affected_rows($con);
	  if($rowdeleted>0){
	  echo"success";
	  header('Location:sell.php');
	  exit();
	  }
	  else
	  {
	  die("fail:".mysqli_error($con));
	  }
}

?>

==================主程式sell.php=======================

<?php
include'mysql.php';
error_reporting(E_ALL ^ E_DEPRECATED);
?>
<form method="post" action="" enctype="multipart/form-date" name="form1">
名子:<input type="text" name="name" size="10">
電話:<input type="text" name="phone" size="10">
販賣:<input type="text" name="sell" size="10">
<input type="submit" value="送出"><input type="reset" value="重設">
</form>
<?php
$phone_number = $_POST['phone'];
$user_name=$_POST['name'];
$sell_name=$_POST['sell'];
if(!isset($phone_number)==empty($phone_number))
if(!isset($user_name)==empty($user_name))
if(!isset($sell_name)==empty($sell_name))
{
 {
  {
  $sql = " INSERT happytime(phone,name,sell)
         value('$phone_number','$user_name','$sell_name')";
		 mysqli_query($con,$sql);
  }
 }
}
 else
{
 {
  {
 echo"資料請勿留空白";
  }
 }
}
$sql = "SELECT *
       FROM happytime";
	  $result = mysqli_query($con,$sql);
	  
      $rowcount=mysqli_num_rows($result);	  
	   
	   if($rowcount>0)
       {
	
	  echo"<table border=1> <tr>
	         <td>姓名</td>
	         <td>物品</td>
		     <td>電話</td>
			 <td></td>";
	    while($row = mysqli_fetch_array($result))
		{
		 echo"<td>{$row['name']}</td>
		      <td>{$row['sell']}</td>
			  <td>{$row['phone']}</td>
			  <td><a href='delet.php?del={$row['number']}'>刪除</td>
			  <tr>";
		}echo"</table>";
	   }
	   
	   $sql="INSERT happytime(name,phone,sell)
	        value('$phone_number','$user_name','$sell_name')";
			if(!mysqli_query($con,$sql))
			{
			die("fail:".mysqli_error($con));
			}
	   
	   ?>

按刪除跑出一堆不必要的空值

bright10130126

影片說明問題的經過https://www.facebook.com/video.php?v=1460108777591181&saved

bright10130126

我只要按刪除都會跑出一個空的字串給我

runli

<td><a href='delet.php?del={$row['number']}'>刪除</td>

1.delet.php 在哪? 給的檔名=>del.php.....
2.debug 時 ,你可以在 del.php 最前面加上 print_r($_POST) 看看收到什,
看是少收多收收錯..

bright10130126

<?php
header('content-type:text/html;charset=utf-8');
include'mysql.php';
if($_GET['del']!='')
{
$sql=\"DELETE FROM happytime 
      where number='{$_GET['del']}'\";
	  mysqli_query($con,$sql);
	  $rowdeleted = mysqli_affected_rows($con);
	  if($rowdeleted>0){
	  echo\"success\";
	  header('Location:sell.php');
	  exit();
	  }
	  else
	  {
	  die(\"fail:\".mysqli_error($con));
	  }
}

?>

在著

bright10130126

她會顯示Array ( [del] => 4 )多收的訊息

kiang

header() 之前應該不能有任何 echo 或輸出

bright10130126

我不管怎樣都會多收資料

bright10130126

當我進行刪除資料會多收幾筆資料按重整也一樣,我到的該怎麼解決

cokellen

你的del.php , 每次執行Delete後, 會轉址到sell.php

if($rowdeleted>0){
	  echo\"success\";
	  header('Location:sell.php');
	  exit();
 }

你的sell.php的條件式寫了, 如果這3個變數為empty, 就Insert 1筆新的資料

$phone_number = $_POST['phone'];
$user_name=$_POST['name'];
$sell_name=$_POST['sell'];
if(!isset($phone_number)==empty($phone_number))
if(!isset($user_name)==empty($user_name))
if(!isset($sell_name)==empty($sell_name))
{
 {
  {
  $sql = \" INSERT happytime(phone,name,sell)
         value('$phone_number','$user_name','$sell_name')\";
		 mysqli_query($con,$sql);
  }
 }
}
 else
{
 {
  {
 echo\"資料請勿留空白\";
  }
 }
}

所以每次執行完Delete, 就會Insert 1筆空白資料, 原因應該非常明顯....


1. 你覺得這樣不對, 那表示你的DB Table Column沒有設計好, 應該not allow null
2. 邏輯有問題
3. sell.php的if 迴圈的大括號 { } 的位置很怪異

bright10130126

我sell 跟phone和 name都設not null. 但是結果還是一樣
還有我seel.php也跟改了

<?php
include'mysql.php';
error_reporting(E_ALL ^ E_DEPRECATED);
?>
<form method="post" action="" enctype="multipart/form-date" name="form1">
名子:<input type="text" name="name" size="10">
電話:<input type="text" name="phone" size="10">
販賣:<input type="text" name="sell" size="10">
<input type="submit" value="送出"><input type="reset" value="重設">
</form>
<?php
$phone_number = $_POST['phone'];
$user_name=$_POST['name'];
$sell_name=$_POST['sell'];
if($phone_number!='')
if($user_name!='')
if($sell_name!=''	)
{
  $sql = " INSERT happytime(phone,name,sell)
         value('$phone_number','$user_name','$sell_name')";
}
 else
{
 echo"資料請勿留空白";
}
$sql = "SELECT *
       FROM happytime";
	  $result = mysqli_query($con,$sql);
	  
      $rowcount=mysqli_num_rows($result);	  
	   
	   if($rowcount>0)
       {
	
	  echo"<table border=1> <tr>
	         <td>姓名</td>
	         <td>物品</td>
		     <td>電話</td>
			 <td></td>";
	    while($row = mysqli_fetch_array($result))
		{

		 echo"<td>{$row['name']}</td>
		      <td>{$row['sell']}</td>
			  <td>{$row['phone']}</td>
			  <td><a href='delet.php?del={$row['number']}'>刪除</td>
			  <td>
			  <tr>";
		}echo"</table>";
	   }
	   
	   $sql="INSERT happytime(name,phone,sell)
	        value('$phone_number','$user_name','$sell_name')";
			if(!mysqli_query($con,$sql))
			{
			die("fail:".mysqli_error($con));
			}
	   
	   ?>

bright10130126

<img src = "https://scontent-a-hkg.xx.fbcdn.net/hphotos-xap1/v/t1.0-9/10481386_355889087920175_90805531130778034_n.jpg?oh=4a436bb600fccafa6fc358e98a6c4a89&oe=54BEBB89">;

bright10130126

<img src="https://www.facebook.com/photo.php?fbid=355889721253445&set=a.355889114586839.1073741826.100004972592077&type=1">所以我要怎麼設

bright10130126

<img src="https://fbcdn-sphotos-g-a.akamaihd.net/hphotos-ak-xfa1/v/t1.0-9/10269403_355889721253445_5455335466458682827_n.jpg?oh=ab51237662aa2b7df7bd5c419d423c71&oe=54824D16&__gda__=1417902624_11120c367a02e707b7cddca28730b037">;

bright10130126

<?php
include'mysql.php';
error_reporting(E_ALL ^ E_DEPRECATED);
?>
<form method="post" action="" enctype="multipart/form-date" name="form1">
名子:<input type="text" name="name" size="10">
電話:<input type="text" name="phone" size="10">
販賣:<input type="text" name="sell" size="10">
<input type="submit" value="送出"><input type="reset" value="重設">
</form>
<?php
$phone_number = $_POST['phone'];
$user_name=$_POST['name'];
$sell_name=$_POST['sell'];
if($phone_number!='')
if($user_name!='')
if($sell_name!=''	)
{
  $sql = " INSERT happytime(phone,name,sell)
         value('$phone_number','$user_name','$sell_name')";
		 mysqli_query($con,$sql);
}
 else
{
 echo"資料請勿留空白";
}
$sql = "SELECT *
       FROM happytime";
	  $result = mysqli_query($con,$sql);
	  
      $rowcount=mysqli_num_rows($result);	  
	   
	   if($rowcount>0)
       {
	
	  echo"<table border=1> <tr>
	         <td>姓名</td>
	         <td>物品</td>
		     <td>電話</td>
			 <td></td>";
	    while($row = mysqli_fetch_array($result))
		{

		 echo"<td>{$row['name']}</td>
		      <td>{$row['sell']}</td>
			  <td>{$row['phone']}</td>
			  <td><a href='delet.php?del={$row['number']}'>刪除</td>
			  <td>
			  <tr>";
		}echo"</table>";
	   }
	   
	 
	   
	   ?>

抱歉,好像好ok了. 剩下亂碼的部分. 感謝,我還有問題. 希望可以繼續像你們執導

cokellen

你最大的問題, 基本邏輯概念不夠, 你很多發問都是邏輯上的錯誤, 無關是否使用PHP

建議你多看一些教學的書(圖書館借書不用錢), 那些為了新手而寫的書,
至少都有教導基本的邏輯概念, 看個5本 10本, 可以綜合比較出適合新手的正確寫程式的邏輯,
以你目前學程式的方法, 看起來是有待修正

bright10130126

恩,好我知道了