Forum PHP.pl > [MySQL][PHP] Błąd w kodzie

Pomoc - Szukaj - Użytkownicy - Kalendarz

Pełna wersja: [MySQL][PHP] Błąd w kodzie

ayo1001

13.03.2015, 01:31:26

[PHP] pobierz, plaintext 
<html>
	<head>
		<title>TEST</title>
 
	<link rel="stylesheet" href="style.css" />
	</head>
 
<body>
<div id="header">
<a href="index.php">
<h1>Welcome to the Admin Panel</h1></a>
 
</div> 
 
<div id="sidebar">
 
<h2><a href="#">A</a></h2>
<h2><a href="#">B</a></h2>
<h2><a href="#">C</a></h2>
<h2><a href="#">D</a></h2>
 
 
</div>
<?php 
 
include("includes/connect.php");
 
if(isset($_GET['edit'])){
 
	$edit_id = $_GET['edit'];
 
	$edit_query = "select * from posts where post_id='$edit_id'";
 
	$run_edit = mysql_query($edit_query); 
 
	while ($edit_row=mysql_fetch_array($run_edit)){
 
 
		$post_id = $edit_row['post_id'];
		$post_title = $edit_row['post_title'];
		$post_author = $edit_row['post_author'];
		$post_keywords = $edit_row['post_keywords'];
		$post_image = $edit_row['post_image'];
		$post_content = $edit_row['post_content'];
	}
}
?>
 
<form method="post" action="edit_posts.php?edit_form=<?php echo $edit_id; ?>" enctype="multipart/form-data">
 
	<table width="600" bgcolor="orange" align="center" border="10">
 
		<tr>
			<td align="center" bgcolor="yellow" colspan="6"><h1>Edit The Post Here</h1></td>
		</tr>
 
		<tr>
			<td align="right">Post Title:</td>
			<td><input type="text" name="title" size="30" value="<?php echo $post_title; ?>"></td>
		</tr>
 
		<tr>
			<td align="right">Post Author:</td>
			<td><input type="text" name="author" size="30"value="<?php echo $post_author; ?>"></td>
		</tr>
 
		<tr>
			<td align="right">Post Keywords:</td>
			<td><input type="text" name="keywords" size="30"value="<?php echo $post_keywords; ?>"></td>
		</tr>
 
		<tr>
			<td align="right">Post Image:</td>
			<td>
			<input type="file" name="image"> 
			<img src="../images/<?php echo $post_image;?>" width="100" height="100"></td>
		</tr>
 
		<tr>
			<td align="right">Post Content:</td>
			<td><textarea name="content" cols="30" rows="15"><?php echo $post_content; ?></textarea></td>
		</tr>
 
		<tr>
			<td align="center" colspan="6"><input type="submit" name="update" value="Update Now"></td>
		</tr>		
	</table>
 
</form>
</body>
</html>
<?php
 
	if(isset($_POST['update'])){
 
	$update_id = $_GET['edit_form'];
	$post_title1 = $_POST['title'];
	  $post_date1 = date('m-d-y');
	  $post_author1 = $_POST['author'];
	  $post_keywords1 = $_POST['keywords'];
	  $post_content1 = $_POST['content'];
	  $post_image1= $_FILES['image']['name'];
	  $image_tmp= $_FILES['image']['tmp_name'];
 
	if($post_title1=='' or $post_author1=='' or $post_keywords1=='' or $post_content1=='' or $post_image1==''){
 
	echo "<script>alert('Any of the fields is empty')</script>";
	exit();
	}
 
	else {
 
	 move_uploaded_file($image_tmp,"../images/$post_image1");
 
		$update_query = "update posts set post_title='$post_title1',post_date='$post_date1',post_author='$post_author1',post_image='$post_image1',post_keywords='$post_keywords1',post_content='$post_content1' where post_id='$update_id'";
 
		if(mysql_query($update_query)){
 
		echo "<script>alert('Post has been updated')</script>";
 
		echo "<script>window.open('view_posts.php','_self')</script>";
 
		}
 
	}
	}
 
 
 
?>
[PHP] pobierz, plaintext

Po naciśnięciu przycisku "Post has been updated" wyrzuca mi błąd:
"Any of the fields is empty"

a w polach:
Post Title <-  Notice: Undefined variable: post_title in C:\xamp\htdocs\test\test\edit_posts.php on line 59 
Post Author <-  Notice: Undefined variable: post_author in C:\xamp\htdocs\test\test\edit_posts.php on line 64 
Post Keywords <-  Notice: Undefined variable: post_keywords in C:\xamp\htdocs\test\test\edit_posts.php on line 69 
Post Image <- nie ładuje obrazka
Post Content: <- 
Notice: Undefined variable: post_content in C:\xamp\htdocs\test\test\edit_posts.php on line 81 

Gdzie może być błąd ?

johny_s

13.03.2015, 01:57:42

przerzuć obsługę posta nad formularz i poczytaj o sql injection

ayo1001

13.03.2015, 13:12:40

Okej, ale gdzie jest błąd ?

markuz

13.03.2015, 13:15:54

Błąd polega na tym, że próbujesz wyświetlić zmienną która nie istnieje np. $post_title

To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.