PHP - Check Field Content Depending On Other Field Entries

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!.

I have this script running:


<?php
$query = mysql_query("SELECT * FROM jobs WHERE event = 'Yes' ORDER BY title");
while ($row = mysql_fetch_array($query)) {
?>


How do I check if a field is empty and NOT display it...?

For instance it has a 'applied' field, if that is empty I dont want it to display, however I still  need the event = 'Yes' part.

I have a code which I made just up
  Code: [Select]
<?php if ($product->title == '01'); print "Earring"; ?>
<?php if ($product->title == '02'); print "Necklace"; ?>
<?php if ($product->title == '03'); print "Necklace"; ?>
<?php if ($product->title == '04'); print "Ring"; ?>I just want to check the product titles first 2 characters and print according to that.
Example: If $product->title is "01DSE32" print Earring. This checking must be strgn  or something like that which I don't remember. I would appreciate some feedback.

Ok so i have registration page on my webs but i didn't work on empty fields so how could i check all fields?
Code: [Select]
//if no name
if(!$name){
$error = "Username missing.";
}
//if no pass
if($pass == false){
$error = "$error,Password missing";
}
//if no pass conf
if($pass_conf == false) {
$error = "$error,Pass conf missing.";
}
//if no email
if($email == false){
$error = "$error,Email missing.";
}
//pass conf
if($pass != $pass_conf){
$error = "$error,Passwords do not match.";
    }
    echo "<script>alert('$error');</script>;";
//header("Location: register.php");
 My script gives same results every time (even if i fill any of fields)...also if i un-comment header command it wont show alert..it just reloads the page

So can anyone help me with this?
Thanks..

Hey all. What is the best way to check if a form field has been entered by the user? Because a field left blank by the user still shows up as set with the isset function.

Example:
if (isset($_POST['name']))
{
echo "The field is set";
}

This is a problem if I'm checking if the user has skipped over the name field on a form because an empty value gets passed to the POST array even if the field is left blank.

Do people use empty or a regular expression instead?

Cheers!

Pehaps this is kidstuff but i'm a kid at heart.

I have only 1 form field on a form
User enters a special code in the form.
Once submitted the form is queried against a mysql database to see if the code exists.
If code does not exist it must be reentered.
If code exists then redirected.

basically its like "get to the next page if you have the code"

thanks

so I have this code:
Code: [Select]
<input type='checkbox' name='title8' value='$title8' /></td><td><strong>$title8</strong> <br /> $date8 <br />$ $price8<input type='hidden' name='price8' value='$price8'> how do I make is so that the hidden field is only going to submit if the checkbox is checked........

Hello everybody, i try to check if the unique field inventar exists or not before i insert new record. if the inventar exits the user should get error message. but i dont know how to do this.   thank you very much for your help. Rafal   here is my code

<?php
include("123.php");
$inventar = $link1->real_escape_string($_POST["inp_inventar"]);
$product = $link1->real_escape_string($_POST["inp_product"]);
$price = $link1->real_escape_string($_POST["inp_price"]);

$link1 = new mysqli("$hoster", "$nameuser", "$password", "$basedata") or die ("Connection Error!"); error_reporting (0);
$check_inventar = mysqli_query($link1, "SELECT inventar FROM products WHERE inventar='$inventar'");
$check_inventar_num = mysqli_num_rows($check_inventar);
if (isset($_POST['inp_submit']) AND $check_inventar_num = 0)
{
$query1 = "INSERT INTO products
(inventar, product, price)
VALUES ('$inventar', '$product', '$price')";
$result1 = $link1->query($query1) or die("Database Error!");
if ($result1 == true)
{
header ( 'Location:insert.php' );
}
}
else { echo "there is already product with same inventar id!"; }
mysqli_close($link1);
?>

Hi there once again, sry for previous wrong section, i guess this time i'm on the right place ;p

Well i need following:

I have few forms (input fields) with requested informations, also i have other .php file which i'm calling to send a form. Now i need to know how can i do a check for those fields if they are empty or not. If they are, i need to STOP submiting the form (calling the other .php).

Codes:

Form:
Code: [Select]
<form name="f1" form method="post" action="posalji.php"/>Field:
Code: [Select]
<input type="text" name="hp1" size="20"/>Submit:
Code: [Select]
<input name="f1" type="image" src="registruj.png" onclick="if(f1.hp1.value.length==0) alert('Error: field can't be empty'); else f1.submit(); if(f1.hp2.value.length==0) alert('Error: field can't be empty'); else f1.submit();"/>There are more than one field, that's why you can see more errors in submit. Well all i need is "die" or "stop" calling the "posalji.php" from action above.

Sry 4 poor english.

Hello there,

My current song request form process looks like:

<?php
                if(isset($_POST['submit'])) {
                $to = 'address@website.com' ;  
$name = trim($_POST['name']);
                $message = trim($_POST['message']);
                $artist = trim($_POST['artist']);
                $song = trim($_POST['song']);
$subject="Name:$name - Message:$message - Artist:$artist - Song:$song";
                $headers  = 'MIME-Version: 1.0' . "\r\n";
                $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
                $message = "<table>
                <tr><td>Name</td><td>".$_POST['name']."</td></tr>
                <tr><td>Message</td><td>".$_POST['message']."</td></tr>
                <tr><td>Artist</td><td>".$_POST['artist']."</td></tr>
                <tr><td>Song</td><td>".$_POST['song']."</td></tr>
                </tr></table>" ;
                mail($to, $subject, $message, $headers);
                header('Location: song-requests-success.php');
               }
?>

I'm currently using Javascript for blank validation, however, people seem to be getting through it somehow.

I'm looking to implement PHP checkers that will output back to the request form with something like: Name field blank.

Would this method work?

$name = trim($_POST['name']);
$artist = trim($_POST['artist']);
$song = trim($_POST['song']);
if(empty($name)){
$name1 .= "<br>Name is empty.";
}
if(empty($artist)){
$artist1 .= "<br>Artist is empty.";
}
if(empty($song)){
$song1 .= "<br>Song is empty.";
}

On form:

<?php if(!empty($name)){ echo "".($name1).""; } ?>
<?php if(!empty($artist)){ echo "".($artist1).""; } ?>
<?php if(!empty($song)){ echo "".($song1).""; } ?>

Would recalling the trim's be nessessary as they have already been specified for the email title. Would this need to be implemented into 'isset'.

Many thanks.

I am building a system where people are able to choose a food menu, they can modify each dish if needed and then say how many of each item they need for the order.

So when they pick the breakfast menu, it selects all starters, mains and desserts.  Should something need to be edited (sausages changed to vegitarian sausages) the user should be able to overtype what has been populated from the select statement)

When the form is submitted, the order needs to be linked to the current job which is in a field ssm_job.job_id but the changes to the menu items need to be stored somewhere for the current order only.  This obviously needs to be accessile later so further changes can be made if needed.  I am not sure of the best way to go about this as i am trying not to save every item in another database (just trying to be tidy)

Any advise on this would be greatly appreciated.

I have had help on this project in relation to an sql and the background can be found below, the help has been amazing but as this is a very different question i thought i would start a new thread.

 

Kind Regards

What I'm trying to figure out how to do is when its getting the content for the field it needs to get the ID of the field that way it can get the content of the field. I'm not sure what I'm doing wrong.

Code: [Select]
<?php require ('php/bios.php'); ?>

<script type="text/javascript" src="forms/edit/js/bios.js"></script>

<!-- Title -->
<div id="title" class="b2">
    <h2>Character Management</h2>
</div>
<!-- Title -->

<!-- Inner Content -->
<div id="innerContent">
   
    <form action="#" id="bioForm" >
        <?php 
            while ($row = mysqli_fetch_array($groupsResult, MYSQL_ASSOC)) {
                echo "<fieldset>
                <legend>" . $row['groupName'] . "</legend>";
                $fieldsResult = mysqli_query ( $dbc, sprintf($fieldsQuery,$row['ID']) );
                while ($row2 = mysqli_fetch_array($fieldsResult, MYSQL_ASSOC)) {
                   echo "<div class=field required>";
                   if ($row2['inputType'] == "text") {
                   echo "<label for=" . $row2['ID'] . ">" . $row2['fullName'] . "</label>";
                       echo "<input type=text name=" . $row2['ID'] . " id=" . $row2['ID'] . " class=text biofield title=" . $row2['fullName'] . " />";     
                   } elseif ($row2['inputType'] == "textarea") {
                       echo "<label for=" . $row2['ID'] . ">" . $row2['fullName'] . "</label>";
                       echo "<textarea name=" . $row2['ID'] . " id=" . $row2['ID'] . " class=textarea biofield title=" . $row2['fullName'] . " />";
                   } else {
                       echo "<label for=" . $row2['ID'] . ">" . $row2['fullName'] . "</label>";

echo "<select name=" . $row2['ID'] . " id=" . $row2['ID'] . " class=dropdown biofield title=" . $row2['fullName'] . " >";
echo "<option value= >None</option>";
if ($styleID == 1 || $styleID == 2 || $styleID == 6) {
                         $charactersQuery = "
                                SELECT 
                                    characters.ID, 
                                    characters.characterName 
                                FROM 
                                    characters 
                                WHERE 
                                    characters.styleID = 3
                                ORDER BY 
                                    characters.characterName";
}
else {
                         $charactersQuery = "
                                SELECT 
                                    characters.ID, 
                                    characters.characterName 
                                FROM 
                                    characters 
                                WHERE 
                                    characters.styleID IN (1,2,6)
                                ORDER BY 
                                    characters.characterName";
}

$charactersResult = mysqli_query ( $dbc, $charactersQuery ); // Run The Query

while ( $row3 = mysqli_fetch_array ($charactersResult, MYSQLI_ASSOC)) { 
   echo "<option value=" . $row3['ID'] . ">" . $row3['characterName'] . "</option>\r";
}

   echo "</select>";
}


                   echo "</div>";
                }
                echo "</fieldset>";
            } 
        ?>
        <fieldset>
            <input type="hidden" name="defaultCharID" id="defaultCharID" value="<?php echo $defaultCharID; ?>" />
            <input type="submit" class="submit" id="editBio" title="Edit Bio" value="Edit Bio" />
        </fieldset>
    </form>

</div>
<!-- /Inner Content -->

Code: [Select]
<?php

session_start(); // Access the existing session

// Include the database page
require ('../../inc/dbconfig.php');

$defaultCharID = $_SESSION['defaultCharID'];

$styleIDQuery = "
    SELECT
        characters.styleID
    FROM
        characters
    WHERE
        characters.ID = '" . $defaultCharID . "'";
$styleIDResult = mysqli_query ( $dbc, $styleIDQuery ); // Run The Query
$row = mysqli_fetch_array( $styleIDResult, MYSQL_ASSOC );
$styleID = $row[ 'styleID' ];

$groupsQuery = "
    SELECT 
        groups.* 
    FROM 
        groups 
    WHERE 
        groups.styleID = '" . $styleID . "'
    ORDER BY 
        groups.ID";
$groupsResult = mysqli_query ( $dbc, $groupsQuery ); // Run The Query

$fieldsQuery = "
    SELECT 
        fields.* 
    FROM 
        fields 
    WHERE 
        fields.styleID = '". $styleID . "' AND fields.groupID = '%d' AND fields.statusID = 1";
        
$fieldContent = "
    SELECT
        fieldsContent.*
    FROM 
        fieldsContent
    WHERE
        fieldsContent.characterID = '". $defaultCharID . "' AND fieldsContent.fieldID = = '". $fieldID ."'";        

?>

Hello,

I'm currently using this code to check for blank fields:

if(isset($_POST['submit']))
{
$emailconfirm = $_POST['emailconfirm'];
$user_message = $_POST['message'];
$name = $_POST['name'];
$visitor_email = $_POST['email'];
if(empty($name)|| empty($visitor_email)|| empty($user_message))
{
$errors .= "<div id='contact_form_errorloc' class='err1'>Some of the above fields have not been filled in.</div><br>";
}

This however, does not check for valid emails, I've found this code:

function is_valid_email($email) {
  $result = TRUE;
  if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})$", $email)) {
    $result = FALSE;
  }
  return $result;
}

My question was if the above is possible aswell as incorporating the blank field checks.

Many thanks!

I have a register script, and I am wanting to make it so that if the username field contains, lets say "mod", "ass", and more, then it'll return an error and wont let them register.

Now this one is a bit of a shit head. I am using a really comprehensive class i found on on the web for upload / re-size / crop but i want to be able to override it's error handling and i am not good enough to start modifying the code in the class with out fucking it up.

Firstly i will show you how i have invoked the class.
Code: [Select]
if( isset($_FILES['image'] ) ) {

//Class includes
include("../scrips/php/cms/database.insert.class.php");
include ("../scrips/php/cms/img.upload.resize.crop.class.php.php");


//----------|Start: upload, resize & save
$your_image = new _image;

//----------| Upload orginal image
$your_image->uploadTo = 'uploads/';
$upload = $your_image->upload($_FILES['image']);


//----------| Resize and upload small thumbnail
$your_image->newPath = 'thums/';
$your_image->newWidth = 50;
$your_image->newHeight = 50;
$resized = $your_image->resize();



//----------| Resize and upload medium thumbnail
$your_image->newPath = 'thums2/';
$your_image->newWidth = 100;
$your_image->newHeight = 100;
$resized = $your_image->resize();
//----------| Getting the image name to insert into the database futher on in the code
$name = $resized;
$img_str = explode("/",$name);
$final_img_name = $img_str['1'];

echo "Article has been added!";

//----------------|end

//----------------| Start database insert (class manipulation)
$table = "blog_posts";
$title = "'".$_POST['ArticleTitle']."',";
$img = "'".$final_img_name."',";
$post = "'".$_POST['ArticleBody']."',";
$aurthor_id = "'1',";
$category_id = "'".$_POST['Category']."',";
$date_posted = "NOW()";


$values = array("$title","$img","$post","$aurthor_id","$category_id","$date_posted");
$fields = array('title,','img,','post,','aurthor_id,','category_id,','date_posted');
$obj= new DatabaseInsert;
$obj->DatabaseConnectionRequire();
$obj->ArticleInsert($values,$fields,$table);
//----------------|end
}


As you can see it's fairly basic. What i want to do is before it runs this script and starts including/invoking the class etc, i want to be able to check to see if there is a value been posted from a FILE FORM OBJECT and if there is to proceed with this script, alternatively i want it to execute another code which will handle it in regards to the concept of my page. A simple javascript alert with be ok providing it reloaded the page to it's default state. If any one can help me here i would appreciate it a lot. Thanks