PHP - Echo Repopulating Blank Data In Database On Refresh. Please Help

Probably a silly question, but say you have a value in a mysql database that (naturally) can be either be blank or have characters in it.

If in my PHP I am doing a check to see if that returned field from the database HAS or DOES NOT HAVE a value entered in it, what is the proper way to do it?

For example, you could do either of the following below (and I'm sure there are probably 10 other ways to do it as well).  Is one of these quicker/more efficient than the other? 

I  know it probably does not matter in the grand scheme of things because it's such a quick check either way, but if one way is more "proper" than the other, please let me know...
Code: [Select]
if ($mysqlvalue!=="")
OR
if (strlen($mysqlvalue>0))
OR
 

Hey all. I'm a noob so bare with me. Just started studying php and have an assignment due. At this phase of the project I have to create a form where a user can register data and I should retrieve that data and store it in my database. Now I have already created the form (student_reg.php) and a separate file with php code (demo.php)

My database is name "registration" and I am trying to put this info in the "student" table. It has about 15 fields but for now I am only trying trying to insert the 1 field of data to test if it works. Dont know if that may cause problems?

So far my demo.php connects to the database successfully. The problem I am having is the information I submit does not showing in the database field. However, I have an id field in my case a student number field which is set to auto increment so it automatically updates (1,2,3,4) with each new sumbitted info. When I submit the info the id field gets updated each time with a new row ( so i assume some information is somehow going through ) however the info I entered will remain blank in its field. :banghead:

Heres my form (student_reg.php)

Code: [Select]
<div id="apdiv3">

<FORM action = "demo.php" method ="post ">

<p>Course name:</p>
<INPUT TYPE = "text"  name="input"/>
<INPUT TYPE = "Submit" VALUE = "Submit"/>
</div>
</FORM>

and heres my php code to retrieve the form info

Code: [Select]
<?PHP


include 'includes/config.php';

//connect to database
$link=mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);



//error check
if (!$link)
{
die('could not connect: ' . mysql_error());
}

$db_selected=mysql_select_db(DB_NAME, $link);



// error check
if (!$db_selected)
{
die('can\t use ' . DB_NAME . ': ' . mysql_error());
}
// Connected to database



// retrieve form data
$value=(isset($_POST['input']));

$sql = "INSERT INTO student (sname) VALUES ('$value')";


if (!mysql_query($sql))
{
die ('Error: ' . mysql_error());
}
mysql_close();


?>

I also recieved a notice "undefined index" or something like that from this part of the code "$value=(isset($_POST['input']));" before I inserted "isset" to the code. I'm not sure if what I did fixed the problem or only hid it, or whether that notice was related to the problem I'm having of not retrieving the info.

Haha sorry guys know this is probably childs play for you but I just started out and really need to fix this so I can catch up with this project. Feel free to add tips and comments on other areas. Thanks :mrgreen:

I have 2 files; Newfault.php and thankyou.php

1) Data is entered into a form in Newfault.php
2) The data from this form is retieved in thankyou.php and is then inserted into a table called "Calls"

Problem:

My entered record is being added to my database OK, but it is also adding a blank record for some reason and I can't work out why. Can anyone help? This is for my uni assignment.

Thanks,

Ladykudos

Hi there,

I am using this code to send the users email address to the database. That works fine, but i keep getting blank info added to the database. Does anyone know how i can stop this?

<?php
$con = mysql_connect("*","*","*");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ogs_mailinglist1", $con);

$sql="INSERT INTO mailinglist (email)
VALUES
('$_POST[rec_email]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

mysql_close($con);
?>



Thanks,

Here is my code:


<?php
//input will be start date

$startdate=0;
function getMondays($day,$month,$year,$i,$end){
    
$x = 7;
$add=0;
    
for($i; $i<$end; $i++){
$add++;
//This will get the first set of Mondays 
//store it inside an array
//time stamp 11 pm GMT on date
$array[$i] = date('U', mktime(0, 0, 0, $month, $day+$counter, $year));
//$firstDay = date('d/m/y', mktime(0, 0, 0, $month, 4+$counter, $year)); 
$counter = $x * $add;
}

return $array;
}


This gets the four weeks following the date set and store it in an array:


$Weeks = getMondays(04,04,2011,0,5);


Each slot is the equivalent of a week e.g. week 1, week 2, week 3, week 4,week 5


//perform equivilence test
if($week1==$currentdate || $currentdate<=$week2){
    
    //for all week 1 stick the following sentence
    echo "data for week 1";
    
}

if($currentdate>$week2 && $currentdate<=$week3){
    
    //for all week 2 stick the following sentence
    echo "data for week 2";
    
}

if($currentdate>$week3 && $currentdate<=$week4){
    
    //for all week 3 stick the following sentence
    echo "data for week 3";
    
}

if($currentdate>$week4 && $currentdate<=$week5){
    
    //for all week 4 stick the following sentence
    echo "data for week 3";
    
}

if($currentdate==$week5){
    
    //where d/m/y = the date on week 5.
   //will now become week 1 data
    getMondays(d,m,y,0,4);
    
}




Now depending on which week it is, a set data is displayed which is hardcoded.

Now what I want to do is to reset the array on week 4 (for the new month), without the array being repopulated with  the old date:


$Weeks = getMondays(04,04,2011,0,4);


everytime the script is run.


How do I do this?

I'm trying to repopulate a dropdown list when the user hits the submit button to add another item to the dropdown.

I'm trying to use the isset method, but am having some issues implementing it properly. Can anyone steer me in the right direction?


 <html>
 <head><title>Dynamic List</title></head>
 <body>

 <form action="test.php"><select name="list">;
 <?  
  
if (isset($_POST['submit'])){    
$file = file("test.txt");
sort($file);
foreach($file AS $country){
    echo "<option>".$country."</option>\n";

 }
}
 ?>

</select>
</form>

please enter your new country:<br>
<form action=test.php method="post">
<input type="text" name="name">: enter your country<br>
<input type="submit" name="submit">
</form>
<?
$file = "test.txt";
$tf = @fopen("$file", "a+");
$name = "\n" . $_POST["name"];
$write = fwrite($tf, $name);
@fclose($file);

?> 
 </body>
 </html> 

Hi guys! New to the community and hope to learn a lot here!

Here is some background info and what I want to do, and what I know.

I have been building websites for years, and I am familiar with Actionscript 3.0. And I have successful ran a few wordpress websites. What I am trying to do right now however is modify this form script I found, to only email the data when the field isn't left blank. It's stumping me because the actual "message" that ends up being the body of the email is a variable. And form what I can tell I can't figure out how to put if statements into it. If anyone can take a look at this script and give me any pointers you would be awesome.

Code: [Select]
                    <?php
//trying to store the date in a separate variable only when it's not blank
if ($_POST['starttime'] == '') {
//nothing;
}
else 
{
$showStartTime == "Start time: " . $_POST['starttime'] . "";
}
if ($_POST['finishtime'] == '')
{
//nothing;
}
else 
{
$showFinishTime == "Finish time: " . $_POST['finishtime'] . "";
}
// Read POST request params into global vars
$to      = $_POST['to'];
$from    = $_POST['from'];
$name    = $_POST['name'];
$company    = $_POST['company'];
$newcustomer    = $_POST['newcustomer'];
$address1    = $_POST['address1'];
$address2    = $_POST['address2'];
$subject = ("Event Rental for " . $name . "");
$description = $_POST['description'];
$phone   = $_POST['phone'];

$message = ("
Name: " . $name . " 
Company or Organization: " . $company . " 
Phone Number: " . $phone . " 
Email Address: " . $from . " 
Street Address: " . $address1 . " " . $address2 . " 
New Customer: " . $newcustomer . "
Customer From: " . $_POST['howyouheard'] . "
Interested in: SkyLoft " . $_POST['whichspace'] . "
Date: " . $_POST['date'] . "
Day of Week: " . $_POST['dayofweek'] . "
" . $showStartTime . " 
" . $showFinishTime . " 
Number of Guests: " . $_POST['Guests'] . "
Format: " . $_POST['format'] . "
Occasion: " . $_POST['Occasion'] . "
Optional Needs: " . $_POST['dj'] . " " . $_POST['tables'] . " " . $_POST['chairs'] . " " . $_POST['eventbanner'] . " " . $_POST['pasoundsystem'] . "
Message:
" . $description . " 

");

// Obtain file upload vars
$fileatt      = $_FILES['fileatt']['tmp_name'];
$fileatt_type = $_FILES['fileatt']['type'];
$fileatt_name = $_FILES['fileatt']['name'];

$headers = "From: $from";

if (is_uploaded_file($fileatt)) {
  // Read the file to be attached ('rb' = read binary)
  $file = fopen($fileatt,'rb');
  $data = fread($file,filesize($fileatt));
  fclose($file);

  // Generate a boundary string
  $semi_rand = md5(time());
  $mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
  
  // Add the headers for a file attachment
  $headers .= "\nMIME-Version: 1.0\n" .
              "Content-Type: multipart/mixed;\n" .
              " boundary=\"{$mime_boundary}\"";

  // Add a multipart boundary above the plain message
  $message = "This is a multi-part message in MIME format.\n\n" .
             "--{$mime_boundary}\n" .
             "Content-Type: text/plain; charset=\"iso-8859-1\"\n" .
             "Content-Transfer-Encoding: 7bit\n\n" .
             $message . "\n\n";

  // Base64 encode the file data
  $data = chunk_split(base64_encode($data));

  // Add file attachment to the message
  $message .= "--{$mime_boundary}\n" .
              "Content-Type: {$fileatt_type};\n" .
              " name=\"{$fileatt_name}\"\n" .
              //"Content-Disposition: attachment;\n" .
              //" filename=\"{$fileatt_name}\"\n" .
              "Content-Transfer-Encoding: base64\n\n" .
              $data . "\n\n" .
              "--{$mime_boundary}--\n";
}

// Send the message
$ok = @mail($to, $subject, $message, $headers);
if ($ok) {
  echo "<p><b>Thank you for your interest in SkyLofts!</b> <br>You should recieve a verification in your inbox that we recieved your request. We will contact you as soon as possible and hopefully be able to answer any questions you may have! You can also contact us via phone 410-791-6699, or toll-free 1-800-344-0410.</p>";
} else {
  echo "<p>There was an error when processing your request. Please try again.</p>";
}
?>

I've managed to isolate a problem I'm having with my php script. It would seem the script randomly restarts itself with blank post data while it's running.

I've managed to mimick the problem using a very basic php script which just pauses and writes to a log:

<?php

$q = $_POST['q'];

if ($q==""){
  writelog ("MISFIRE!!!");
  die;
}

writelog("\n*** Error check started ***");

for ($i = 1; $i <= 50; $i++) {
   writelog ($i);
     sleep(rand(2,20));
}

 function writelog($towrite)
{
  $tdate=date('d/m/Y H:i:s');
  $file = 'log/testlog.txt';
  $current = $towrite." --- ".$tdate."\n";
  file_put_contents($file, $current, FILE_APPEND);
}

writelog("*** Error check ended ***");
?>

To rule out any problems with my AJAX htmlhttp requests, I simply send the script some irrelevant post data using Chrome's Advanced Restful client.

This is the ouput of the log from an example test run:

*** Error check started *** --- 05/06/2014 18:27:30

1 --- 05/06/2014 18:27:30
2 --- 05/06/2014 18:27:44
3 --- 05/06/2014 18:27:49
4 --- 05/06/2014 18:27:59
5 --- 05/06/2014 18:28:04
6 --- 05/06/2014 18:28:22
7 --- 05/06/2014 18:28:33
8 --- 05/06/2014 18:28:39
9 --- 05/06/2014 18:28:52
10 --- 05/06/2014 18:29:08
11 --- 05/06/2014 18:29:22
12 --- 05/06/2014 18:29:30
13 --- 05/06/2014 18:29:43
MISFIRE!!! --- 05/06/2014 18:29:46
14 --- 05/06/2014 18:29:56
15 --- 05/06/2014 18:30:07
16 --- 05/06/2014 18:30:09
17 --- 05/06/2014 18:30:15
18 --- 05/06/2014 18:30:32
19 --- 05/06/2014 18:30:52
20 --- 05/06/2014 18:30:54

Note the logged "Misfire" after the 13th entry.  This shows the script tried to run again with blank post data, the same problem I'm having in my more complex script.

Why could this be happening? It's not anyone else calling the script, nobody knows about the site and I've ruled it out by logging the IP in my real script.
Edited by holdorfold, 05 June 2014 - 02:29 PM.

Hi everyone,

I have a form which is repopulated with cookies of user entries following an unsuccessful submit.

It works on all fields except the textarea which is just blank.

Can anybody suggest why this isn't working?

Here is the form page code:

Code: [Select]
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">
<?php include("functions.php"); 
getcompanyname(company);
?>
<html>
<head>
<title>Nominate <?php echo getuserdetails("company", company); ?> for The WOW! Awards</title>
<link href="mobile.css" rel="stylesheet" type="text/css" />
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.4/jquery.min.js"></script>
<script type="text/javascript" src="javascript/form.js"></script>

</head>
<div id = "header">
<img src="images/mobile_banner.png");
</div>

<div id="content">
<?php mobileerror(); ?>
<h2>NOMINATE US!</h2>

<div id = "rulesheading">
<b>There are just four criteria to be met:</b><br />
</div>
<div id = "rules">
<ol>
<li>It has to be for service that made you go WOW!</li>
<li>It should be a recent experience</li>
<li>It must have happened to you personally</li>
<li>Employees of LoveFilm may not nominate</li>
</ol>
</div>

<form id= "contactform" action="mobile_proc_nominate.php" method="post">

<fieldset><legend>Nomination Form</legend>
  <input type="hidden" name="type" value="nomination"/>
  <input type="hidden" name="jobtitle" value=" "/>
  <input type="hidden" name="department" value=" "/>
  <input type="hidden" name="mobile" value="1" />


<h4>Your Nomination Details</h4>

  <p>

<?php if (!isset($_COOKIE['nominee'])){ ?> <!-- These stop the Java labels overwriting user text if error -->
    <label for="nominee">Tell us who WOW!ed you today (required)</label>
<?php } ?>

    <input type="text" name="nominee" id="nominee" value="<?php echo readcookie('nominee'); ?>" title="Tell us who WOW!ed you today"/>
  </p>

  <p>
<?php if (!isset($_COOKIE['comment'])){ ?>
    <label for="comment">How, where and when did they WOW! you? (required)</label>
<?php } ?>
    <textarea name="comment" id="comment" value="<?php echo $_COOKIE["comment"]; ?>" title="How, where and when did they WOW! you? (required)" /></textarea>
  </p>

  <h4>Your Details</h4>

  <p>
<?php if (!isset($_COOKIE['name'])){ ?>
    <label for="name">Your Name (required)</label>
<?php } ?>
    <input type="text" name="name" id="name" value="<?php echo readcookie('name'); ?>" title="Please tell us your name"/>
  </p>

  <p>
<?php if (!isset($_COOKIE['email'])){ ?>
    <label for="email">Your Email (required)</label>
<?php } ?>
    <input  type="text" name="email" id="email" value="<?php echo readcookie('email'); ?>" title="Please enter your email address"/>
  </p>

  <p>
<?php if (!isset($_COOKIE['phone'])){ ?>
    <label for="phone">Your Phone Number</label>
<?php } ?>
    <input type="text" name="phone" id="phone" value="<?php echo readcookie('phone'); ?>" title="And your phone number"/>
  </p>


  <input class="button" type="submit" value="Send" />

</fieldset>
</form>

</div>

<div id="footer">
</div>
</body>

</html>
And here is the form processing script:

Code: [Select]
<?php 
include("functions.php");
checkaccess(0);
require_once("includes/browser.php");
$browser = new Browser();
$thebrowser = ereg_replace("[^A-Za-z]", "", $browser->getBrowser());
$ver = $browser->getVersion();
setcookie("nominee",$_POST['nominee'],time()+3600);
setcookie("comment",$_POST['comment'],time()+3600);
setcookie("name",$_POST['name'],time()+3600);
setcookie("email",$_POST['email'],time()+3600);
setcookie("phone",$_POST['phone'],time()+3600);


$email = $_POST['email'];

if(!eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)) {

$email_error="TRUE";

}


if ($thebrowser.$ver != "InternetExplorer6.0") 
{
/* if(!captcha() )
{
header("location: nominate.php?err=Spam Protection Code");
}
else*/ if($_POST['name']=="" || $_POST['name']=="Your Name (required)" || $_POST['nominee']=="Tell us who WOW!ed you today (required)" || $_POST['nominee']=="" || $_POST['comment']=="How, where and when did they WOW! you? (required)" || $_POST['comment']=="" || $_POST['email']==""  || $_POST['email']=="Your Email (required)" || $email_error=="TRUE" )
{
header("location: mobile.php?err=Please complete the required fields");
}
else
{
connect();
$name=format_text_for_database($_POST['name']);
$email=format_text_for_database($_POST['email']);
$phone=format_text_for_database($_POST['phone']);
$nominee=format_text_for_database($_POST['nominee']);
   $jobtitle=format_text_for_database($_POST['jobtitle']);
$department=format_text_for_database($_POST['department']);
$comment=format_text_for_database($_POST['comment']);
$type=format_text_for_database($_POST['type']);
$cid=company;
$mobile=format_text_for_database($_POST['mobile']);
  
  $sql=mysql_query("insert into comments (date, name, email, phone, department, nominee, jobtitle, comment, type, cid, mobile) values (now(), '$name', '$email', '$phone', '$department', '$nominee', '$jobtitle', '$comment', '$type', $cid, $mobile)");
$lastid=mysql_insert_id();
disconnect();

   senduseremail($lastid);
sendclientemail($lastid);
   header("location: mobile_thanks.php");
}
}

if ($thebrowser.$ver == "InternetExplorer6.0") 
{
/* if(!captcha_spam() )
{

header("location: nominate.php?err=Please re-enter the Spam Protection Code");
}

else*/ if($_POST['name']=="" || $_POST['email']=="" || $_POST['comment']=="")
{

header("location: nominate.php?err=Please complete the required fields");
}
else
{

connect();
$name=format_text_for_database($_POST['name']);
$email=format_text_for_database($_POST['email']);
$phone=format_text_for_database($_POST['phone']);
$nominee=format_text_for_database($_POST['nominee']);
   $jobtitle=format_text_for_database($_POST['jobtitle']);
$department=format_text_for_database($_POST['department']);
$comment=format_text_for_database($_POST['comment']);
$type=format_text_for_database($_POST['type']);
$cid=company;
  
  $sql=mysql_query("insert into comments (date, name, email, phone, department, nominee, jobtitle, comment, type, cid) values (now(), '$name', '$email', '$phone', '$department', '$nominee', '$jobtitle', '$comment', '$type', $cid)");
$lastid=mysql_insert_id();
disconnect();

   senduseremail($lastid);
sendclientemail($lastid);
   header("location: mobile_thanks.php");
}
}

?>
Any pointers would be greatly appreciated.

KN

After I've successfully inputted something in my script and then click refresh in Chrome with "Right Click -> Reload", the same thing that I've inputted before gets re-inserted AGAIN into the database, thus resulting in multiple versions of the same thing in the MySQL database.


How can I prevent that?

p.s. Chrome is warning with a pop up of repeated action, and when I then click continue the repeated insertion of the data occurs, and I'd like to prevent the repeated insertion.

<a href="entries.php?eid=<?php echo $row2->eid; ?>" class="n">Entry ID <?php echo $row2->eid; ?> by <?php echo $row2->username; ?></a>
My issue is that the second output of entry id works fine. The first output, being the more important, does not, even though they are identical. This will probably be something ridiculously stupid.

Hi

Is it necessary to hash stored access and refresh tokens that are stored in a database.

Both these tokens have limited lifespan (access token - 20 minutes but refresh token is 14 days).

The reason I ask is I have hashed the tokens using the password_hash function but a user can have multiple active sessions if they want (so there is a sessions table with user id (not username), access token, token expiry date/time, refresh token and refresh token expiry date/time.

So in order to refresh the access token I have to do a look up to see which session it relates to, what I have found is that I must retrieve all rows where the refresh token hasn't expired and then run password_verify against the tokens stored with the tokens provided to check each session to see if they match.

What I have found is that it takes a while to run  the password_verify function (by design I think) for each row (could be many if the users has been silly and logged in lots of time) which would cause an unacceptable delay when calling an API with an access token that needs refreshing (my tests resulted in times upwards of 30 seconds for a user who has around 10 active sessions).

If both tokens were not hashed the same action to refresh a token for a user who has 10 active sessions takes less than a second which is much more acceptable.

Edited December 15, 2018 by mds1256

Hi,
I have a search results page that return the results based on "Make" & "Model" of vehicle.

The question is, can an image be echoed onto that results page based on which make and model has been searched for?

The image is stored in a field called "Image_Van"  so would need to display that depending on the row in that database that has been selected from Make & Model...

Hope this makes sense!


<?php

//info bars colour
$color_info="#D6D685"; // Almost Silver //FFFFCC
$color1="#E9E9E9";// Light Blue
$color2="#EAD5FF";// Light Blue


//include function library code

include_once("func_lib.php");

// use the user_connection include file's connectDB function

include_once("usr_conn.php");

if (!connectDB())

{


echo "<p>Unable To Connect To Database</p>";

return;
}

//test that make and model are passed in, if they are assign them
if (($_GET ['make'] == "MAKE") or ($_GET ['model'] == "MODEL"))

{
$errMessage =  "<br><br><b><font class=small>Your search hasn't returned any results, please re-enter your search again.</font></b><br><br><a href=van_accessories.php>Search again</a><br><br>";


}


else


{
// get search values for make and model, removing " and ' chars
$strMake = mysql_escape_string($_GET ['make']);















$strModel = mysql_escape_string($_GET ['model']);















}















// set the Prod_Type that is to be shown regardless of car make and model















$strDefaultProd = "XD";































//write query string that will pased in paging links















$strQuery = "make=".$strMake."&model=".$strModel."&";















//echo $strQuery;















//grab the page number that we're on















$page = mysql_escape_string($_GET ['page']);































//$strMake = "FIAT";















//$strModel = "Uno";































//create sql query















$sqlSelect = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Prod_REF, Product_Desc, Price_ExVat, image_name, Image_Van FROM products";

                                                                                        //change this back to 'FILL THIS IS IN' to switch accessories off!

$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Default_Code = 'SA')";


//$criteria = " WHERE Car_Make = '".$strMake."' AND Car_Model = '".$strModel."'";







// assign the basic sqlquery



$sqlquery = $sqlSelect . $criteria;



//echo $sqlquery; #debug











//get the result set



$result = mysql_query($sqlquery);



$count = mysql_num_rows($result);



$full_count = $count;















//set max number of records per page



$records_per_page = 999;







//Next figure out how many pages you'll have.



$total_pages = ceil( $count / $records_per_page );







/*















This just sets up a page variable which will be past in a "next" and "prev"















link.  The first link to this page may not actually have $page so this just















sets it up.















*/































if ( $page == "" ) { $page = 1; }































//echo "<br>page number".$page; #debug















































# this will set up the "First | Prev | " part of our navigation.















if ( $page == 1 ) {















    # if we are on the first page then "First" and "Prev"















    # should not be links.















    $naviagation = "<font color=\"#666666\">First</font> | <font color=\"#666666\">Prev</font> | ";















} else {















    # we are not on page one so "First" and "Prev" can















    # be links















    $prev_page = $page - 1;















    $navigation = "<a href=\"van_steps_results.php?".$strQuery."page=1\">First</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$prev_page."\">Prev</a> | ";















}































# this part will set up the rest of our navigation "Next | Last"















if ( $page == $total_pages ) {















    # we are on the last page so "Next" and "Last"















    # should not be links















   // $navigation .= "<font color=\"#666666\">Next</font> | <font color=\"#666666\">Last</font>";















} else {















    # we are not on the last page so "Next" and "Last"















    # can be links















    $next_page = $page + 1;















    $navigation .= "<a href=\"van_steps_results.php?".$strQuery."page=".$next_page."\">Next</a> | <a href=\"van_steps_results.php?".$strQuery."page=".$total_pages."\">Last</a>";















}































/*















The final thing to do is your actual query, but first we have to figure out















what the offset will be.















*/















$offset = ( $page - 1 ) * $records_per_page;















//echo "<br>offset".$offset; #debug


//create sql query


$sqlSelect = "SELECT Car_Make, Car_Model, Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat, Link, image_name, Image_Van FROM products";


$criteria = " WHERE (Car_Make = '".$strMake."' AND Car_Model = '".$strModel."' AND Default_Code = 'RS') OR (Car_Make = 'all' AND Car_Model = 'all' AND Default_Code = 'SA')";


$limit = " ORDER BY Priority ASC, Prod_Code ASC, Prod_ID ASC LIMIT $offset, $records_per_page";

// assign the basic sqlquery
$sqlquery = $sqlSelect . $criteria . $limit ;

//echo $sqlquery;

//get the result set

$result = mysql_query($sqlquery);
// if no matches found from query
if (!$result || (mysql_num_rows($result) == 0)){
//echo ("<b><font class=small>No matches were found.</font></b>");
}
// display the results
else{
// use rowcount to display total results found

$count = mysql_num_rows($result);

//echo $count;

//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>Results Page:</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<script src="js/jquery-1.3.2.min.js" type="text/javascript"></script>
<!--script src="js/jquery.lint.js" type="text/javascript" charset="utf-8"></script-->
<link rel="stylesheet" href="css/prettyPhoto.css" type="text/css" media="screen" title="prettyPhoto main stylesheet" charset="utf-8" />
<script src="js/jquery.prettyPhoto.js" type="text/javascript" charset="utf-8"></script>


<!--  start header graphic html -->

<style type="text/css">
<!--
.table {
border: 0px none;
border-collapse: separate;
}

BODY
{
}
A
{
    COLOR: #003366;
    TEXT-DECORATION: none;
}
A:hover
{
TEXT-DECORATION: underline;
color: #900;
}
.small
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.std
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR: #000000;
}
.header
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
.bigheader
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: BOLD;
    COLOR:#FFFFFF;
}
.error
{
    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
COLOR:#FF0000
}
.headertable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#FFFFFF;
    BACKGROUND-COLOR:#000066;
}
.stdtable
{
FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
FONT-WEIGHT: regular;
    COLOR:#000066;
}
.style16 {font-size: 11px}
.style7 { color: #CC0000;
font-style: italic;
}
.small1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
}
.header1 {    FONT-SIZE: 8pt;
    FONT-FAMILY: Verdana;
    FONT-WEIGHT: BOLD;
COLOR:#000000;
}
a:link {
color: #900;
}
-->
</style>




<div align="center">
  <table border="0" cellpadding="0" cellspacing="0">
    <tr>
      <td background=""><table width="100%" border="0" align="center" cellpadding="2" cellspacing="0">
        <tr>
          <td bgcolor="#003366">&nbsp;</td>
        </tr>
      </table>

        <!--END header-->
        
        <table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
              <tr>
                <td><div align="center">
                  <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td class="arial11"><table width="100%" border="0" cellpadding="10" cellspacing="0">
                        <tr>
                          <td width="33%"><p><img src="2003/results.gif" alt="" width="238" height="43" /></p>
                            <p>&nbsp;</p>
                            <p>&nbsp;</p></td>
                          </tr>
                        </table></td>
                    </tr>
                  </table>
                </div></td>
              </tr>
            </table>
              <table width="950" border="0" align="center" cellpadding="2" cellspacing="2" bordercolor="#FFFFFF">
                <tr align="center" valign="top" class="std">
                  <td colspan="7"><hr width="500" size="1" />
                    <?php















if (isset($errMessage)){















echo $errMessage;















}















// if no matches found from query















if (!$result || (mysql_num_rows($result) == 0))















echo ("<b><font class=small>No matches were found.</font></b><br><br>");































// display the results















else{















// use rowcount to display total results found















echo("<br><p><em><font class=vehicle>Search Results for " . $strMake . "&nbsp;" . $strModel .".</em> Total Matches Found = " . $full_count . "</p>"); //*debug















echo $navigation;



}




/*



With your navigation built you can just echo that out any where you want it



to appear.



*/



//echo $navigation;



?></td>
                </tr>
                <?php



$title =  "<tr align=\"center\" class=\"headertable\" height=\"32\">";


$title .= "<td width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"1\" /></td>";

    $title .= "<td width=\"60\">Make</td>";



    $title .= "<td width=\"60\">Ref No.</td>";



    $title .= "<td width=\"550\">Title/Description</td>";



    $title .= "<td width=\"73\">Price Ex VAT</td>";



    $title .= "<td width=\"73\">Price Inc VAT</td>";



    $title .= "<td width=\"60\"><img src=\"2003/basket.gif\" width=\"21\" height=\"14\"></td>";



    $title .= "</tr>";































//set the counters for the records results display screen















$cnt = 0;















$headercount1 = 0;















$headercount2 = 0;















$headercount3 = 0;















$headercount4 = 0;















$headercount5 = 0;















$headercount6 = 0;















$headercount7 = 0;



























while ($row = mysql_fetch_assoc($result))















{































//cut the prod_type variable















//get the length of the variable















$strLength = strlen ($row["Prod_Type"]);















//assign first 2 characters of variable















$strPrefix = substr($row["Prod_Type"], 0, 2);















//debug















//echo "\n prefix :" . $strPrefix;















//assign remaining characters of variable















$strSuffix = substr($row["Prod_Type"], 2, $strLength);















//debug















//echo "\n suffix :" . $strSuffix;































































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=center><td colspan=7 class=small>";










//set bg cell color diff for BH make
switch ($strPrefix)
{
case "BH":
$color=$color2;
break;

default:
$color=$color1;
break;
}//end switch


switch ($strPrefix)
{

   case "BH":

        if ($headercount1 == 0)

{

echo "<img border=0 src=2003/searchheaders/step.jpg></td></tr>";
echo $title;
}
$headercount1 ++;

//$headercount1


       break;

  // REMOVE ALL THIS COMMENTING IF NEEDED TO SHOW THE ROOF BARS!  case "RB":

     //  if ($headercount2 == 0)
// {
// echo "<img border=0 src=2003/searchheaders/NOTUSED.jpg alt=Roof-Bars></td></tr>";
// echo $title;
// }

// $headercount2 ++;

//$headercount1

       break;

case "BX":
        if ($headercount3 == 0)
{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Roof-Boxes></td></tr>";
echo $title;
}
$headercount3 ++;

//$headercount1

       break;
case "BR":


        if ($headercount4 == 0)

{

echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Bike-Racks></td></tr>";

echo $title;

}


$headercount4 ++;

//$headercount1

       break;
case "SR":
        if ($headercount5 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Ski-Rack></td></tr>";
echo $title;
}

$headercount5 ++;


//$headercount1


       break;
case "CR":

        if ($headercount6 == 0)

{
echo "<img border=0 src=2003/searchheaders/bulkheads.jpg alt=Canoe-Rack></td></tr>";



echo $title;
}


$headercount6 ++;

//$headercount1

       break;

case "XD":

 if ($headercount7 == 0)

{


echo "<img border=0 src=2003/searchheaders/towbar.jpg alt=General-Accessories></td></tr>";
echo $title;

}



$headercount7 ++;


}















//end header image selection and close the table row.















//echo "</td></tr>";































// if (($cnt++)%2)
// {
// $color="#E9E9E9"; // Almost Silver
// }
//     else
// {
// $color="#E9E9E9";// Light Blue
// }































//print a product row if the prodtype isn't set to INFO



$pop_link = "";







if ($strSuffix != "INFO"){







//test to see if an image exists for the product



if ($row["Link"] <> NULL){



$pop_link = "&nbsp;&nbsp;&nbsp;<a href=\"products/".$row["Link"]."?iframe=true&width=650&height=500\" rel=\"prettyPhoto\" >More information >>>></a>";



}







echo "<tr class=stdtable align=center height=25>";


//DISPLAY THUMB IMAGE IF ONE WAS LISTED IN THE image_name FIELD
$p_Image_Van = htmlspecialchars($row["Image_Van"]);
//echo "p_Image_Van:$p_image_name";
if ($p_Image_Van != "")
echo "<td bgcolor=$color width=\"95\"><img src=\"images/product_images/$p_Image_Van\" border=\"0\" /></td>";
else
echo "<td bgcolor=$color width=\"95\"><img src=\"images/transparent.gif\" width=\"95\" height=\"50\" border=\"0\" /></td>";


echo "<td bgcolor=$color width=\"60\">". htmlspecialchars($row["Prod_Make"]) .




"</td><td bgcolor=$color width=\"60\">" . htmlspecialchars($row["Prod_REF"]) .















"</td><td bgcolor=$color align=left class=\"infolink\" width=\"550\">" . htmlspecialchars($row["Product_Desc"]) .







$pop_link .







"</td><td bgcolor=$color width=\"73\">&pound;" . number_format(htmlspecialchars($row['Price_ExVat']), 2) .















"</td><td bgcolor=$color width=\"73\">&pound;" . number_format((calcVAT (htmlspecialchars($row['Price_ExVat']))), 2) .















"</td><td bgcolor=$color width=\"60\"><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $row["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=7 bgcolor=$color_info><em><strong>" . htmlspecialchars($row["Product_Desc"]) . "</strong></em></td></tr>";















}















}















































//******************************************************************************************************







/*







//get all porducts from the database that are marked with prod_type XD regardless of car make and model















$sqlSelectDefault = "SELECT Prod_ID, Prod_Type, Prod_Model, Prod_Make, Priority, Prod_Code, Prod_REF, Product_Desc, Price_ExVat FROM products";















$criteriaDefault = " WHERE Prod_Type LIKE '".$strDefaultProd."%'";















$limitDefault = "ORDER BY Priority ASC, Prod_Code ASC";































// assign the basic sqlquery















$sqlqueryDefault = $sqlSelectDefault . $criteriaDefault . $limitDefault ;















//echo $sqlquery;































//get the result set















$resultDefault = mysql_query($sqlqueryDefault);















































// if no matches found from query















if (!$resultDefault || (mysql_num_rows($resultDefault) == 0)){















//echo ("<b><font class=small>No matches were found.</font></b>");















}















// display the results















else{















// use rowcount to display total results found















$countDefault = mysql_num_rows($resultDefault);















//echo $count;















//echo("<p>Total Matches Found = " . $rowCount . "</p>"); //*debug















}































//set product header image depending on the Prod_Type Code















//start the table row















echo "<tr align=left><td colspan=6 class=small>";































echo "<img border=0 src=2003/searchheaders/general.jpg alt=General-Accessories>";































echo "</td></tr>";































while ($rowDefault = mysql_fetch_assoc($resultDefault))















{































//cut the prod_type variable















//get the length of the variable















$strLengthDefault = strlen ($rowDefault["Prod_Type"]);















//assign first 2 characters of variable















$strPrefixDefault = substr($rowDefault["Prod_Type"], 0, 2);















//debug















//echo htmlspecialchars($rowDefault["Prod_ID"]);















//echo "\n prefix :" . $strPrefixDefault;















//assign remaining characters of variable















$strSuffixDefault = substr($rowDefault["Prod_Type"], 2, $strLengthDefault);















//debug















//echo "\n suffix :" . $strSuffixDefault;















































if ($strSuffixDefault != "INFO"){















$color="#E9E9E9"; // Almost Silver















//print a product row if the prodtype isn't set to INFO















echo "<tr class=stdtable align=center height=25 ><td bgcolor=$color>". htmlspecialchars($rowDefault["Prod_Make"]) .















"</td><td bgcolor=$color>" . htmlspecialchars($rowDefault["Prod_REF"]) .















"</td><td bgcolor=$color align=left>" . htmlspecialchars($rowDefault["Product_Desc"]) .















"</td><td bgcolor=$color>?" . number_format(htmlspecialchars($rowDefault['Price_ExVat']), 2) .















"</td><td bgcolor=$color>?" . number_format((calcVAT (htmlspecialchars($rowDefault['Price_ExVat']))), 2) .















"</td><td bgcolor=$color><a href=basket.php?src=".urlencode($_SERVER['REQUEST_URI'])."&productID=" . $rowDefault["Prod_ID"] . "><img src=2003/buy.gif border=0></a></td></tr>";















}















// if the prod type is set to INFO then print out a new row for that information















else















{















echo "<tr class=stdtable align=center height=25 ><td colspan=6 bgcolor=$color><em>" . htmlspecialchars($rowDefault["Product_Desc"]) . "</em></td></tr>";















}















}











*/



?>
                <tr align="center">
                  <td colspan="7" class="small1"></td>
                </tr>
                <tr>
                  <!-- <tr align="center" class="headertable" height="32">















          <td width="145">Product Name</td>















          <td width="178">Ref No.</td>















          <td width="280">Description</td>















          <td width="73">Price Ex VAT</td>















          <td width="73">Price Inc VAT</td>















          <td width="60"><img src="2003/basket.gif" width="21" height="14"> </td>















        </tr>-->
                  <td colspan="7" height="1" bgcolor="#003366"><img src="colour_spacer.gif" width="756" height="1" /></td>
                </tr>
            </table></td>
          </tr>
        </table>
        <p><br />
          </p>
        </p>
        <div align="center"><br />
        </div>
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr>
            <td>&nbsp;</td>
          </tr>
</table>
        <?php































//free up some memory















mysql_free_result($result);



// close the aatabase connection

mysql_close();

//include footer code


?>
        <br />
      </table>


</html>

Hi guys

When I retrieve information from database into text field and update the fields, each time I press on update button, an space gets added before the text so in screenshots I have added you can see in image1 everything is fine but once I click on update, a space will be added before the text inside the text field.

Here is my code
<?php
session_start();
include ("global.php");


//username session
$_SESSION['username']=='$username';
$username=$_SESSION['username'];



//welcome messaage
echo "Welcome, " .$_SESSION['username']."!<p>";

  if ($_POST['register'])
    {
     //get form data
     $name = addslashes(strip_tags($_POST['name']));
     $telephonenumber = addslashes(strip_tags($_POST['telephonenumber']));
     $buildingnumber = addslashes(strip_tags($_POST['buildingnumber']));
     $streetname = addslashes(strip_tags($_POST['streetname']));
     $town = addslashes(strip_tags($_POST['town']));
     $county = addslashes(strip_tags($_POST['county']));
     $country = addslashes(strip_tags($_POST['country']));
     $postcode = addslashes(strip_tags($_POST['postcode']));
     $email = addslashes(strip_tags($_POST['email']));

//update statements
   
$query = "UPDATE  userss   SET name =' $name' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET telephonenumber = ' $telephonenumber' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET buildingnumber = ' $buildingnumber' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET streetname = ' $streetname' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET county = ' $county' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET town = ' $town' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET country = ' $country' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET postcode = ' $postcode' WHERE username='$username'";
$result = mysql_query($query);

$query = "UPDATE  userss   SET email = ' $email' WHERE username='$username'";
$result = mysql_query($query);

}

//update from database to txt field
$update = "SELECT name, telephonenumber, buildingnumber, streetname, country, town, postcode, county, email FROM userss WHERE username='$username'";
$result = mysql_query($update);
$row = mysql_fetch_assoc($result);
 
 
 
?>
  <form action='updateprofile.php' method='POST'>
     Name:<br />
    <input type='text' name='name' value='<?php echo $row['name'];?>'><p />
    Telephone Number:<br />
    <input type='text' name='telephonenumber' value='<?php echo $row['telephonenumber'];?>'><p />
    Building Number:<br />
    <input type='text' name='buildingnumber' value='<?php echo $row['buildingnumber'];?>'><p />
    Street Name:<br />
     <input type='text' name='streetname' value='<?php echo $row['streetname'];?>'><p />
     County:<br />
     <input type='text' name='county' value='<?php echo $row['county'];?>'><p />
     Town:<br />
     <input type='text' name='town' value='<?php echo $row['town'];?>'><p />
     Country:<br />
      <input type='text' name='country' value='<?php echo $row['country'];?>'><p />
      Postcode:<br />
      <input type='text' name='postcode' value='<?php echo $row['postcode'];?>'><p />
      Email:<br />
      <input type='text' name='email' value='<?php echo $row['email'];?>'><p />
             
    <input type='submit' name='register' value='Update'>
    </form>


    <iframe width="750" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="http://maps.google.co.uk/maps?f=q&amp;source=s_q&amp;hl=en&amp;geocode=&amp;q=<?php echo "$buildingnumber,+$streetname,+$town,+ $postcode,+$county,+$country";?>&amp;sll=&amp;sspn=0.007597,0.025921&amp;ie=UTF8&amp;hq=&amp;hnear=<?php echo "$buildingnumber,+$streetname,+$town,+ $postcode,+$county,+$country";?>&amp;ll=&amp;spn=0.011236,0.025921&amp;z=14&amp;output=embed"></iframe>


could someone kindly advice me on this please?

Hi.
I am trying to get a PHP Query to refresh every 10 seconds. I have scoured the internet for days and could not find anything of much use. Plenty of Ajax going on (whatever that is) but the scripts were immense. I only want to refresh 7 lines of PHP Query Code.

Can you please tell me if this is possible?

Thanks in Advance.