Learn VBA & Macros in 1 Week!

PHP - Blank Array

Full Excel VBA Course - Beginner to Expert

Blank Array	View Content

this form i have takes some csv data and turns it into an array. For some reason the script inserts a blank key into the array and idk why.
this is my script code:
Code: [Select]
<?php

if(isset($_POST['csv_btn'])){
$csv = $_POST['csv'];

//turns csv into an array with each spot in the array a player and all data seperated by a comma
$csv_mod = explode("Home,",$csv);

$y = count($csv_mod) - 1;
$x = 0;
$team = array();

while ($x <= $y){
//takes the array from the csv explode and explodes each player and their data
$tx = $csv_mod[$x];
$ex_tx = explode(",",$tx);

$ex_tx_c = count($ex_tx);
$z = 1;
//is the players name
$person = $ex_tx[0];
$person2 = $ex_tx[0];
//turn the player into an array
$person = array();
//puts the players data into their array
while ($z < $ex_tx_c){
array_push($person, $ex_tx[$z]);
$z++;
}
//adds the player to the team array with their name being the index
$team[$person2] = $person;
$x++;
}
print_r($team);
}

?>

this is what i put into the script(exactly like this):
Code: [Select]
Home,AJ,2,1,2,2,0,0,0,0,0,0,0,0
Home,Conner,0,0,2,2,0,0,0,0,0,0,0,0
Home,Joe,0,0,1,1,0,0,0,1,0,0,0,0
Home,Tyler,0,0,0,0,0,0,0,0,0,0,0,0

this is what it outputs:
Code: [Select]
Array
(
[] => Array
(
)

[AJ] => Array
(
[0] => 2
[1] => 1
[2] => 2
[3] => 2
[4] => 0
[5] => 0
[6] => 0
[7] => 0
[8] => 0
[9] => 0
[10] => 0
[11] => 0

)

[Conner] => Array
(
[0] => 0
[1] => 0
[2] => 2
[3] => 2
[4] => 0
[5] => 0
[6] => 0
[7] => 0
[8] => 0
[9] => 0
[10] => 0
[11] => 0

)

[Joe] => Array
(
[0] => 0
[1] => 0
[2] => 1
[3] => 1
[4] => 0
[5] => 0
[6] => 0
[7] => 1
[8] => 0
[9] => 0
[10] => 0
[11] => 0

)

[Tyler] => Array
(
[0] => 0
[1] => 0
[2] => 0
[3] => 0
[4] => 0
[5] => 0
[6] => 0
[7] => 0
[8] => 0
[9] => 0
[10] => 0
[11] => 0
)

)

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Php Array-search Returns A Blank

Echoing Array Index And Getting A Blank Page

Very Odd, Fetch_assoc() Array Resulting In Blank White Page

Please Help, My Page Is Blank?!

Php: Blank Page

Blank Page Out Of Nowhere

Getting A Blank Page :(

Blank At Random

Blank Screen Of Death

Putting A Blank Value Into Mysql?

$_get Always Returns Blank

Please Help Form Just Showing Blank

Mysql Updating Row To Blank Value

Blank Row Being Inserted In Top Of Mysql.

Getting A Blank White Screen...

Updating A Field To A Blank

Learn VBA & Macros for Excel in 1 Week!

Php Array-search Returns A Blank

Similar Tutorials

In the following code: echo $text[2] returns the word at that index but echo $key returns a blank.

Can someone explain why is array-search not working in this indexed array?

It does work when I test it with a key => value type array.

<?php $myfile = fopen("test.txt", "r") or die("Unable to open file!");

while(!feof($myfile)) {

$text[] = fgets($myfile); }

fclose($myfile);

$word = $_POST['word'];

$key = array_search($word, $text);

echo $key ?>

Echoing Array Index And Getting A Blank Page

Similar Tutorials

<?

$array = array('eggs', 'bacon', 'football', 'baseball', 'ford', 'toyota');

$rand_index = mt_rand(0, count($array) / 2 - 1) * 2;
?>

<?php echo "$array[$rand_index]"; ?><?php echo "$array[$rand_index+1]"; ?>

i dunno why this doesn't work. I want to echo both values three of the pairs such as eggs bacon or football baseball

Very Odd, Fetch_assoc() Array Resulting In Blank White Page

Similar Tutorials

Ok, this is rather bizarre. First this code...
            if($postCount > 0)
            {
                $i = 0;
                while($row = $this->db->fetch_assoc($post_pagination->resource()))
                {
                //    echo $row['post_message'];
                    $content .= ($i % 2 == 0 ? '<tr class="odd">' : '<tr>');
                    $content .= '<table>';
                    $content .= '<tr><td>'.$row['username'].'</td></tr>';
                    $content .= '<tr>';
                    $content .= '<td><p>'.$row['post_message'].'</p></td>';
                    $content .= '</tr>';
                    $content .= '</table>';
                    $content .= '</tr>';
                    $i++;
                }
                $content .= '<tr><td>| '.$plinks.' |</td></tr>';
            }

For whatever reason, if I comment out the line with $row['post_message'] everything works as expected. If I leave that in there like it is now, I get a completely blank white page.

I've also tried assigning it to a variable within the loop like...
$post_message = $row['post_message'];
and that works fine, until I try echo'ing it then the same blank white page result.

I've double checked the query, both in PHP and in PHPMyAdmin and it is working correctly.

Here's the query code:
            $post_pagination = new pagination($ppg, "SELECT `posts`.`post_id`, `posts`.`post_message`, `cg_accounts`.`id`, `cg_accounts`.`username`
                                       FROM `".$this->dbname."`.`threads`, `".$this->dbname."`.`posts`
                                       INNER JOIN `crikeyga_central`.`cg_accounts` ON (`cg_accounts`.`id` = `posts`.`userid`)
                                       WHERE `posts`.`thread_id`=`threads`.`thread_id`
                                       AND `posts`.`thread_id`='".$thread_id."'
                                       ORDER BY `posts`.`post_timestamp` ASC");
I've also double checked the pagination class is working as expected, and it's fine in every other page it's used in. Also $ppg is the correct value(simply holds the current page number). $this->dbname is also correct, and as mentioned above the query works in PHPMyAdmin.

And $post_pagination->resource() is holding the correct value and I've checked the database class in particular $this->db->fetch_assoc() and that's working fine.

Really not having much luck pinning this one down, no errors are coming up(error reporting(E_ALL)).

seems strange to me that $row['username'] comes up fine, but $row['post_message'] results in a white page. The values are also what they should be.

Any help is appreciated!

Thanks, Ace

Please Help, My Page Is Blank?!

Similar Tutorials

my page: http://www.retroandvintage.co.uk/register.php

my code
Code: [Select]
<?php
error_reporting(E_ALL) ; ini_set('display_errors', 1) ;
session_start();
include_once("config.php");
require_once('captcha/recaptchalib.php');
$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);

/*
Login script:
This script does the following:

Checks that the user is NOT already logged in - if they are they
are redirected to the members page by the 'checkLoggedIn()' function.

Checks if the login form has been submitted - if so, the 'login' and
'password' fields are checked to ensure they are of the correct format and length.
If there are any problems here an error is added to the $messages array and
then the script executes the 'doIndex()' function - this function basically
outputs the main 'index' page for this script - ie the login form.

If there are no problems with the previous step, the 'login' and 'password'
field data is passed to the 'checkPass' function to check that an entry
exists in the 'users' table for that login/password pair.
If nothing is returned from the 'checkPass()' function, an error is
added to the $messages array and the 'doIndex()' function is called as above.

If a row of data is returned from the 'users' table, the data is passed to
the 'cleanMemberSession()' function - which initializes session variables and
logs the user in.  The user is then forwarded to the members page.

If the form hasn't yet been submitted, then the 'doIndex()' function is called
and the login page is displayed.
*/
// Check user not logged in already:
checkLoggedIn("no");

// Page title:
$title="Member Login Page";

// if $submit variable set, login info submitted:
if(isset($_POST["login"])) {
//
// Check fields were filled in
//
// login must be between 4 and 15 chars containing alphanumeric chars only:
field_validator("rsUser", $_POST["rsUser"], "alphanumeric", 4, 15);
// password must be between 4 and 15 chars - any characters can be used:
field_validator("rsPass", $_POST["rsPass"], "string", 4, 15);

// if there are $messages, errors were found in validating form data
// show the index page (where the messages will be displayed):
if($messages){
doIndex();
// note we have to explicity 'exit' from the script, otherwise
// the lines below will be processed:
exit;
}

// OK if we got this far the form field data was of the right format;
// now check the user/pass pair match those stored in the db:
/*
If checkPass() is successful (ie the login and password are ok),
then $row contains an array of data containing the login name and
password of the user.
If checkPass() is unsuccessful however, $row will simply contain
the value 'false' - and so in that case an error message is
stored in the $messages array which will be displayed to the user.
*/
    if( !($row = checkPass($_POST["rsUser"], $_POST["rsPass"])) ) {
// login/passwd string not correct, create an error message:
        $messages[]="Incorrect login/password, try again";
    }

/*
If there are error $messages, errors were found in validating form data above.
Call the 'doIndex()' function (which displays the login form) and exit.
*/
if($messages){
doIndex();
exit;
}

/*
If we got to this point, there were no errors - start a session using the info
returned from the db:
*/
cleanMemberSession($row["rsUser"], $row["rsPass"]);

// and finally forward user to members page (populating the session id in the URL):
header("Location: main.php");
} else {
// The login form wasn't filled out yet, display the login form for the user to fill in:
doIndex();
}

function doIndex() {
/*
Import the global $messages array.
If any errors were detected above, they will be stored in the $messages array:
*/
global $messages;

/*
also import the $title for the page - note you can normally just declare all globals on one line
- ie:
global $messages, $title;
*/
global $title;
}
// if $submit variable set, login info submitted:
if(isset($_POST["register"])) {

  $privatekey = "6Ldhhr4SAAAAAKFoL2INOZV0_VuF6_z3OwDjVFNn";
  $resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

  if (!$resp->is_valid) {
    // What happens when the CAPTCHA was entered incorrectly
    die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." .
         "(reCAPTCHA said: " . $resp->error . ")");
  } else {
    // Your code here to handle a successful verification
$rsPostCode = $_POST['rsPostCode'];
$rsGender = $_POST['rsGender'];
$rsUser = $_POST['rsUser'];
   $rsPass = $_POST['rsPass'];
$rsEmail = $_POST['rsEmail'];
$rsMobile = $_POST['rsMobile'];
$rsAge = $_POST['rsAge'];

$to = 'john.mbiddulph@gmail.com';

//define the subject of the email
$subject = 'New user added to My Pub Space';

// message
$message = '
<html>
<head>
  <title>'.$subject.'</title>
</head>
<body>
  <table>
    <tr>
      <td>Name:</td>
<td>'.$rsUser.'</td>
    </tr>
    <tr>
      <td>Email:</td>
<td>'.$rsEmail.'</td>
    </tr>
    <tr>
      <td>Telephone:</td>
<td>'.$rsMobile.'</td>
    </tr>
<tr>
      <td>Age:</td>
<td>'.$rsAge.'</td>
    </tr>
<tr>
      <td>Password:</td>
<td>'.$rsPass.'</td>
    </tr>
  </table>
</body>
</html>
';

// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers
$headers .= 'To:' .$to. "\r\n";
$headers .= 'From:' .$rsEmail. "\r\n";

// Mail it
mail($to, $subject, $message, $headers);

   $sql = "INSERT INTO members_copy (RSPOSTCODE, RSGENDER, RSUSER, RSPASS, RSEMAIL, RSMOBILE, RSAGE) VALUES ('$rsPostCode', '$rsGender', '$rsUser', '$rsPass', '$rsEmail', '$rsMobile', '$rsAge');";
//echo $sql;
mysql_query($sql);
//
// Check fields were filled in
//
// login must be between 4 and 15 chars containing alphanumeric chars only:
field_validator("rsUser", $_POST["rsUser"], "alphanumeric", 4, 15);
// password must be between 4 and 15 chars - any characters can be used:
field_validator("rsPass", $_POST["rsPass"], "string", 4, 15);

// if there are $messages, errors were found in validating form data
// show the index page (where the messages will be displayed):
if($messages){
doIndex();
// note we have to explicity 'exit' from the script, otherwise
// the lines below will be processed:
exit;
}

// OK if we got this far the form field data was of the right format;
// now check the user/pass pair match those stored in the db:
/*
If checkPass() is successful (ie the login and password are ok),
then $row contains an array of data containing the login name and
password of the user.
If checkPass() is unsuccessful however, $row will simply contain
the value 'false' - and so in that case an error message is
stored in the $messages array which will be displayed to the user.
*/
    if( !($row = checkPass($_POST["rsUser"], $_POST["rsPass"])) ) {
// login/passwd string not correct, create an error message:
        $messages[]="Incorrect login/password, try again";
    }

/*
If there are error $messages, errors were found in validating form data above.
Call the 'doIndex()' function (which displays the login form) and exit.
*/
if($messages){
doIndex();
exit;
}

/*
If we got to this point, there were no errors - start a session using the info
returned from the db:
*/
cleanMemberSession($row["rsUser"], $row["rsPass"]);

// and finally forward user to members page (populating the session id in the URL):
header("Location: main.php");
}

/*
This function displays the default 'index' page for this script.  This consists of just a simple
login form for the user to submit their username and password.
*/
function doIndex() {
/*
Import the global $messages array.
If any errors were detected above, they will be stored in the $messages array:
*/
global $messages;

/*
also import the $title for the page - note you can normally just declare all globals on one line
- ie:
global $messages, $title;
*/
global $title;
}

// drop out of PHP mode to display the plain HTML:
$query1 = "SELECT * FROM outcodepostcodes";
$result = mysql_query($query1);
?>
<!doctype html>
<html>
<head>
<title>List of Pubs and Bars in the UK</title>
<meta name="description" content="Pubs and bars in the UK, nightlife for food and drink" />
<meta name="keywords" content="Pubs, bars, List, uk, nightlife, drinking, drinks, beer, lager, food" />
<meta name="Content-Language" content="en-gb" />
<meta name="robots" content="FOLLOW,INDEX" />
<meta name="revisit-after" content="2 days" />
<meta name="copyright" content="jbiddulph.com" />
<meta name="author" content="John Biddulph - Professional web site design and development in the south of england mainly worthing and brighton" />
<meta name="distribution" content="Global" />
<meta name="resource-type" content="document" />
<link rel="stylesheet" type="text/css" href="css/reset.css" />
<link rel="stylesheet" type="text/css" href="css/style.css" title="default" />
<link rel="alternate stylesheet" type="text/css" href="css/style1.css" title="1" />
<link rel="alternate stylesheet" type="text/css" href="css/style2.css" title="2" />
<script type="text/javascript" src="js/stylechanger.js"></script>
<script type="text/javascript" src="js/jquery-1.2.1.pack.js"></script>
<script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script type="text/javascript">
function lookup(inputString) {
if(inputString.length == 0) {
// Hide the suggestion box.
$('#suggestions').hide();
} else {
$.post("rpc.php", {queryString: ""+inputString+""}, function(data){
if(data.length >0) {
$('#suggestions').show();
$('#autoSuggestionsList').html(data);
}
});
}
} // lookup

function fill(thisValue) {
$('#inputString').val(thisValue);
setTimeout("$('#suggestions').hide();", 200);
}
</script>
<script type="text/javascript">
var RecaptchaOptions = {
theme : 'white'
};
</script>
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css">
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css">
</head>
<body>
<?php if($messages) { displayErrors($messages); }?>
<header>
<div id="title">
<h1>My Pub Space
<a href="#" onClick="setActiveStyleSheet('default'); return false;"><img src="images/0.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('1'); return false;"><img src="images/1.gif" width="15" height="15" border="0" alt="css style" /></a> <a href="#" onClick="setActiveStyleSheet('2'); return false;"><img src="images/2.gif" width="15" height="15" border="0" alt="css style" /></a>
<span>
<form method="post" class="textbox" action="search.php">
Town/City: <input type="text" size="26" class="searchbox" value="" name="rsTown" id="inputString" onKeyUp="lookup(this.value);" onBlur="fill();" />

<div class="suggestionsBox" id="suggestions" style="display: none;">
<img src="images/upArrow.png" style="position: relative; top: -36px; left: 105px; z-index:1;" alt="upArrow" />
<div class="suggestionList" id="autoSuggestionsList">
  </div>
</div>
<input type="image" src="images/go.png" height="30" with="30" value="GO" />
</form>
</span>
</h1>
</div>
</header>
<nav>
<ul>
<li><a href="default.php">Home</a></li>
<li><a href="#">Pubs</a></li>
<li><a href="#">Members</a></li>
<li><a href="#">Events</a></li>
<li class="selected"><a href="#">Register</a></li>
</ul>
</nav>
<section id="intro">
<header>
<h2>Your social guide to going down the pub, online!</h2>
</header>
<p>Stuck in town with nowhere to go? Not sure if up the road or down the street is best? Need to be somewhere warm, cosy and friendly. Need a drink?....<br />You've come to the right place, mypubspace has it all!</p>
<img src="images/pub.jpg" alt="pub" /> </section>
<div id="content">
<div id="mainContent">
<section>
<article class="blogPost">
<header>
<h2>Register to My Pub Space</h2>
<form name="register" method="post" action="">
<input name="LoginCount" type="hidden" value="1" /><input name="LastLogin" type="hidden" value="<%= Now()%>" />
<table width="100%">
<tr>
<td class="text">Post Code</td>
<td><span id="spryselect1">
<select name="rsPostCode" class="postcodedrop">
<?PHP while($row = mysql_fetch_array($result))
{

echo '<option name=\"menuarea\" class=\"postcodedrop\" value='.$row['outcode'].' />';
echo $row['outcode'];
}?>
</select>
<span class="selectRequiredMsg">Please select an item.</span></span><i>Helps us find your local pubs!</i></td>
</tr>
<tr>
<td class="text">Gender:</td>
<td>Male
<input name="rsGender" type="radio" value="Male" />
Female
<input name="rsGender" type="radio" value="Female" /></td>
</tr>
<tr>
<td class="text">User Name:</td>
<td><span id="sprytextfield1">
<input name="rsUser" type="text" class="textbox" id="rsUser" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
</tr>
<tr>
<td class="text">Password:</td>
<td><span id="sprytextfield2">
<input name="rsPass" type="password" class="textbox" id="rsPass" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
</tr>
<tr>
<td class="text">Confirm Password:</td>
<td><span id="sprytextfield3">
<input name="rsPass2" type="password" class="textbox" id="rsPass2" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
</tr>
<tr>
<td class="text">Email:</td>
<td><span id="sprytextfield4">
<input name="rsEmail" type="text" class="textbox" id="rsEmail" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
</tr>
<tr>
<td class="text">Mobile:</td>
<td><span id="sprytextfield5">
<input name="rsMobile" type="text" class="textbox" id="rsMobile" />
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
</tr>
<tr>
<td class="text">Age:</td>
<td><span id="sprytextfield6">
<input name="rsAge" type="text" class="textbox" id="rsAge" /> <i>dd/mm/yyyy</i>
<span class="textfieldRequiredMsg">A value is required.</span></span></td>
</tr>
<tr>
<td> </td>
<td><?php
require_once('captcha/recaptchalib.php');
$publickey = "6Ldhhr4SAAAAACAnyp4o6NDHjZvRlS6rnHNa-Enz"; // you got this from the signup page
echo recaptcha_get_html($publickey);
  ?></td>
</tr>
<tr>
<td> </td>
<td><input name="register" type="submit" class="button" value="Register" /></td>
</tr>
</table>
</form>
</header>
</article>
</section>
</div>
<aside>
<section>
<header>
<h3>Members Login Area</h3>
</header>
<form method="post" class="textbox" action="<?php print $_SERVER["PHP_SELF"]; ?>">
Username: <br />
<input type="text" class="textbox" name="rsUser" value="<?php print isset($_POST["rsUser"]) ? $_POST["rsUser"] : "" ; ?>">
Password: <br />
<input type="password" class="textbox" name="rsPass">
<br />
<br />
<input name="login" type="submit" value="Login">
<br />
</form>
<ul>
<li><a href="#">Sign up</a></li>
<li><a href="#">Forgot Password</a></li>
</ul>
</section>
<section>
<header>
<h3>Archives</h3>
</header>
<ul>
<li><a href="#">December 2008</a></li>
<li><a href="#">January 2009</a></li>
<li><a href="#">February 2009</a></li>
<li><a href="#">March 2009</a></li>
<li><a href="#">April 2009</a></li>
<li><a href="#">May 2009</a></li>
<li><a href="#">June 2009</a></li>
</ul>
</section>
</aside>
</div>
<footer>
<div>
<section id="about">
<header>
<h3>About</h3>
</header>
<p>Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco <a href="#">laboris nisi ut aliquip</a> ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>
</section>
<section id="blogroll">
<header>
<h3>Blogroll</h3>
</header>
<ul>
<li><a href="#">NETTUTS+</a></li>
<li><a href="#">FreelanceSwitch</a></li>
<li><a href="#">In The Woods</a></li>
<li><a href="#">Netsetter</a></li>
<li><a href="#">PSDTUTS+</a></li>
</ul>
</section>
<section id="popular">
<header>
<h3>Popular</h3>
</header>
<ul>
<li><a href="#">This is the title of a blog post</a></li>
<li><a href="#">Lorem ipsum dolor sit amet</a></li>
<li><a href="#">Consectetur adipisicing elit, sed do eiusmod</a></li>
<li><a href="#">Duis aute irure dolor</a></li>
<li><a href="#">Excepteur sint occaecat cupidatat</a></li>
<li><a href="#">Reprehenderit in voluptate velit</a></li>
<li><a href="#">Officia deserunt mollit anim id est laborum</a></li>
<li><a href="#">Lorem ipsum dolor sit amet</a></li>
</ul>
</section>
</div>
</footer>
<script type="text/javascript">

</script>
</body>
</html>
<?php
}
?>

Blank Page

Similar Tutorials

Why am I getting a blank page with no errors with the following code?

Code: [Select]
<?php
session_start();
if (isset($_SESSION['cart'])){
foreach ($_SESSION['cart'] as $key => $value){
echo "Product Number $key Quantity $value<br />";
}
}
require_once("functions.php");
//DatabaseConnection();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ordering doggy treats</title>
<link href="doggyTreats.css" rel="stylesheet" type="text/css" />
<style type="text/css">
#order {

margin-right: auto;
margin-left: auto;
}
.orderRow{
padding-bottom: 50px;
}
h2 {
text-align: center;
}

</style>
</head>
<body>

<?php
$errors=array();
if(isset($_POST['submit'])){
validate_input();
if(count($errors) !=0)
{
display_form();
}
else
{
display_form();
}
function validate_input()
{
global $errors;
if($_POST["fname"] == " ")
{
$errors['fname']="<span style=\"color:red;\">
Please enter your first name </span>";
}
}
}
//logo();
navBar();
function display_form() {
global $errors;
extract($_POST);
if(!isset($submit))
{
?>
<table id="order">
<form action="checkOut.php" method="post" name="checkOut">
<caption><h2>Customer Information </h2> </caption>
<tr class = "orderRow">
<td> First Name:<br />
<input name="fname" type="text" size="10" maxlength="20" value="<?php echo $_POST[fname];?>"/>
</td>
<td> Last Name: <br />
<input name="lname" type="text" size="10" maxlength="20" />
</td>
<td> Address: <br />
<input name="address " type="text" size="25" />
</td>
</tr>
<tr class = "orderRow">
<td> City: <br />
<input name="city " type="text" size="15" maxlength="20" />
</td>
<td> State: <br />
<select name = "state"> <option selected value ="Please choose a state"/>
Please choose a state</option>
<option value = "AL" />AL</option>
<option value = "AK" />AK</option>
<option value = "AR" />AR</option>
<option value = "AZ" />AZ
<option value = "CA" />CA
<option value = "CO" />CO
<option value = "CT" />CT
<option value = "DE" />DE
<option value = "DC" />DC
<option value = "FL" />FL
<option value = "GA" />GA
<option value = "HI" />HI
<option value = "IA" />IA
<option value = "ID" />ID
<option value = "IL" />IL
<option value = "IN" />IN
<option value = "KS" />KS
<option value = "KY" />KY
<option value = "LA" />LA
<option value = "MA" />MA
<option value = "ME" />ME
<option value = "MD" />MD
<option value = "MI" />MI
<option value = "MN" />MN
<option value = "MO" />MO
<option value = "MS" />MS
<option value = "MT" />MT
<option value = "NC" />NC
<option value = "ND" />ND
<option value = "NE" />NE
<option value = "NH" />NH
<option value = "NJ" />NJ
<option value = "NM" />NM
<option value = "OH" />OH
<option value = "OK" />OK
<option value = "OR" />OR
<option value = "PA" />PA
<option value = "RI" />RI
<option value = "SC" />SC
<option value = "SD" />SD
<option value = "TN" />TN
<option value = "TX" />TX
<option value = "UT" />UT
<option value = "VA" />VA
<option value = "VT" />VT
<option value = "WA" />WA
<option value = "WI" />WI
<option value = "WV" />WV
<option value = "WY" />WY
</select>
</td>
<td> Zip Code:<br />
<input name="zipcode" type="text" size="5" maxlength="5" />
</td>
</tr>
<tr class = "orderRow">
<td> Phone <br /> Please include area code <br />
<input name="phone" type="text" size="13" maxlength="13" />
</td>
<td> Fax:<br />
<input name="" type="text" size="13" maxlength="13" />
</td>
<td> Email: <br />
<input name="email " type="text" size="15" maxlength="30" />
</td>
</tr>
<tr class = "orderRow">
<td> Please choose method of payment: <br />
Check <input name="check " type="radio" value="Check " /> Money Order <input name="money " type="radio" value="Money order " /><br />PayPal<input name="paypal" type="radio" value="Paypal" /> </td>
</tr>
<tr>
<td colspan = "6"> <h2> Pet Information </h2></td>
</tr>
<tr>
<td> Name: <br />
<input name="petName" type="text" size="10" maxlength="20" />
</td>
<td> Age: <br />
<select name="age">
HEREDOC;
for ($age =1; $age <=20; $age ++)
{
print "<option value=\"age\"> $age</option>";
}
echo <<<HEREDOC
</select>
</td>
<td> Breed:<br />
<select name = "breed"> <option selected value ="Please choose a breed"/>
Please choose a breed
<option value = "I don't know" />I don't know
<option value = "Affernpincher" />Affernpincher
<option value = "Afghan Hound" />Afghan Hound
<option value = "Airedale Terrier" /> Airedale Terrior
<option value = "Akita" /> Akita
<option value = "Alaskan Malamute" /> Alaskan Malamute
<option value = "Standard American Eskimo Dog"/> Standard American Eskimo Dog
<option value = "Miniature American Eskimo Dog"/>Miniature American Eskimo Dog
<option value = "Toy American Eskimo Dog"/> Toy American Eskimo Dog
<option value = "American Foxhound" /> American Foxhound
<option value = "American Staffordshire Terrier" /> American Staffordshhire Terrier
<option value = "American Water Spaniel" /> American Water Spaniel
<option value = "Australian Shepherd Dog"/> Anatolian Shepherd Dog
<option value = "Australian Cattle Dog"/> Australian Cattle Dog
<option value = "Australian Shepherd"/> Australian Shepherd
<option value = "Australian Terrier" /> Australia Terrier
<option value = "Basenji" /> Basenji
<option value = "Basset Hound" /> Basset Hound
<option value = "Beagle" /> Beagle
<option value = "Bearded Collie" /> Bearded Collie
<option value = "Beauceron" /> Beauceron
<option value = "Bedington Terrier"/> Bedington Terrier
<option value = "Belgin Malinois"/> Belgin Malinois
<option value = "Belgian Sheepdog"/> Belgian Sheepdog
<option value = "Belgian Tervuren"/> Belgian Tervuren
<option value = "Bernese Mountain Dog"/> Bernese Mountain Dog
<option value = "Bichon Frise"/> Bichon Frise
<option value = "Black and Tan Greyhound" /> Black and Tan Greyhound
<option value = "Black Russian Terrier" /> Black Russian Terrier
<option value = "Bloodhoung" /> Bloodhound
<option value = "Border Collie" /> Border Collie
<option value = "Border Terrier"/> Border Terrier
<option value = "Borzoi"/> Borzoi
<option value = "Boston Terrier"/> Boston Terrier
<option value = "Bouvier des Flandres"/> Bouvier des Flandres
<option value = "Boxer"/> Boxer
<option value = "Briard"/> Briard
<option value = "Brittany" /> Brittany
<option value = "Brussels Griffon" /> Brussels Griffon
<option value = "Bulldog" /> Bulldog
<option value = "Bullmastiff" /> Bullmasttiff
<option value = "Bull Terrier" /> Bull Terrier
<option value = "Cairn Terrier" /> Cairn Terrier
<option value = "Canaan Dog" /> Canaan Dog
<option value = "Cardigan Welsh Corgi" /> Cardigan Welsh Corgi
<option value = "Cavalier King Charles Spaniel" />Cavalier King Charles Spaniel
<option value = "Chesepeake Bay Retriever" />Chesapeake Bay Retriever
<option value = "Chilauhua" /> Chilauhua
<option value = "Chinese Created" /> Chinese Crested
<option value = "Chinese Shar-Pei" /> Chinese Shar-Pei
<option value = "Chow Chow" /> Chow Chow
<option value = "Clumber Spaniel" /> Clumber Spaniel
<option value = "Cocker Spaniel" /> Cocker Spaniel
<option value = "Collie" /> Collie
<option value = "Curly-Coated Retrieve" /> Curly-Coated Retriever
<option value = "Dachshound" /> Dachshund
<option value = "Dalmation" /> Dalmation
<option value = "Dandle Dimonnt" /> Dandie Dinmont Terrier
<option value = "Doberman Pincher" /> Doberman Pincher
<option value = "Dogue de Bordeaux" /> Dogue de Bordeaux
<option value = "English Cocker Spaniel" /> English Cocker Spaniel
<option value = "English Foxhound" /> English Foxhound
<option value = "English Setter" /> English Setter
<option value = "English Springer" /> English Springer
<option value = "English Toy Spaniel" /> English Toy Spaniel
<option value = "Field Spaniel" /> Field Spaniel
<option value = "Finnish Spitz" /> Finnish Spitz
<option value = "Flat-Coated Retriever" /> Flat-Coated Retriever
<option value = "French Bulldog" /> French Bulldog
<option value = "German Shepherd Dog" /> German Shepherd Dog
<option value = "German Shorthaired Pointer"/>German Shorthaired Pointer
<option value = "German Wirehaired Pointer" /> German Wirehaired Pointer
<option value = "Giant Schnauzer" /> Giant Schnauzer
<option value = "Glen of Imaal Terrier" /> Glen of Imaal Terrier
<option value = "Golden Retriever" /> Golden Retriever
<option value = "Gorden Setter" /> Gorden Setter
<option value = "Great Dane" /> Great Dane
<option value = "Greater Swiss Mountain Dog" /> Greater Swiss Mountain Dog
<option value = "Great Pyrenees" /> Great Pyrenees
<option value = "Greyhound" /> Greyhound
<option value = "Harrier" /> Harrier
<option value = "Havanese" /> Havanese
<option value = "Ibizen Hound" /> Ibizen Hound
<option value = "Irish Setter" /> Irish Setter
<option value = "Irish Terrier" /> Irish Terrier
<option value = "Irish Water Spaniel" /> Irish Water Spaniel
<option value = "Irish Wolfhound" /> Irish Wolfhound
<option value = "Italian Greyhound" /> Italian Greyhound
<option value = "Jack Russell Terrier" /> Jack Russell Terrier
<option value = "Japanese Chin" /> Japanese Chin
<option value = "Keeshound" /> Keeshound
<option value = "Kerry Blue TErrier" /> Kerry Blue Terrier
<option value = "Komondor" /> Komondor
<option value = "Kuvasz" /> Kuvasz
<option value = "Labradar Retriever" /> Labrador Retriever
<option value = "Lakeland Terrier" /> Lakeland Terrier
<option value = "Lhasa Apso" /> Lhasa Apso
<option value = "Lowchen" /> Lowchen
<option value = "Maltese" /> Maltese
<option value = "Standard Manchester Terrier" /> Standard Manchester Terrier
<option value = "Mastiff" /> Mastiff
<option value = "Miniature Bull Terrier" /> Miniature Bull Terrier
<option value = "Miniature Pinche" /> Miniature Pinscher
<option value = "Miniature Poodle" /> Miniature Poodle
<option value = "Miniature Schnauzer" />Miniature Schnauzer
<option value = "Mutt" />Mutt
<option value = "Neopolitan Mastiff" />Neopolitan Mastiff
<option value = "Newfoundland&nbsp" /> Newfoundland
<option value = "Newfolk Terrier" />Norfolk Terrier
<option value = "Norwegian Elkhound" /> Norwegian Elkhound
<option value = "Norwich Terrier" /> Norwich Terrier
<option value = "Nova Scotia Duck Tolling Retriever" /> Nova Scotia Duck Tolling Retriever
<option value = "Old English Sheepdog" />Old English Sheepdog
<option value = "Otterhound" /> Otterhound
<option value = "Papillon" />Papillon
<option value = "Parson Russell Terrier" /> Parson Russell Terrier
<option value = "Pekingese" />Pekingese
<option value = "Pembroke Welsh Corgi" />Pembroke Welsh Corgi
<option value = "Petit Basset Griffon Vendeen" />Petit Basset Griffon Vendeen
<option value = "Pharch Hound" />Pharoh Hound
<option value = "Plott" /> Plott
<option value = "Pointer" /> Pointer
<option value = "Polish Lowland Sheepdog" />Polish Lowland sheepdog
<option value = "Pomeranian" /> Pomeranian
<option value = "Portuguese Water Dog" />Portuguese Water Dog
<option value = "Pug" />Pug
<option value = "Pull" />Puli
<option value = "Rhodesian Ridgeback" />Rhodesian Ridgeback
<option value = "Rottweiler" />Rottweiler
<option value = "ASaint Bernard" /> Saint Bernard
<option value = "Saluki" /> Saluki
<option value = "Samoyed" />Samoyed
<option value = "Schipperke" />Schipperke
<option value = "Scottish Doverhound" />Scottish Deerhound
<option value = "Scottish Terrier" />Scottish Terrier
<option value = "Sealyham Terrier" />Sealyham Terrier
<option value = "Shetland Sheepdog" />Shetland Sheepdog
<option value = "Shiba Inu" />Shiba Inu
<option value = "Shih Tzu" />Shih Tzu
<option value = "Siberian Husky" />Siberian Husky
<option value = "Silky Terrier" />Silky Terrier
<option value = "Skye Terrier" />Skye Terrier
<option value = "Smooth Fox Terrier" />Smooth Fox Terrier
<option value = "Soft Coated Wheaten Terrier" />Soft Coated wheaten Terrier
<option value = "Spinone Italiano" />Spinone Italiano
<option value = "Staffordshire Bull Terrier" />Staffordshire Bull Terrier
<option value = "Standard Poodle" />Standard Poodle
<option value = "Standard Schnauer" /> Standard Schnauzer
<option value = "Suseex Spaniel" />Sussex Spaniel
<option value = "Swedish Vallhound" />Swedish Vallhund
<option value = "Tibertan Mastiff" />Tibetan Mastiff
<option value = "Tibertan Spaniel" />Tibetan Spaniel
<option value = "Tibetan Terrier" />Tibetan Terrier
<option value = "Toy Fox Terrier" />Toy Fox Terrier
<option value = "Toy Manchester Terrier" />Toy Manchester Terrier
<option value = "Toy Poodle" />Toy Poodle
<option value = "Vizela" />Vizela
<option value = "Weimaraner" />Weimaraner
<option value = "Welsh Springer Spaniel" />Welsh Springer Spaniel
<option value = "Welsh Terrier" />Welsh Terrier
<option value = "West Highland White Terrier" />West Highland White Terrier
<option value = "Whippet" />Whippet
<option value = "Wire Fox Terrier" />Wire Fox Terrier
<option value = "Wirehaired Pointing Griffon" />Wirehaired Pointing Griffon
<option value = "Yorkshire Terrier" />Yorkshire Terrier

</td>
</select>
</tr>
<tr>
<td>Nutritional Needs:</td>
<td><textarea name="nutritionalNeeds" cols="17" rows="5"></textarea>
</td>
</tr>
<tr>
<td>Special Instructions</td>
<td><textarea name="specialInstructions" cols="17" rows="5"></textarea>
</tr>
<tr>
<td colspan = "6"><h2>Order Information</h2></td>
</tr>
<tr>
HEREDOC;
foreach($key as $value){
echo $value;
}
echo <<<HEREDOC
</tr>
<tr>
<td> <input name="Submit" type="submit" value="Order Treats!" /></td><td><input name="reset" type="submit" value="Cancel Order" /> </td>
</tr>
</table>
</form>
HEREDOC;
}
}
<?php
footer();
?>
</body>
</html>

Blank Page

Similar Tutorials

It maybe related to my other post about outdated value I got myself a server and now it's on Centos 5.11 with Apache 2.2.3, PHP 5.3.3, & MySQL 5.0.95 I put all database inside as well as the web files. And just about the time when I think it's all done I tested and...things are just wrong... 2 web file folders were put to 2 sub directory of var/www/html 1 using mysql_connect and another mysqli_connect The one using mysql_connect can connect just fine, however some list are blank, while the one using mysqli_connect totally can't connect to the database. Then I cut a pieces of the connection part n put it alone to test the connection, but I get blank page

	$con=mysqli_connect("localhost","username","password","dbname") or die("Error ".mysqli_error($con));

Completely nothing but a blank page is the result of the code. I wish I can see error page so I can start with the wrong part, but here again...I'm clueless on what's going on

[root@localhost ~]# yum list installed | grep mysql
mysql.x86_64                             5.0.95-5.el5_9                installed
mysql-connector-odbc.x86_64              3.51.26r1127-2.el5            installed
mysql-server.x86_64                      5.0.95-5.el5_9                installed
php53-mysql.x86_64                       5.3.3-26.el5_11               installed
[root@localhost ~]# php -m | grep mysql
mysql
mysqli
pdo_mysql
[root@localhost ~]#

Anyone know the solution or this or had the same problem can shed a light into this ? Thanks in advance,

Php: Blank Page

Similar Tutorials

elloo,

i have php script that works fine on a dev server however on staging server it is a blank page. i have set 'error_reporting(E_ALL) ' and ini_set('dsiplay_errors', 1) however only information i get is some notices and no fatal errors.

i'm aware that php stops executing if there is a fatal error (and appears as blank screen), is there some sort of directive in 'php.ini' which stop php from executing when there are notices.

thanks in advanced

Blank Model

Similar Tutorials

Hi,

I have a cakePHP program that works and displays data from a database table.
The part I dont understand and I couldnt find anything on the cakephp blog as yet was the model was left blank?

q1) The model is left blank but still works so what is the default behaviour here for the model? It doesnt seem to be needed to do anything i?.

q2)I am selecting all the data from 1 table but how do I add a sql statement to select part of the table or a join of 2 tables? the find 'all' seems to just do that only in finding all data from a table. <?php
class Post extends AppModel
{
/*var $name='User';*/
}
?>

<?php
class PostsController extends AppController
{
public $helpers=array('Html','Form');

public function index()
{
$this->set('posts',$this->Post->find('all'));
}

public function home()
{
$this->set('posts',$this->Post->find('all'));
}
}
?>

view
///
..
<?php foreach ($posts as $item):
echo '<tr><td>'. $item['Post']['id']. '</td>';
echo '<td>'. $item['Post']['title'].'</td>';
echo '<td>'. $item['Post']['body'].'</td>';

echo '<td>'. $item['Post']['created'] .'</td>';
echo '</tr>';
endforeach;
unset($item);
?>

Blank Page Out Of Nowhere

Similar Tutorials

Hello (I am posting to php because I don't know what is giving the problem),

Let's say I have these links into my <div id="header>:
Home Items Faq Cart and I use a Jquery to open my links inside my <div id="content">

The problem is between Items and Cart links (I am testing in ie9 and firefox 4):

I am using an ajax code (I don't know if the problem is in here) to add items to cart and stay at my items page (not sending me to the cart page).

Now, when I first load the page or is refreshed, everything works fine. BUT after I add something to the Cart if I visit the Cart.php and then return to my Items.php, when I click on the next item to be added I get a Blank page. Note: the Item is added normaly.

This is happening also, when I click the UPDATE button inside my cart php to update quantities. Any suggestion?

Thank you.
(I don't know if is ajax, php, jquery or all three of them)

Getting A Blank Page :(

Similar Tutorials

heres my PHP:
i cant find the problem
            <?php
$dbhost  = 'localhost';
$dbname  = 'games';
$dbuser  = 'webuser';
$dbpass  = 'MY PASSWORD IS HIDDEN :P';

$connect = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

if (isset($_GET['cat'])){
  $cat = $_GET['cat'];
  $get_games = mysql_query("SELECT * FROM games WHERE category = '$cat'");
  $get_games_rows = mysql_num_rows($get_games);
  if ($get_games_rows>=1){
    while ($fetch = mysql_fetch_assoc($get_games)){
        $id = $fetch['id'];
        $title = $fetch['title'];
$thumb = $fetch['thumb'];

$string4= '<div class='gamelisting'>';
$string4= '<a href='play.php?id=".$id."'>';
$string4= '<img src='thumbs/".$thumb."' width='80' height='60' alt='' /><br />';
$string4= '".$title."</a></div>';

<?php echo $string1.$string2.$string3.$string4; ?>


    }
  }


}
else
     echo "Category does not exist";

?>

Target=blank?

Similar Tutorials

How can I make this link have a target blank suited for a Strict doctype.

if (strpos($row['personalweb'], 'http://') === false && strpos($row['personalweb'], 'https://') === false)
{
$row['personalweb'] = "http://${row['personalweb']}";
}

Blank At Random

Similar Tutorials

Okay, minor issue, but not sure how to resolve. I have a form that processes through PHP and has it's fields validated with JS and sends the data to an e-mail address and a database. It works fine, but there are random times where a submitted entry will show up blank in the e-mail and not be in the database at all, any ideas on what might be causing this? Thanks.

Blank Screen Of Death

Similar Tutorials

I have quite a lengthy php code that is bringing up the blank screen of death.
I've put error_reporting(E_ALL) at the top but nothing.

I can't see obvious errors while looking through the code and can't print it here as it's very long and uses a few include files.

How else can I see what errors are occuring?

Putting A Blank Value Into Mysql?

Similar Tutorials

<?php
$PostID = mysql_escape_string($_GET['postid']);
?>
<?php
If ($_GET['CODE'] == '0') {
    $GetPostData = "SELECT * FROM ".FORUM_POSTS." WHERE post_id='{$PostID}'";
    $GetPostRes = mysql_query($GetPostData, $db);
    $PostText = mysql_result($GetPostRes, 0, 'post_text');
    $AuthorID = mysql_result($GetPostRes, 0, 'user_id');

    If ($memid == $AuthorID || $MemLevel >= 1000) {
?>
<div class="maintitle" align="left"><img src="./images/nav_m.gif" width="8" height="8"> Editing Post</div>
<form action="index.php?act=edit&postid=<?php echo $PostID; ?>&CODE=1" method="POST">
<table width="100%" cellspacing="1" cellpadding="4">
    <tr>
        <td class="titlemedium" colspan="2">Make changes below.</td>
    </tr>
    <tr>
        <td class="row2" align="right" width="15%" valign="top">Post Text:</td>
        <td class="row2" align="left" width="85%">
            <textarea cols="80" rows="20" name="posttext"><?php echo $PostText; ?></textarea>
        </td>
    </tr>
    <tr><td class="row2" colspan="2" align="center"><input type="submit" value="Post" /></td></tr>
</table>
</form>
<?php
}
Else {
?>
<div class="maintitle" align="left"><img src="./images/nav_m.gif" width="8" height="8"> Error</div>
<table width="100%" cellspacing="1" cellpadding="4">
    <tr><td class="row2">You do not have the permission to edit this post.<br>If you believe this is an error please contact an administrator.</td></tr>
</table>
<?php
}
}
If ($_GET['CODE'] == '1') {
    //Gather Information
    $PostText = mysql_escape_string($_POST['posttext']);
    $PostText = htmlentities($PostText);
    $PostID = mysql_escape_string($_GET['postid']);

    //Update Database
    $EditQry = "UPDATE ".FORUM_POSTS." SET post_text='{$PostText}' WHERE post_id='{$PostID}'";
    $EditRes = mysql_query($EditQry, $db);
    //Check Data went in
    If (!$EditRes) {
?>
<div class="maintitle" align="left"><img src="./images/nav_m.gif" width="8" height="8"> Error</div>
<table width="100%" cellspacing="1" cellpadding="4">
    <tr><td class="row2">Could not modify database. Please contact administrator.</td></tr>
</table>
<?php
    }
    Else {
?>
<div class="maintitle" align="left"><img src="./images/nav_m.gif" width="8" height="8"> Success</div>
<table width="100%" cellspacing="1" cellpadding="4">
    <tr><td class="row2">Post modified. Please go back to the thread to see it.</td></tr>
</table>
<?php
    }
}
?>
</div>

This is my page for editing a post.

However, whenever this form actually goes through, the query for some reason makes post_text in the database blank with no text in it whatsoever.

I have tried echoing the query to see what it says and it has a perfectly fine query and I can copy/paste it manually to put it into the mysql but I don't get why this isn't adding it.

$_get Always Returns Blank

Similar Tutorials

When you do a search at (right sidebar):
http://ourneighborhooddirectory.org
the $_GET result is always blank. The site is hosted at Bluehost and this is a Wordpress site. You can see the result of the query because I write them out. Here is the form code:
Code: [Select]
<form method="get" action="http://ourneighborhooddirectory.org/search-results/" >
Search the Directory:
<input type="text" name="srch"/>
<input type="submit" value="Search" />
</form>
Here is the PHP code on the action page:
<?php
$srchVal = $_GET["srch"];
echo $_GET['srch'];
echo "------------ ". $srchVal." ------------";
print_r($_GET);
echo $_SERVER['QUERY_STRING'];
?>

Any ideas on why $_POST and $_GET always return blank?

Thanks for the help...

Please Help Form Just Showing Blank

Similar Tutorials

Hi People.

Does anyone have any idea why this form is showing as a blank page on my site? Can you see what I've missed?

Code: [Select]
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Stranded Flyer</title>
</head>

<body>

<?php

$host = 'localhost';
$usr = "the_user";
$password = 'thepassword';
$db_name = 'thedbname';

//connect to database
mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error());
mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error());

$surname = mysql_real_escape_string($_POST['surname']);
$firstname = mysql_real_escape_string($_POST['firstname']);
$phone1 = mysql_real_escape_string($_POST['phone1']);
$phone2 = mysql_real_escape_string($_POST['phone2']);
$location = mysql_real_escape_string($_POST['location']);
$qualifications = mysql_real_escape_string($_POST['qualifications']);
$expertise = mysql_real_escape_string($_POST['expertise']);
$assistance = mysql_real_escape_string($_POST['assistance']);
$languages = mysql_real_escape_string($_POST['languages']);
$e-mail = mysql_real_escape_string($_POST['e-mail']);
$consent = mysql_real_escape_string($_POST['consent']);
$published = mysql_real_escape_string($_POST['published']);
$comments = mysql_real_escape_string($_POST['comments']);
$other_info = mysql_real_escape_string($_POST['other_info']);

$errorstring = ""; // default value of errorstring

function makeSafe($value)
{
    if (get_magic_quotes_gpc())
    {
        $value = stripslashes($value);
    }

    $value = mysql_real_escape_string($value);

    return $value;
}

if(isset($_POST['submit'])) {
// Validate all the code inputs

// Captcha Validation

require_once('recaptchalib.php');
$privatekey = "6Ld2xscSAAAAADwh3mCFkTObSHLAEKUAcU3ocpSv";
$resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

if (!$resp->is_valid) {
    // What happens when the CAPTCHA was entered incorrectly
    $errorstring = $errorstring. "Invalid CAPTCHA, please try again";
  } else {

if ($surname =="")
$errorstring = $errorstring. "Surname<br>";
if ($phone1 =="")
$errorstring = $errorstring. "phone1<br>";
if ($phone2 =="")
$errorstring = $errorstring. "phone2<br>";
if ($location =="")
$errorstring = $errorstring. "location<br>";
if ($qualifications =="")
$errorstring = $errorstring. "qualifications<br>";
if ($assistance =="")
$errorstring = $errorstring. "assistance<br>";
if ($languages =="")
$errorstring = $errorstring. "languages<br>";
if ($e-mail =="")
$errorstring = $errorstring. "e-mail<br>";
if ($consent =="")
$errorstring = $errorstring. "consent<br>";
if ($published =="")
$errorstring = $errorstring. "published<br>";
if ($comments =="")
$errorstring = $errorstring. "comments<br>";
if ($other_info =="")
$errorstring = $errorstring. "other info<br>";

// does the errorstring = "nothing"?

}
// Figure out which error message to show i.e. field validation or CAPTCHA
if ($errorstring !="")
   if (strstr($errorstring,"CAPTCHA")) echo $errorstring;
  else echo "You have not put anything in the following fields: <br><br> $errorstring";
//echo "If you have nothing to put in the box please type the word \"None\" or \"N\/A\"";
//die ("Please try again, ensuring that you fill out all the fields!");
else
{

//echo "Your data has been saved";

$insert_query = "INSERT INTO HelperFormData (surname, firstname,phone1, phone2, location, qualifications, expertise, assistance, languages, e-mail, consent, published, comments, other_info,) VALUES ('$surname', '$firstname', '$phone1','$phone2', '$location', '$qualifications', '$expertise', '$assistance', '$languages', '$e-mail', '$consent', '$published', '$comments', '$other_info')";
$insert_action = mysql_query($insert_query) or die ('Error During Insert :<br>'.mysql_error().'<br><br>Error occured running the following code :<br>'.$insert_query);

$id = mysql_insert_id();

echo "Thank you, Your details have been submitted.";
//include "resultcard.php";

// Output what the form looks like

// End of how the form looks

}
}

if(!isset($_POST['submit']) || (isset($_POST['submit']) && !empty($errorstring)))
{
?>

<form name = "form1" method ="post" action="">
<table width="700" border="0" cellspacing="5" cellpadding="5" bgcolor = "#dddddd">
<caption>
Submit Your Details
</caption>
<tr>
<td width = "50"> </td>
<td width = "240"> </td>
<td width = "250"> </td>
<td width = "160"><b>Example Input</b></td>
</tr>

<tr>
<td> </td>
<td>Surname</td>
<td><input type='text' name='surname' size = '40' maxlength='30' value = '<?php echo $surname; ?>'></td>
<td>Smith</td>
</tr>

<tr>
<td> </td>
<td>First Name</td>
<td><input type='text' name='firstname' size = '40' maxlength='30' value = '<?php echo $firstname; ?>'></td>
<td>Bill</td>
</tr>

<tr>
<td> </td>
<td>Phone 1</td>
<td><input type='text' name='phone1' size = '40' maxlength='30' value = '<?php echo $phone1; ?>'></td>
<td>07777 777777</td>
</tr>

<tr>
<td> </td>
<td>Phone 2</td>
<td><input type='text' name='phone2' size = '40' maxlength= '30'value = '<?php echo $phone2; ?>'></td>
<td>0118 123 4567</td>
</tr>
<tr>
<td> </td>
<td>Location</td>
<td><input type='text' name='location' size = '40' maxlength='40'value = '<?php echo $location; ?>'></td>
<td>52.289071,-1.952004</td>
</tr>
<tr>
<td> </td>
<td>Qualifications</td>
<td><input type='text' name='qualifications' size = '40' maxlength='30' value = '<?php echo $qualifications; ?>'></td>
<td>Electrician</td>
</tr>
<tr>
<td> </td>
<td>Expertise</td>
<td><input type='text' name='qualifications' size = '40' maxlength='30' value = '<?php echo $expertise; ?>'></td>
<td>Flexwings</td>
</tr>
<tr>
<td> </td>
<td>Assistance Offered</td>
<td><input type='text' name='assistance' size = '40' maxlength='50' value = '<?php echo $assistance; ?>' /></td>
<td>Trailer and Tow Car</td>
</tr>
<tr>
<td> </td>
<td>Language Skills</td>
<td><input type='text' name='published' size = '40' maxlength='50' value = '<?php echo $language; ?>' /></td>
<td><p>English / Spanish</p></td>
</tr>
<tr>
<td> </td>
<td>E-Mail</td>
<td><input type='text' name='comments' size = '40' maxlength='50' value = '<?php echo $e-mail; ?>' /></td>
<td><p>example@mail.net</p></td>
</tr>
<tr>
<td> </td>
<td>Consent</td>
<td>
<select name = "surface">
<option value = "Yes" <?php if ($_POST['consent'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option>
<option value = "No" <?php if ($_POST['consent'] == 'No') { echo 'selected="selected"'; } ?>>No</option>

</select>

</td>
<td>Yes</td>
</tr>
<tr>
<td> </td>
<td>Published</td>
<td>

<select name = "food">
<option value = "Yes" <?php if ($_POST['published'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option>
<option value = "No" <?php if ($_POST['published'] == 'No') { echo 'selected="selected"'; } ?>>No</option>
</select>

</td>
<td>Yes</td>
</tr>
<tr>
<td> </td>
<td>Comments</td>
<td><textarea name= "remarks" input type = 'text' rows = "5" cols = "29" /><?php echo $remarks; ?></textarea></td>
<td>As much info as possible 500 characters max</td>
</tr>
<tr>
<td> </td>
<td>Other Info</td>
<td><textarea name= "warnings" input="input" type = 'text' rows = "5" cols = "29" /><?php echo $warnings; ?></textarea></td>
<td>As much info as possible 500 characters max</td>
</tr>
<tr>
<td> </td>
<td><input type='submit' name='submit' value='Submit Your Info' /></td>
<td colspan="2">
<? require_once('recaptchalib.php');
$publickey = "6Ld2xscSAAAAAH3_KiJoRLR4sEWFFQR4yAr5F1xi"; // you got this from the signup page
echo recaptcha_get_html($publickey);?></td>
</tr>
</table>
</form>

</body>
</html>
<?php } ?>

Mysql Updating Row To Blank Value

Similar Tutorials

Hey guys, I have a private message script but for some reason when its updating, it turns the value into a blank one from 1 to 3.

I have no idea why, but it works with the old statement of deleting, but I changed it to instead update it to 3 because I want to keep the pm in archives.

here is the delete PM part.

<?php
session_start();
header("Location:inbox.php");

$user = $_SESSION['username'];

include 'db.php';

//We do not have a user check on this page, because it seems silly to, you just send data to this page then it directs you right back to inbox

//We need to get the total number of private messages the user has
$sql = mysql_query ("SELECT pm_count FROM users WHERE username='$user'");
$row = mysql_fetch_array ($sql);
$pm_count = $row['pm_count'];

//A foreach loop for each pm in the array, get the values and set it as $pm_id because they were the ones selected for deletion
foreach($_POST['pms'] as $num => $pm_id)
    {
    //Delete the PM from the database
     mysql_query("UPDATE messages SET recieved='3' WHERE id='$pm_id' AND reciever='$user'");

    // mysql_query("DELETE FROM messages WHERE id='$pm_id' AND reciever='$user'");

    //Subtract a private message from the counter! YAY!
    //$pm_count = $pm_count - '1';

    //Now update the users message count with the new value
    //mysql_query("UPDATE users SET pm_count='$pm_count' WHERE username='$user'");
    }
?>

The commented out part at the end, is the old deleting parts but instead changed it to update value.

Here is my form that shows checkboxes.
I showed the whole code, where it has comments.

<?php
    //This stuff and the while loop will query the database, see if you have messages or not, and display them if you do
    $query = "SELECT id, sender, subject, message FROM messages WHERE reciever='$user' AND recieved='1'";
    $sqlinbox = mysql_query($query);


    //We have a mysql error, we should probably let somone know about the error, so we should print the error
    if(!$sqlinbox)
        {
        ?>
        <p><?php print '$query: '.$query.mysql_error();?></p>
        <?php
        }

    //There are no rows found for the user that is logged in, so that either means they have no messages or something broke, lets assume them they have no messages
    elseif (!mysql_num_rows($sqlinbox) )
        {
        ?>
        <center><p><b>You havent read any messages</b></p></center>
        <?php
        }

    //There are no errors, and they do have messages, lets query the database and get the information after we make a table to put the information into
    else
        {
        //Ok, Lets center this whole table Im going to make just because I like it like that
        //Then we create a table 80% the total width, with 3 columns, The subject is 75% of the whole table, the sender is 120 pixels (should be plenty) and the select checkboxes only get 25 pixels
        ?>
        <center>
        <form name="send" method="post" action="delete.php">
        <table width="80%">
        <tr>
          <td width="75%" valign="top"><p><b><u>Subject</u></b></p></td>
          <td width="120px" valign="top"><p><b><u>Sender</u></b></p></td>
          <td width="25px" valign="top"><p><b><u>Select</u></b></p></td>
        </tr>
        <?php
        //Since everything is good so far and we earlier did a query to get all the message information we need to display the information.
        //This while loop goes through the array outputting all of the message information
        while($inbox = mysql_fetch_array($sqlinbox))
            {
            //These are the variables we get from the array as it is going through the messages, we have the id of the private message, we have the person who sent the message, we have the subject of the message, and yeah thats it
            $pm_id = $inbox['id'];
            $sender = $inbox['sender'];
            $subject = $inbox['subject'];

            //So lets show the subject and make that a link to the view message page, we will send the message id through the URL to the view message page so the message can be displayed
            //And also let the person see who sent it to them, if you want you can make that some sort of a link to view more stuff about the user, but Im not doing that here, I did it for my game though, similar to the viewmsg.php page but a different page, and with the senders id
            //And finally the checkboxes that are all stuck into an array and if they are selected we stick the private message id into the array
            //I will only let my users have a maximum of 50 messages, remeber that ok? Because that's the value I will later in another page
            //Here is finally the html output for the message data, the while loop keeps going untill it runs out of messages
            ?>
            <tr>
              <td width="75%" valign="top"><p><a href="viewmsg.php?msg_id=<?php echo $pm_id; ?>"><?php echo $subject; ?></a></p></td>
              <td width="120px" valign="top"><p><?php echo $sender; ?></p></td>
              <td width="25px" valign="top"><input name="pms[]" type="checkbox" value="<?php echo $pm_id; ?>"></td>
            </tr>
            <?php
            //This ends the while loop
            }
        //Here is a submit button for the form that sends the delete page the message ids in an array
        ?>


        <tr>

        <td colspan="3"><input type="submit" name="Submit" value="Delete Selected"></td>
        <td></td>
        <td></td>




        </tr>




        </table>

        </center>
        <?php
        //So this ends the else to see if it is all ok and having messages or not
        }
?>

So yeah, does anyone know why it updates it to a blank value, from the value 1 in recieved?

Blank Row Being Inserted In Top Of Mysql.

Similar Tutorials

Shouldn't the following stop a blank row from being inserted into mysql?
I have a description and a date but it still keeps putting a blank row before my insert and I've tried everything....

if($myvar != ''){
mysql_query("INSERT IGNORE INTO products (description, time) VALUES('$myvar',NOW() ) ")
or die(mysql_error());

Getting A Blank White Screen...

Similar Tutorials

Okay, I can't seem to figure out why the form isn't pulling up.

Here's what I'm trying to do.

Administrator clicks on Add New Item to Inventory, pulling up the shops that are available to add inventory to. (This part appears to be working, because it does list those shops available).

Then, the administrator will click on a shop name, opening up a form that will allow them to type in the name of the item they want to add. Instead, it goes to a blank screen, no errors even with error reporting on.

adminpanel.php is the main file that houses all these functions. If you're familiar with EZRPG, it's the same basic setup, just with these additions to the list.

Any help would be greatly appreciated! Thank you!!

function addinv() {
    $query = doquery("SELECT id,name FROM shop ORDER BY name", "shop");
    $page = "<b><u>Add Inventory</u></b><br />Click to add an item to a shop's inventory.<br /><br /><table width=\"50%\">\n";
    $count = 1;
    while ($row = mysql_fetch_array($query)) {
        if ($count == 1) { $page .= "<tr><td width=\"8%\" style=\"background-color: #eeeeee;\">".$row["id"]."</td><td style=\"background-color: #eeeeee;\"><a href=\"admin_panel.php?do=addshopinv:".$row["id"]."\">".$row["name"]."</a></td></tr>\n"; $count = 2; }
        else { $page .= "<tr><td width=\"8%\" style=\"background-color: #ffffff;\">".$row["id"]."</td><td style=\"background-color: #ffffff;\"><a href=\"admin_panel.php?do=addshopinv:".$row["id"]."\">".$row["name"]."</a></td></tr>\n"; $count = 1; }
    }
    if (mysql_num_rows($query) == 0) { $page .= "<tr><td width=\"8%\" style=\"background-color: #eeeeee;\">No items found.</td></tr>\n"; }
    $page .= "</table>";
    admindisplay($page, "Add Shop Inventory");

}

function addshopinv($name) {

   if (isset($_POST["submit"])) {

        extract($_POST);
        $errors = 0;
        $errorlist = "";
        if ($name == "") { $errors++; $errorlist .= "Name is required.<br />"; }
else if ($errors == 0) {
$query1 = doquery("SELECT * FROM items WHERE name=$name");
$item_id = mysql_fetch_array($query1);
$query = doquery("INSERT INTO `sale` SET shop_id=".$row["id"].", item_id='$item_id',");
            admindisplay("Inventory Item Added.","Add New Inventory Item");
        } else {
            admindisplay("<b>Errors:</b><br /><div style=\"color:red;\">$errorlist</div><br />Please go back and try again.", "Add New Item to Shop");
        }
   }

   $name =

$page = <<<END
<b><u>Add New Inventory Item</u></b><br /><br />
<form action="admin_panel.php?do=addshopinv:$name" method="post">
<table width="90%">
<tr><td width="20%">Name:</td><td><input type="text" name="name" size="30" maxlength="255" value="" />*255 character max</td></tr>
</table>
<input type="submit" name="submit" value="Submit" /> <input type="reset" name="reset" value="Reset" />
</form>
END;

    $page = parsetemplate($page, $row);
    admindisplay($page, "Add New Inventory Item");

}

Updating A Field To A Blank

Similar Tutorials

I must be using the wrong search terms in google cause I cant find out how to update a field to a blank spot.

trying to make name blank. I thought it was just " "
hope someone can please help me with this

Code: [Select]
mysql_query("UPDATE users SET name = '".mysql_real_escape_string "."' WHERE id = '".mysql_real_escape_string($_SESSION['user_id']))."'";