PHP - Weird Issue.

There's probably an obvious reason but I can't seem to find it...

I start with the $_POST array, received from a form:
Code: [Select]
array(9) {
  ["Name"]=>
  string(3) "KTN"
  ["SQLServer"]=>
  string(24) "10.6.11.20\VSQLI028,1433"
  ["Username"]=>
  string(2) "GF"
  ["Password"]=>
  string(2) "GF"
  ["MasterDB"]=>
  string(11) "GFMaster_KN"
  ["Version"]=>
  string(3) "4.9"
  ["Prod"]=>
  string(1) "1"
  ["Monitored"]=>
  string(1) "0"
  ["button"]=>
  string(38) "updateColumnName=EnvironmentID;Value=1"
}
I get the button value from the array, and unset the button array value.
Code: [Select]
function load_POST($name) { //returns value and removes it from $_POST array. returns NULL if not existing.
  $debug = 0;
  if ( $debug == 1 ) {
    $backtrace = backtrace();
    echo __FUNCTION__."()";
    echo " <i>called by ".basename($backtrace[1]['file'])."</i><br/>\n";
  }
  $post = NULL;
  if( array_key_exists($name, $_POST) ) {
    $post = urldecode($_POST[$name]);
    if ( $debug == 1 ) {
      echo "post $name, value: $post<br/>\n";
    }
  } else {
    if ( $debug == 1 ) {
      echo "post $name: doesn't exist<br/>\n";
    }
  }
  unset($_POST[$name]);
  return $post;
}
$_POST is now:
Code: [Select]
array(8) {
  ["Name"]=>
  string(3) "KTN"
  ["SQLServer"]=>
  string(24) "10.6.11.20\VSQLI028,1433"
  ["Username"]=>
  string(2) "GF"
  ["Password"]=>
  string(2) "GF"
  ["MasterDB"]=>
  string(11) "GFMaster_KN"
  ["Version"]=>
  string(3) "4.9"
  ["Prod"]=>
  string(1) "1"
  ["Monitored"]=>
  string(1) "0"
}
Then I create the object to assign the values to:
Code: [Select]
object(Environment)#1 (9) {
  ["EnvironmentID"]=>
  NULL
  ["Name"]=>
  NULL
  ["SQLServer"]=>
  NULL
  ["Username"]=>
  NULL
  ["Password"]=>
  NULL
  ["MasterDB"]=>
  NULL
  ["Version"]=>
  NULL
  ["Prod"]=>
  int(0)
  ["Monitored"]=>
  int(0)
}
So far so good 
Then, for each remaining $_POST value, I update the Object accordingly:
First one, parametername: Name, parameter: KTN
Code: [Select]
object(Environment)#1 (10) {
  ["EnvironmentID"]=>
  NULL
  ["Name"]=>
  string(3) "KTN"
  ["SQLServer"]=>
  NULL
  ["Username"]=>
  NULL
  ["Password"]=>
  NULL
  ["MasterDB"]=>
  NULL
  ["Version"]=>
  NULL
  ["Prod"]=>
  int(0)
  ["Monitored"]=>
  int(0)
  ["ColumnName=EnvironmentID;Value=1"]=>
  object(stdClass)#3 (1) {
    ["ColumnName"]=>
    string(1) "1"
  }
}
And there we have the problem, for some reason the button value is added to the object somehow... Any ideas?
Thanks in advance!

Dear all,

I updated my versions of php/MySQL and OS to Windows 7 Professional and weird "Warnings and Notices:" started popping up. E.g.

Code: [Select]
"Notice: Undefined index: page in C:\Server\htdocs\domain\index.php on line 25 "
Code: [Select]
Warning: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'America/New_York' for '-4.0/DST' instead in C:\Server\htdocs\domain\index.php on line 12 "
I don't know what is going on. Unless I enter these following functions (error_reporting(0);, session_start() with their parameters these warnings display. Can anyone offer any advice?

Any assistance is appreciated.

 

this works
Code: [Select]
<form action="" method="post">
<input name="DepartureDate" type="text">
<input name="" type="submit"></form>
<?php
$DepartureDate=$_POST['DepartureDate'];

 echo  $DepartureDate = stripslashes($DepartureDate); // sql inject clean
$regex = "/^[a-z]+$/";
if (!preg_match($regex, $DepartureDate)){
echo 'CAPS BABY!';}
else
{echo 'OK!';}
?>

this doesnt
Code: [Select]
if (!preg_match($regex, $DepartureDate)) {
    mail($to, $subject, $message, $headers);

echo $url_success = "confirmation.php";
//echo("<meta http-equiv = refresh content=0;url=".$url_success.">");
   }
 
  else {
 

exit();



  }

Okay, so basically my news-like site is supposed to print out article data saved in the database.  It does that quite alright, except on the 3rd article (number 2 in SQL rows or columns.  whichever it is.   I have my counter subtract 1 from the start article to compensate for MySQL)

My code:
Code: [Select]
<?php
print "<div class = 'menu' align='center'>Newest Stories</div>";

if (isset($_REQUEST['mstart']))
{
$start=$_REQUEST['mstart'];
}
else
{
$start=1;
}
if ($start)
{
$start=1;
}

$start--;
$end=$start+5;
$stories = mysql_query("SELECT * FROM stories ORDER BY id DESC LIMIT $start, $end") or die(mysql_error());
$num = mysql_num_rows($stories);
$start++;

if ($num > 0)
{
if ($num<$end)
{
  $end = $end-(5-$num);
}
print "<b><i>Showing stories $start to $end</i></b>";



for ($count=0; $count<$num; $count++)
{
print "<hr>";
$story = mysql_fetch_array($stories,$count);
$id = $story['id'];
$headline = $story['headline'];
$author = $story['author'];
$desc = $story['description'];
$content = $story['content'];

print "COUNT: $count OF $num ($id)<br>";
print "<a href='index.php?request=story&mstart=$start&story=$id' class='headlinelink'>$headline</a><br>";
print "<div class='author'>Posted by: <a href='index.php?request=author&mstart=$start&author=$author' class='author'>$author</a>.</div>";
print "<div class='desc'>$desc</div><br>";
}

}
else
{
print "Error.  No stories found. :(";
}

?>

Output: (The COUNT x OF y was to help me figure out what is wrong.  In the () by it is the id number of the corresponding MySQL row/column.  I even deleted one of the articles to see if it was a specific article error.  No luck.)

Quote

Newest Stories
Showing stories 1 to 5
----------------
COUNT: 0 OF 5 (6)
Y U NO STAY
Posted by: craigory83.
GRRR

----------------
COUNT: 1 OF 5 (5)
h-l!
Posted by: craigory83.
desc

----------------
Notice: Undefined index: id in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\dba\menu.php on line 37

Notice: Undefined index: headline in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\dba\menu.php on line 38

Notice: Undefined index: author in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\dba\menu.php on line 39

Notice: Undefined index: description in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\dba\menu.php on line 40

Notice: Undefined index: content in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\dba\menu.php on line 41
COUNT: 2 OF 5 ()

Posted by: .

----------------
COUNT: 3 OF 5 (2)
This is the second story!
Posted by: TDWP83.
See, I fuckin told you so!


Warning: mysql_fetch_array() [function.mysql-fetch-array]: The result type should be either MYSQL_NUM, MYSQL_ASSOC or MYSQL_BOTH in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\dba\menu.php on line 36

----------------
COUNT: 4 OF 5 (1)
This is the mother fucking headline!
Posted by: craigory83.
stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff stuff

I have a development machine running WAMP on a win7 64 bit box. php 5.3.13 I have a server that runs Apache 2.2, php 5.3.12 MySql, etc.   I am running joomla 2.5.27 on both machines. I require a number of php includes to many of the joomla articles (this works great via a plugin called Directphp)   After considerable time getting the site fully working on the dev machine, I ran into an unforseen problem when I uploaded to the production box. For some unknown reason, the includes work fine on the dev machine using $DOCUMENT_ROOT to define the root (then tag the correct path and file to this) However, on the production box, this doesn't work - but...  $_SERVER['DOCUMENT_ROOT'] does.   Annoyingly, $_SERVER['DOCUMENT_ROOT'] won't work on the dev machine - and $DOCUMENT_ROOT doesn't work on the production box.   So, I can't come up with a generic method to keep both machines happy. I've checked the php.ini files on both boxes and the register global is OFF on both.   They also seem to interperate the syntax differently in the actual include files - one box hates double quotes - the other has issues with single quotes. This is really annoying as most of the includes are HTML snippets, coded into php. The double/single quote problem means I would need to have two versions of the include files.   Can anyone help me with this? - serious hair pulling has started!