PHP - Php To Hide An Item If Field Value Is Null

Hi there,

I think this is a big question but I'd appretiate any help you can provide!!
I have a list of items and subitems in a table that looks like this:

id    parent_id    title 1    0    House Chores 2    1    Take Out Trash 3    1    Clean Room 4    0    Grocery List 5    4    Eggs 6    4    Produce 7    6    Lettuce 8    6    Tomato 9    4    Milk
I want to display it like this:

(+) House Chores:
       > Take Out Trash
       > Clean Room

(+) Grocery List:
       > Eggs
       (+) Produce
            > Letutce
           > Tomato
       > Milk

 
So basically each entry in the table has an unique id and also a parent id if it's nested inside another item.
I "sort of" got it figured out in one way, but it doesnt really allow for nested subgroups. I'd like to know how would y'all PHP freaks to this

Also taking suggestions for the javascript code to expand/collapse the tree !!

Thank you!

I am trying to update the database with isset to set the value of the variable to either null or the value entered by the user. Currently, if no value has been entered null is being set as a string causing the date field to populate with zeros. How do I code it so that it populates or sets the value as null and not as string null?   Here's my code: (yes I know sql injections it's still in development  ) <?php

Well I am looking to change this url

Code: [Select]
http://website.com/product.php?Item=2369
to

Code: [Select]
http://website.com/product.php?Item=Item-Name

Heres a snip of the code that handles that.

<?php include_once('mysql_connect.php');$id = (int)$_GET['Item'];?>()

any help would be appreciated.

This is my first real jump into PHP, I created a small script a few years ago but have not touched it since (or any other programming for that matter), so I'm not sure how to start this.

I need a script that I can run once a day through cron and take the date from one table/filed and insert it into a different table/field, converting the human readable date to a Unix date.

Table Name: Ads
Field: endtime_value (human readable date)

to

Table Name: Node
Field: auto_expire (Converted to Unix time)

Both use a field named "nid" as the key field, so the fields should match each nid field from one table to the next.  Following a tutorial I have been able to insert into a field certain data, but I don't know how to do it so the nid's match and how to convert the human readable date to Unix time.  Thanks in advance!.

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
        <form name="form1" method="post" action="upload.php" style="padding:5px;">
        <p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
          <form enctype="multipart/form-data" action="upload.php" method="POST">
          <input type="hidden" name="MAX_FILE_SIZE" value="4000000">
          Upload your C.V.: <input name="userfile" type="file" id="userfile">
          <input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName  = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
    $fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

(Another quite newbie...)
I have already an online booking form. The Form works fine now and I would like to add on one more issue, but the code ignores what I want to check. I have 4 fields: arrival, departure, no. of persons and comments to check.

Scenario 1:

All field mentioned above are emtpty: Workes fine and message appears: "You have not provided any booking details".

Scenario 2:

If arrival (date_start) and departure (date_end) is entered, there should be at least an entry either in the field "comment", or in the field "pax". If not, there should be a message: "You have not provided sufficient booking details".

INSTEAD: The booking request is sent, which should not be the case.

The code is currently:

      # all fields empty : arrival, departure, pax and comments - error

if(empty($data_start) && empty($data_end) && empty($pax)&& empty($comment)){
    exit("You have not specified any booking details to submit to us.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}
      #If arrival  and departure date is entered, there should be at least an entry

either in the field "comment", or in the field "pax".
      
if(!isset($data_start) && !isset($data_end) && empty($pax) && empty($comment)){
    exit("You have not provided sufficient booking details.
    <br>Please use your browser to go back to the form.
    <br>If you experience problems with this Form, please e-mail us");
    exit;
}

The form can be tested at http://www.phuket-beachvillas.com/contact-own/contact-it.php

Can someone please check and tell me what's wrong with the code ? Thanks to anyone for any hint.

Hi,
I'm developing an app using flash AS2 as the front end via PHP and a mySQL database at the backend on my server.

what i'm looking to do is update/insert into a table called 'cards' and at the same time update/insert into another table called 'jingle'. There is a field called 'cardID' in jingle that should be the same as the ID number created in 'cards' thus creating a link between entries in the different tables that can be called up as i choose.

hope i've been clear i just wouldn't know where to start any help would be appreciated.

MySQL client version: 5.0.91
PHPmyAdmin Version information: 3.2.4


thanks in advance

How should it look if I want to make a query where a field value should be lower than another field?

Code: [Select]
....WHERE total_points<max_points");

I am working on a script for a simple form with only 2 options that are dropdowns.  I need to validate these two options that there is a selection made.

I have gotten the first one to validate, but I cannot get the second one to validate.  Can anyone steer me in the right direciton why only one is working?  I get no errors in the script, so I assume I am just missing something.

Code: [Select]
<?php
// options for drop-down menu
$choices = array('-- Choose Your Item','Anniversary Jacket', 'Anniversary T-Shirt');
$sizes = array('-- Choose Your Size','L', 'XL');

if($_SERVER['REQUEST_METHOD'] == 'GET'){
    // display form when GET
    showForm(array());
}
else{
    // process form if POST
    $errors = validateForm();
    if(count($errors)) showForm($errors); // if errors show again
    else print 'Form submitted succesfully!'; // no errors
}


// function generating form
function showForm($errors){

    global $choices,$sizes;

    // set defaults
    $defaults = array();
    foreach($choices as $key => $choice){
        if(isset($_POST['item']) && ($_POST['item'] == $key)) $defaults['item'][$key] = 'selected';
        else $defaults['item'][$choice] = '';
    } 
    foreach($sizes as $key => $size){
        if(isset($_POST['size']) && ($_POST['size'] == $key)) $defaults['size'][$key] = 'selected';
        else $defaults['size'][$size] = '';
    } 


    // print form
    print "<form action='{$_SERVER['SCRIPT_NAME']}' method='post'>";

    print "<div>";
    print "<select name='item'>";
    foreach($choices as $key => $choice){
        print "<option value='{$key}' {$defaults['item'][$key]}>{$choice}</option>"; 
    }
    print "</select>";
    showError('item', $errors);
    print "</div>";



print "<div>";
    print "<select name='size'>";
    foreach($sizes as $key => $size){
        print "<option value='{$key}' {$defaults['size'][$key]}>{$size}</option>"; 
    }
    print "</select>";
    showError('size', $errors);
    print "</div>";
    
    
    print "<input type='submit'/>";




    print "</form>";

}

// display error
function showError($type, $errors){
    if(isset($errors[$type])) print "<b>{$errors[$type]}</b>";
}

// validate data
function validateForm(){

    global $choices,$sizes;
    
    // start validation and store errors
    $error = array();
    

    // validate drop-down
    if(!(isset($_POST['item']) && (array_key_exists($_POST['item'], $choices)) && $_POST['item'] != 0)) $errors['item'] = 'Select Item';


     return $errors;
    

    // validate drop-down
    if(!(isset($_POST['size']) && (array_key_exists($_POST['size'], $choices)) && $_POST['size'] != 0)) $errors['size'] = 'Select Size';


     return $errors;

}







?>

Hi,
I'm hoping someone can lead me in the right direction here. I'm creating a simple shopping cart that I will later pass on to Paypal for payment but my problem is, it won't add the items to my shopping cart when I click add to cart.

My products are on different pages and I'm not sure if that is going to matter.

When I click "add to cart" nothing gets added and it says my cart is empty. I have two tables with the following columns:

1. products:
        productId
        productName
        productDesc
        productPrice
        link (for dynamically creating the page links on the main product page)

2. productscents
       scentId
       scentName
       scentDesc


Here is the add code that is in my first products page (Elite Hand Cream):

Code: [Select]
<?php 


if(isset($_GET['action']) && $_GET['action'] == "add") {
$id = intval($_GET['id']);
$desc=intval($_GET['desc']);

if (isset($_SESSION['cart'][$id])) {
$_SESSION['cart'][$id]['quantity']++; 
}
else {
$sql3 = "SELECT * FROM products WHERE productId=[$id]";
$sql4= "SELECT * FROM productscents WHERE scentId=[$desc]";
$query3 = mysql_query($sql3);
$query4 = mysql_query($sql4);
if(mysql_num_rows($query3) != 0) {
$row3 = mysql_fetch_array($query3);
$row4 = mysql_fetch_array($query4);
$_SESSION['cart'][$row3['productId']] = array("quantity" => 1, "price" => $row3['productPrice'], "desc" => $row4['scentId']);
} 
}
}


?>

Here is code I have for the $_SESSION:
Code: [Select]
<?php 
if(isset($_SESSION['cart'])) {
$sql5= "SELECT * FROM products,productscents WHERE productId IN (";
foreach($_SESSION['cart'] as $id => $value) {
$sql5 .= $id . ",";
}
$sql5 = substr($sql,0,-1) . ") ORDER BY productId, scentId ASC";
$query = mysql_query($sql5);
if(!empty($query)) {
while($row = mysql_fetch_assoc($query)) {
?>
<?php echo $row['productName'];?><?php $_SESSION['cart'][$row['productId']]['quantity'];?>
<?php 
}  } else {
echo "You need to add an item to your cart";}
}



Here is the code that I have for the "add to cart" and "view cart":

Code: [Select]
<a href=#&action=add&id=<?php echo $prodId;?>&desc=<?php echo $scent_id[$y];?>>Add to Cart</a><br><a href="cart.php">View Cart</a>



This grabs the correct product Id and scent Id which I want and no errors are being displayed on the page.

I'm not sure where to begin with this. LOL. I'm new to PHP and I used a tutorial to help with the code.

Any help would be greatly appreciated.

i have this while loop making my category links at the top of my page, but i still have the bullet after the last item. ive looked at other examples and CANNOT get mine to follow suit...help please?
Code: [Select]
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

$query1 = "SELECT * FROM ob_category";
$data1 = mysqli_query($dbc, $query1);

while($row=mysqli_fetch_array($data1)){

echo '<a href="viewlistings.php">' . $row['name'] . '</a> &#8226; ';
}

Hello All,

I tried searching here and google, but couldn't figure it out on my own... still

Bellow is my code, I need some help figuring out how to tell PHP that "If picture is NULL, don't try to display it."

Basically I have a dynamic news system set up. Some stories have pictures, some do not. I need PHP to not display the code for showing the picture if the picture value = NULL.

Any help would be appreciated!

<?php 
include ("../../includes/connections/newsconnection.php");

$id=$_GET['id'];

//declare the SQL statement that will query the database
$query = "
SELECT *
FROM news 
WHERE id='$id'
";

//execute the SQL query and return records
$result = mssql_query($query);

//display the results 

//id, school, date, link, title, story, picture

while($row = mssql_fetch_array($result))
{
echo "<span class='bodyb'>";
echo $row["title"];
echo "</span>";
echo "<br /><i>";
echo date('l, F j, Y', strtotime($row['date']));
echo "</i>";
echo "<br /><br />";
//heres where I need to stop if picture is null
echo "<img src='../../images/news/";
echo $row["picture"];
echo "' align='left' class='imgspacer-left'>";
echo fixQuotes($row["story"]);

}

//close the connection
mssql_close($dbhandle);
?> 

I have a php form which shows all comments of the webpage  stored in  the database.
When i click on the edit button the corresponding 'comments' datas should appear in the textarea.

how can i do this,
pasting my piece of code


                                         $query="select *from comments order by id desc";
         
         $result=mysql_query($query);
         echo "<table width='700' align='center' border=1><tr bgcolor='green' align='center'><td><font color='black'>&nbsp;SlNo&nbsp;</font></td><td><font color='black'>Comment</font></td><td><font color='black'>&nbsp;&nbsp;Date Posted&nbsp;&nbsp;</font></td><td>Edit/Delete</td></tr></b>";
         while($row = mysql_fetch_row($result))
         {
            $d=$row['0'];
            $id=$row['0'];
            $name=$row['1'];
            $date_uploaded=$row['2'];
            
            echo    "<td>$id</td><td>$name</td>".
                "<td>$date_uploaded</td>".
                "<td><a href='edit_comments.php?id=$id'>Edit </a></td>".
                "</tr>";
         }
         
         echo   "</table>";
         
      }
      if(isset($_GET['id']))
{

   $id    = $_GET['id'];
   mysql_connect('localhost','root','') or die("Cannot connect to the Host");
mysql_select_db('sample') or die("Cannot connect to the Database !!");
   $query = "SELECT comments FROM comments_tble WHERE id = '$id' ";
   
   $result = mysql_query($query);
   $row=mysql_fetch_row($result);
   echo"<input type='text' col id='edit_comments' value='$row[0]' width='250' height='10' >";
   
   
   
   exit;
}

Say i have an array (called $myarray) and it has 10 numbers in it like this...

1
2
4
8
9
10
12
14
15
18

Now in my code, I get a number and lets say for this example it is "5".   

I need to see if that number is in the array --easy enough using in_array()--, but if it is NOT in the array, I need to find the next available number in the array that is greater than my starting number of 5  (which would be "8" in this example).

But what is the best way to find this number (i.e. 8 in this example)?

I imagine I need to somehow loop through but i'm not sure which loop is the best to use and i'm generally confusing the hell out of myself (which is frustrating because this is probably rather simple to do ).

Can anyone help guide me in the right direction?