PHP - Isset Problem

I am an absolute beginner in php & am trying to validate a form using javascript.
Problem is I am checking if the textbox is left empty before the user clicks on the submit button(using javascript).
On the other hand i'm using isset function of php for the same submit button so that it does not run the code unless and until the button is clicked. Due to this, the default value of text box is being entered into database. How do i prevent this?
Is there an alternate function to isset for such an event?

Here is a sample code
Code: [Select]
<?php
if(isset($_POST[sub]))
$sql="insert into testing values('$_POST[txt1]')";
$exec = mysql_query($sql);
?>

<script type="text/javascript">
function check()
{
var a = document.getElementById('add');
if (a.value = "")
{
return false;
}
}
</script>

<form action="add.php" method="post">
<input type="text" name="txt1" id="add"><br>
<input type="submit" name="sub" value="Click to Add" onclick = "check();">
</form>



I'm using ghost text technique on my page instead of labels so the text boxes have different values at different instances and hence I cant use !empty function either.
How do i unset the submit button so that it does not run the script further?

When the form is summited it is supposed to check if the password field contained any text so that way it updates the password. so only if $password exists should it run that query. I tried all different ways of making that happen and it never works. I will summit the form without anything in the password field and it will still update the password to something encrypted in md5 anyways.
Code: [Select]
<?php
include ('header.php');

if(isset($_GET['sa'])) {
  switch ( $_GET['sa']) {

case 'edit':
edit();
break;

}

  }else{


echo "<div class='header'>Edit admins</div><div class='content'>";
$query = mysql_query("SELECT * FROM `admins`");
while($row = mysql_fetch_array($query)){
$username = clean_up($row['username']);
$id = clean_up($row['id']);
$email = clean_up($row['email']);
$website = clean_up($row['website']);
echo "$id $username $email $website | <a href='index.php?action=editadmins&sa=edit&id=$id'> Edit</a><br>"; 
}


echo "</div>";
}

function edit() {
$id = clean_up($_GET['id']);

if(isset($_POST['submit'])){
$username = clean_up($_POST['username']);
$password = md5(clean_up($_POST['password']));
$email = clean_up($_POST['email']);
$website = clean_up($_POST['website']);

if(isset($username)){
if(isset($password)){
mysql_query("UPDATE `admins` SET `password`='$password' WHERE `id`='$id'");
}

mysql_query("UPDATE `admins` SET `username`='$username', `email`='$email', `website`='$website' WHERE `id`='$id'");

echo "<b><font color=green>Information edited. Go <a href='index.php'>home</a>?</font></b><br>";

}else{
echo "please enter a username";
}

}else{

$query = mysql_query("SELECT * FROM `admins` WHERE `id`='$id'");
while($row = mysql_fetch_array($query)){
$username = clean_up($row['username']);
$email = clean_up($row['email']);
$website = clean_up($row['website']);

echo "<div class='header'>Edit $username</div><div class='content'><form action='index.php?action=editadmins&sa=edit&id=$id' method='post'>
<b>Username:</b> <input type='text' name='username' id='username' value='$username'><br>
<b>Password:</b>(leave blank to keep same) <input type='password' name='password' id='password' value=''><br>
<b>Email:</b> <input type='text' name='email' id='email' value='$email'><br>
<b>Website:</b> <input type='text' name='website' id='website' value='$website'><br>
<input type='submit' name='submit' id=submit' value='Edit $username'></form></div>";

}

}

}


include('footer.php'); ?>
   

Hi, I'm very new to PHP so I hope this is not frustrating. I'm having trouble understanding how "isset" works. I'm trying to get it so that when I click a button, it returns two variables(in an array). This works, but I tried to use "Isset" to detect if a array was created, then alter the variable. It's not working... I'm not too sure where I'm going wrong, could anyone give me some advice? Thanks

<?php 


if(isset($_POST['name']))
{
	$userAnswer = $_POST['name'];
	if(isset($_SESSION['test'])){
			$_SESSION['test'][$userAnswer]['var1']++;
			$test = $_SESSION['test'][$userAnswer];
			foreach ($test as $key){
					echo json_encode($key);
						};
					}
	
	else {
	$test = $_SESSION['test'][$userAnswer]=array("var1" => 1, "var2" => 2);
	
	foreach ($test as $key){
				echo json_encode($key);
				};
	}
}


?>

$(document).ready(function(){
  $("button").click(function(){

                var test = "here";
                $.ajax({
				     url: 'info.php', 
				     type: "POST",
				     dataType:'json', 
				      data: ({name: test}),
				     success: function(data){
				     	     
					 $("#click").fadeOut(function() {
					 		 $(this).append(data);
					 		 
					 }).fadeIn();
					
				     }
				 
					});
  });
  
});

I am trying to do isset($_GET but I have a bizarre problem come up.  I am using "id" as one of my fields but when I try to use it in the code it says it is not recognised.  However I use this field quite widely.

The code its coming up with is "Undefined variable: id" but I cant see why it has a problem with id.

My code is:

<?php

if(isset($_GET['id'])){

$sql = mysql_query("SELECT * FROM productfeed WHERE id='$id' LIMIT 1");

}
{


while($row = mysql_fetch_array($sql))

$id = $row['id'];
$image = $row['awImage'];
$link = $row['link'];
$description = $row['description'];
$fulldescription = $row['fulldescription'];
$price = $row['price'];

echo "<div class=\"productdisplayshell\"> <div class=\"productdisplayoutline\"> <div class=\"productborder\"><center>  <a href=\"$link\"  target=\"_blank\" ><img src=\"$image\" /></a> </center> </div></div> <div class=\"productdescriptionoutline\"><div class=\"productdescriptionbox\">  <a href=\"$link\"  target=\"_blank\" >$description</a> </div><div class=\"productfulldescriptionbox\">  $fulldescription </div></div> <div class=\"productpriceoutline\">  <div class=\"productpricebox\"><center>&#38;#163; $price</center></div>  <div class=\"productbuybutton\"><center><a href=\"$link\"  target=\"_blank\" ><img src=/images/buybutton.png /></a></center></div></div></div>";

} 


 

?>

I believe that my problem is with the isset on line 7 and 39, but I do not know of anyway around it. Can someone enlighten me.

<?php
session_start();
if (isset($_GET['logout'])){
    unset($_SESSION['logged_in']);
}
?>
<html>
    <head>
        <title>Add a New Car!</title>
        <?php
        if (isset($_POST['submit'])) {
            //print_r($_POST);
            $password = md5($_POST['password']);
            //echo'<p>'.$password.'</p>';
            $username = ($_POST['username']);
            //echo'<p>'.$username.'</p>';
        }
        $db = new PDO('sqlite:login.sqlite');
        $login = 'SELECT * FROM login
        WHERE userid="'.$username.'"
        AND password="'.$password.'";';
        //echo'<p>'.$login.'</p>';
        $attempt = $db->query($login);
        foreach ($attempt as $row) {
        //print_r($row);
        $_SESSION['logged_in'] = $username;
        }
        ?>
    </head>
    <body>
                <?php 
        if (!isset($_SESSION['logged_in'])){
        ?>
            <form method="post" action="Db_login.php">
            <p>Username:<br /><input type="text" name="username" /> </p>
            <p>Password:<br /><input type="password" name="password" /></p>
            <p><input type="submit" name="submit" value="Log In!" /></p>
            </form>
        <?php
        } else {
        ?>
        <?php
        if(isset($_POST['submit'])) {
            print_r($_POST);
            $make = ($_POST['make']);
            $model = ($_POST['model']);
            $year = ($_POST['year']);
            $fuel = ($_POST['fuel_type']);
            $vin = ($_POST['vin_number']);
            $reg = ($_POST['reg_number']);
        }
        $db = new PDO('sqlite:cars.sqlite');
        $sqlCars = 'INSERT INTO cars ( )
        VALUES("'.$make.'","'.$model.'","'.$year.'","'.$fuel.'","'.$vin.'","'.$reg.'");';
        echo'<p>'.$sqlCars.'</p.>';
        ?>
        <form method="post" action="Db_new_Cars.php" enctype="multipart/form-data">
            <p>Make:<br /><input type="text" name="make" /> </p>
            <p>Model:<br /><input type="text" name="model" /></p>
            <p>Year:<br /><input type="text" name="year" /></p>
            <p>Fuel Type:<br /><input type="text" name="fuel_type" /></p>
            <p>Vin Number:<br /><input type="text" name="vin_number" /></p>
            <p>Reg Number:<br /><input type="text" name="reg_number" /></p>
            <p>Choose a image to upload:<br />
            <input type="file" name="myfile"></input></p>
            <p><input type="submit" name="submit" value="Submit!" /></p>
        </form>
        <h1> Protected Content!</h1>
        <p>You are logged in as <em><?php echo $_SESSION['logged_in']; ?> </em></p>
        <p><a href="Db_login.php?logout=true">Log out!</a></p>
        <p><a href="New_Cars.php">Add a new car</a></p>
        <p><a href="Book_Out_Cars.php">Book out a car</a></p>
        <?php
        }
        ?>

    </body>
</html>

Hi there,

I'm inserting data into a mysql database.  My submissions works fine, however when a part of the form is not filled out the php scripit crashes.  How can I submit all data that is set and skip pieces that aren't filled out?

For example I have a plant database which has an option to insert different types of common names for the plant.  It's ok if they aren't all filled out.

My code is as follows: Code: [Select]
<?php  

//insert general plant data into db
$queryplant="INSERT INTO actualplanttable (id, scientific, common1, common2, common3, family, genus, description, planting, growing, care, duration, reference) 
VALUES ('NULL', '$_POST[scientific]', '$_POST[common1]', '$_POST[common2]', '$_POST[common3]', '$_POST[family]', '$_POST[genus]', '$_POST[description]', '$_POST[planting]', '$_POST[growing]', '$_POST[care]','$_POST[duration]','$_POST[reference]')";
mysql_query($queryplant) 
or die ('Error updating actualplanttable');

//insert maintenance data into db
$querymaintenance="INSERT INTO plantmaintenancelinktable (plant_id, maintenance_id)
VALUES ('$inserted_id', '$_POST[maintenance]')";
mysql_query($querymaintenance) 
or die ('Error updating plantdurationtable');

?>


Should I be trying to work an isset function into this code?   Any help would be greatly appreciated.

Thanks!

Bill...

Isn't this code redundant...

if (isset($_SESSION['loggedIn']) && $_SESSION['loggedIn'] == TRUE){


After all, if $SESSION['logged_in'] == TRUE then it is *obviously* set...


Debbie

i Have two page login.php and verify.php

In login.php user is entering Username and Password and in the action of the form i am writing verify.php.

If verification is a success then i will start a session()

Code: [Select]
session_start();

$_SESSION['ls']="loggedin";   // ls stands for login status
$_SESSION['id']=$row['id'];
$_SESSION['user_name']=$row['user_name'];
$_SESSION['email']=$row['email'];
header('location : members.php');
die (" ");
and will redirect them to members.php
....

Everything is working fine...

But in login.php i have written a code on the top...

Code: [Select]
<?php
if(isset($_SESSION['ls']) && isset($_SESSION['id']) && isset($_SESSION['user_name']) && isset($_SESSION['email']) )
{
header('location:members.php');
die(" ");

}
?>
I want if a session is started and if user will access login.php they will automatically go to members.php

But this script is not working...

Iam not getting whats the problem...
also i m not getting any error login.php or anything


CODE WRITTEN ON THE TOP OF members.php IS :

Code: [Select]
<?php
session_start();
if(@$_SESSION['ls']!=="loggedin" ) // Checks if the person has done stage one (Registration.php)
{
   header('Location: login.php'); //If they haven't done it, it sends them back.
   die (" ");
}
?>

Hi all

I need to do a multiple if isset to get three variables from the URL. Here is my code for just one:


if(isset($_GET['category'])) {
$fetchproducts = mysql_query(" SELECT * FROM `products` WHERE category = '".$_GET['category']."'");
while($returnedProduct = mysql_fetch_array($fetchproducts)) {
include('product-cell.php');
}

How do I combine this to check what is the 'type' and 'colour' from the URL and fetch from the SQL accordingly?

Many thanks for you help

Pete

guys this thing called isset() is bugging me.What is the difference in when you say
Code: [Select]
if(isset($_POST['name']))
and
Code: [Select]
if($_POST['name'])
and
Code: [Select]
if(!$_POST['name'])

and why would someone require a code such as Code: [Select]
if($_POST['submit']=='Submit')
And what is that code which tells you the user has entered something into the form
Thanks People

Hello all, i am hoping someone can help me.

i have some code i have been working on and i am trying to add a 404 page if it cant find the page, i know it will be some sort of if statment, but with me been pretty much a noob at php i am stuck.

heres the code that the page calls.

Code: [Select]
function get_content() {

//Get page name from browser if none call it home
$page = (isset($_GET['page'])) ? $_GET['page'] : 'home';

//Get The Page Content
$sql = "SELECT * FROM content WHERE page = '$page'";
$res = mysql_query($sql) or die (mysql_error());
while($row = mysql_fetch_assoc($res)){

//Show The Page Content
echo '<h1>' . $row['title'] . '</h1>';
echo $row['body'];
}
}

thanks all.

This is blowing my mind. I have this function and all I want it to do is check to make sure that the var $race is set and = '0'. The default value from the form is '0'. I also want it to check the value of race and if it is anything but the two listed , submit error. Yes I've tried to replace the || with &&.. Nothing works(Meaning that it will error when its not suppose to or it wont error when its suppose to).. Any ideas?



Code: [Select]
function check_Race ($race,$display_name,$member_id,$description,$ip) {

//echo "This is the race". $race;
//exit;

if (isset($race) && $race ='0' && $race !== 'White' && $race !== 'Black'){

echo "This is an errror.!";
$t_error="19";
$member_id = $member_id;
notify_Admin($t_error,$member_id,$ip);
   // logOut ($t_error);
exit;

}

why dose this not work

<?php

if(isset($_SESSION['SESS_ADMIN']))
   $loc = ../admin/admin.php;
else
   $loc= ../head/head.php";

                     
?>
<form><INPUT TYPE="button" value="Main Menu" onClick="parent.location='<?php echo $loc; ?>'"></form>
</body>

</HTML>

I want to get the COUNT of the fields (ArrayM11 - ArrayM19), which has the word "YES". The code isn't working. Appreciate any help.

$Array1 = array();
for($j=0;$j<count($ArrayM1);++$j) {
$result =  array_count_values($ArrayM1[$j]);
if (isset($result['YES'])) {
  $points1 = $result['YES'];
}
}

The below should be making it so that in order for "customer reviews" to be visible, you should need the "&review" in the url, but it's coming up regardless if it's in the URL  or not.

http://ghosthuntersportal.com/store.php?product=2

Code: [Select]
elseif(isset($_GET['product'])){
$product_id=$_GET['product'];
$sql500="SELECT * FROM $tbl_name3 WHERE product_id='$product_id'";
$result500=mysql_query($sql500);
$num_rows500=mysql_num_rows($result500);
if($num_rows500==0){
$average_rating=0;
}
else{
while($row500=mysql_fetch_array($result500)){
extract($row500);
$total = $total + $review_product_rating;

$review.='
<div class="review_container">
<div>'.$review_product_rating.' '.$review_title.'</div>
<div>By '.$review_name.' from '.$review_location.' on '.$review_date.'</div>
<div>Pros: </div><div>'.$review_pros.'</div>
<div>Cons: </div><div>'.$review_cons.'</div>
<div>Describe Yourself: </div><div>'.$review_describe.'</div>
<div>Best Use: </div><div>'.$review_best_use.'</div>
<div>'.$review_text.'</div>
</div>
';

}
$review_product_rating_total=$total;
$average_rating=$review_product_rating_total/$num_rows500;
}

$sql50="SELECT * FROM $tbl_name WHERE product_id='$product_id'";
$result50=mysql_query($sql50);
while($row50=mysql_fetch_array($result50)){
extract($row50);
$section=ucwords($product_category);
$product_name=ucwords($product_name);
$crumbs='<a href="./index.php">Home</a> <span class="eleven">></span> <a href="./store.php?cat='.$product_category.'">'.$section.'</a>
<span class="eleven">></span> <a href="./store.php?product='.$product_id.'">'.$product_name.'</a>';
$section=" - ".$section;
$product_highlights=str_replace("[","<li>", $product_highlights);
$product_highlights=str_replace("]","</li>", $product_highlights);
$content.='
<div class="product_wrapper">
<div>'.$product_name.'</div>
<div class="product_image">
<div><img src="'.$product_image.'" alt="'.$product_name.'" /></div>
</div>
<div class="product_details">
<div class="product_price">Price: $'.$product_price.'</div>
<div class="product_code">GHP#: '.$product_code.'</div>
<div class="rating_image">';
if($num_rows500==0){ $content.='No Rating'; }
else{ $content.='<img src="'.$average_rating.'.png" alt="'.$average_rating.'" />'; }
$content.=' <span class="twelve">('.$num_rows500.' Reviews)</span></div><div>';

if(isset($product_highlights)){
$content.='<div class="product_highlights_text">Product Highlights</div><div class="product_highlights_item"><ul>'.$product_highlights.'</ul></div>';
}
else{
}
$content.='</div>
</div>
</div>
';
}
$content.='<div class="product_links_headers">Overview | Specifications | Customer Reviews</div>';
if(isset($review)){
$content.='<div style="margin-top: 400px;">'.$review.'</div>';
}
elseif(isset($specifications)){
$content.='<div style="margin-top: 400px;">'.$product_specifications.'</div>';
}
else{
}
}