Ad:

PHP Discussion Thread
Unsolved
Views: 565

Mar 17th, 2010

control never goes in "else" part.. PHP/MYSQL

Expand Post »

i m newbie in web development plz help me to sort out the problem..
the problem is: in edit.php when control enters in if condition it never goes to else when i press the edit button.

i want to get id from view.php and display category name in edit.php textbox so i can change the category name by pressing edit button.

view.php

PHP Syntax (Toggle Plain Text)
<?
		require("Datab.class.php");
		$db = new Datab("localhost", "root", "intaha", "subc");
		$db->connect();
 
		$result = $db->query("select * from category");
 
		?>
		<table border="1" cellpadding="0">
        <? 
 
		if(mysql_num_rows($result)){
 
			while($rows = mysql_fetch_row($result)){ ?>
                <tr>
                <td><? echo $rows[0]; ?></td> 
                <td><? echo $rows[1]; ?></td>
                <td><a href="edit.php?id=<?=$rows[0]?>">edit</a></td>                
                <td><a href="delete.php?id=<?=$rows[0]?>">delete</a></td>
 
 
				</tr>
            <?	
			}
		}
		?> </table>
<?
		require("Datab.class.php");
		$db = new Datab("localhost", "root", "intaha", "subc");
		$db->connect();
	
		$result = $db->query("select * from category");
		
		?>
		<table border="1" cellpadding="0">
        <? 

		if(mysql_num_rows($result)){
			
			while($rows = mysql_fetch_row($result)){ ?>
                <tr>
                <td><? echo $rows[0]; ?></td> 
                <td><? echo $rows[1]; ?></td>
                <td><a href="edit.php?id=<?=$rows[0]?>">edit</a></td>                
                <td><a href="delete.php?id=<?=$rows[0]?>">delete</a></td>
          
                           
				</tr>
            <?	
			}
		}
		?> </table>

edit.php

PHP Syntax (Toggle Plain Text)
 
<html>
<head>
<title></title>
</head>
<body>
 
 
<?php
		require("Datab.class.php");
		$db = new Datab("localhost", "root", "intaha", "subc");
		$db->connect();
		$id = $_GET['id'];
		echo "hello this is upper.... $id";			
 
		$result = $db->query("select name from category where category_id = $id");
 
		$name = "";
		if(mysql_num_rows($result) > 0){
			while($rows = mysql_fetch_row($result)){
				$name = $rows[0];
			}
		}
 
	if(!isset($_POST['submit'])){
		echo "<br> in !isset condition..... <br> ";
		?>	
			<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
			<input type="text" name="cat_name"  value= "<? echo $name; ?>" />
			<input type="submit" name="submit" value="edit" />
			</form>
		<?
	}else{
		echo "<br> in else condition..... <br> ";
		$uname= $_POST['cat_name'];
		echo "name = " .$uname;
		echo "in id = " . $id . "  ";
		$result = $db->query("update category SET name = '$uname' where category_id = $id");
		echo "Category name changed ";
	}
		?>
 
 
</body>
</html>
<html>
<head>
<title></title>
</head>
<body>


<?php
		require("Datab.class.php");
		$db = new Datab("localhost", "root", "intaha", "subc");
		$db->connect();
		$id = $_GET['id'];
		echo "hello this is upper.... $id";			
		
		$result = $db->query("select name from category where category_id = $id");
		
		$name = "";
		if(mysql_num_rows($result) > 0){
			while($rows = mysql_fetch_row($result)){
				$name = $rows[0];
			}
		}
		
	if(!isset($_POST['submit'])){
		echo "<br> in !isset condition..... <br> ";
		?>	
			<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
			<input type="text" name="cat_name"  value= "<? echo $name; ?>" />
			<input type="submit" name="submit" value="edit" />
			</form>
		<?
	}else{
		echo "<br> in else condition..... <br> ";
		$uname= $_POST['cat_name'];
		echo "name = " .$uname;
		echo "in id = " . $id . "  ";
		$result = $db->query("update category SET name = '$uname' where category_id = $id");
		echo "Category name changed ";
	}
		?>
        

</body>
</html>

yun

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

42 posts
since May 2009

Permalink

Mar 17th, 2010

Re: control never goes in "else" part.. PHP/MYSQL

<form action="<?=$_SERVER['PHP_SELF']?>" method="post">

I believe you have an extraneous '=' in there... Shouldn't that be an "echo"?

Last edited by Fbody; Mar 17th, 2010 at 11:24 am.

Fbody

Featured Poster

Reputation Points: 833

Solved Threads: 392

Posting Maven

Offline

2,846 posts
since Oct 2009

Permalink

Mar 17th, 2010

control never goes in "else" part.. PHP/MYSQL

below is the output after clicking the Edit button.

hello this is upper.... Error in query : select name from category where category_id = . You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

yun

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

42 posts
since May 2009

Permalink

Mar 17th, 2010

Re: control never goes in "else" part.. PHP/MYSQL

Look at lines 18 and 19 of view.php. Then look at my previous post.

Fbody

Featured Poster

Reputation Points: 833

Solved Threads: 392

Posting Maven

Offline

2,846 posts
since Oct 2009

Permalink

Mar 17th, 2010

Re: control never goes in "else" part.. PHP/MYSQL

Click to Expand / Collapse Quote originally posted by Fbody ...

Look at lines 18 and 19 of view.php. Then look at my previous post.

PHP Syntax (Toggle Plain Text)

 
<td><a href="edit.php?id=<? echo $rows[0]?>">edit</a></td>        
<td><a href="delete.php?id=<? echo $rows[0]?>">delete</a></td>

are same no difference at all.. echo and ?= did the same thing.. and the problem is in edit.php, view.php doing the same thing which i want.

PHP Syntax (Toggle Plain Text)

 
<td><a href="edit.php?id=<?=$rows[0]?>">edit</a></td>        
<td><a href="delete.php?id=<?=$rows[0]?>">delete</a></td>

yun

Reputation Points: 10

Solved Threads: 2

Light Poster

Offline

42 posts
since May 2009

Permalink

Mar 17th, 2010

Re: control never goes in "else" part.. PHP/MYSQL

Open view.php in a browser and view the page source. Look for the HTML markup produced by lines 18 and 19. If there are not values in the "id" fields, the issue at least starts in view.php, not in edit.php. If there is a value, the issue could be in either file. I'm concerned about the part of your script that generates the link address(es). It appears that the ID is not getting into edit.php. Once we confirm that it is, we can go from there.

Last edited by Fbody; Mar 17th, 2010 at 1:32 pm.

Fbody

Featured Poster

Reputation Points: 833

Solved Threads: 392

Posting Maven

Offline

2,846 posts
since Oct 2009

Permalink

Mar 17th, 2010

Re: control never goes in "else" part.. PHP/MYSQL

Took out the db stuff as I don't have your tables and it worked fine:

PHP Syntax (Toggle Plain Text)
<html>
<head>
<title></title>
</head>
<body>
 
 
<?php
		$id = $_GET['id'];
		echo "hello this is upper.... $id";			
 
 
		$name = "";
 
 
	if(!isset($_POST['submit'])){
		echo "<br> in !isset condition..... <br> ";
		?>	
			<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
			<input type="text" name="cat_name"  value= "<? echo $name; ?>" />
			<input type="submit" name="submit" value="edit" />
			</form>
		<?
	}else{
		echo "<br> in else condition..... <br> ";
		$uname= $_POST['cat_name'];
		echo "name = " .$uname;
		echo "in id = " . $id . "  ";
		echo "Category name changed ";
	}
		?>
 
 
</body>
</html>
<html>
<head>
<title></title>
</head>
<body>
 
 
<?php
		$id = $_GET['id'];
		echo "hello this is upper.... $id";			
 
		
		$name = "";
		
 
	if(!isset($_POST['submit'])){
		echo "<br> in !isset condition..... <br> ";
		?>	
			<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
			<input type="text" name="cat_name"  value= "<? echo $name; ?>" />
			<input type="submit" name="submit" value="edit" />
			</form>
		<?
	}else{
		echo "<br> in else condition..... <br> ";
		$uname= $_POST['cat_name'];
		echo "name = " .$uname;
		echo "in id = " . $id . "  ";
		echo "Category name changed ";
	}
		?>
 
 
</body>
</html>

ardav

Sponsor

Featured Poster

Reputation Points: 1041

Solved Threads: 935

Sarcastic Poster

Offline

6,620 posts
since Oct 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Php cms problem

Next Thread in PHP Forum Timeline: Php session

DaniWeb Message

Cancel Changes

User Name
Password