PHP - Error Reporting Problem

hey all, I've finally took a leap towards the brighter side of coding.. and Ive started to convert my code from php to opp pdo ect.. However the errors Ive been through my cms's and well anything to do with inserting into a database is rather confusing.. ERRORS such as invalid parameter number,.   What does this mean?   Here's the code that im getting the error from:

<?php

	//if form has been submitted process it
	if(isset($_POST['submit'])){

		$_POST = array_map( 'stripslashes', $_POST );

		//collect form data
		extract($_POST);

		//very basic validation
		if($title ==''){
			$error[] = 'Please enter the title.';
		}

		if($short_desc ==''){
			$error[] = 'Please enter a short description.';
		}
		if($full_desc ==''){
			$error[] = 'Please enter a full description.';
		}

		if(!isset($error)){

			try {

				//insert into database
				$stmt = $handler->prepare('INSERT INTO calendar_event (title,short_desc,full_desc,date) VALUES (:title, :short_desc, :full_desc, :date)') ;
				$stmt->execute(array(
					':title' => $title,
					':short_desc' => $short_desc,
					':ful_desc' => $full_desc,
					':date' => date('Y-m-d')
				));

				//redirect to index page
				header('Location: index.php?action=added');
				exit;

			} catch(PDOException $e) {
			    echo $e->getMessage();
			}

		}

	}

	//check for any errors
	if(isset($error)){
		foreach($error as $error){
			echo '<p class="error">'.$error.'</p>';
		}
	}
	?>

	<form action='' method='post'>
	<table class="admin_table_defaults">
	<tr>
		<th width="10px">Title</th>
		<th width="200px">Date</th>
		<th width="200px">&#32;</th>
		<th></th>
	</tr>
	<tr>
		<td><input type='text' name='title' value='<?php if(isset($error)){ echo $_POST['title'];}?>'></td>
		<td><input type='date' name='date' value='<?php if(isset($error)){ echo $_POST['date'];}?>'></td>
		<td><td>
	</tr>
	</table>
	<table class="admin_table_defaults">
	<tr>
		<th style="text-align:left;"> Short Description <span class="small_text">  : NB - Please avoid using images, align properties, stick to text format. <br/><b style="background:#fff;font-size:14px;">Note : There's a character max of 100 characters for this field</b></span></th>
	</tr>
	<tr>
		<td><textarea name='short_desc' cols='60' rows='10' ><?php if(isset($error)){ echo $_POST['short_desc'];}?></textarea></td>
	</tr>
	<tr>
	</table>
	<table class="admin_table_defaults">
	<tr>
		<th style="text-align:left;"> Full Description: <span class="small_text"></th>
	</tr>
	<tr>
		<td><textarea name='full_desc' cols='60' rows='10'><?php if(isset($error)){ echo $_POST['full_desc'];}?></textarea></td>
	</tr>
	<tr>
		<td><input class="admin_submit_btn"type='submit' name='submit' value='Submit'></td>
	</tr>
	<tr>
	</table>
	</tr>
	</table>

	</form>

Any help will be greatly appreciated    Thanks in advance..       

Hello everyone,

I have a messaging site where I have an email generated every night to report new activity on my site.  The way it is currently set up, I have each message reply attached to the previous message, such as quoting the original text in an email message.  Each string of messages in my database has one common field ("string"), but each new reply has a different message ID field in the database ("messid").  When each new message and reply is created the "reported" field in my database has a default value of n, meaning that it has not been reported yet.  At the end of the day, when the email is generated, the reported field is then updated to y, meaning that it HAS been reported.  The problem that I'm having now, is that I'm getting several of the same messages in every report.

I am using the following code to select each unreported message from the database to generate my report:

Code: [Select]
<?php
$result = mysql_query("SELECT `to`,`studentname`,`staffname`,`subject`,`message`,`date` FROM caresa6_$acct.allmsgs WHERE reported = 'n' ORDER BY `messid` ASC") or die (mysql_error());
?>
Basically, I need to know how to select only the most recent unreported message within each string of messages.

For example, now if there is a new message:

"Hello there."

Then a reply from the recipient:

"Hi! How are you?"

Then another reply from the original sender:

"I am fine."

My report will look like this:

___________
New Message:

"Hello there."
------------------
Reply: "Hi! How are you?"
------------------
Reply: "I am fine."
------------------

___________
New Message:

"Hello there."
------------------
Reply: "Hi! How are you?"
------------------

___________
New Message:

"Hello there."
------------------

So I am getting carbon copies of every new message every time someone replies.

I want to only select the most recent message so that my report only reads:

___________
New Message:

"Hello there."
------------------
Reply: "Hi! How are you?"
------------------
Reply: "I am fine."
------------------

Thanks in advance.

Hi ,

 Presently we are preparing an excel for download report by querying to data base.
 We are querying to DB and looping through each result row and writing to excel.
for 2lacs data its  too much time.

I found the time taken max in DB query and processing the DB data .
Ant way I can make it faster ?

Any parallel processing I can apply to get it faster......I expecting Huge data report in future.

My form Code: [Select]

<form action="process.php" method="post">
<font face= "calibri" size= "4">
<table border= "1">

<tr style= "background: #cccccc">  <td><b>Item Description:</b></td>
<td><input type= "text" name= "itemDescription" size= "30" value=""/></td>
</tr>
<tr style= "background: #99ff00">   <td><b>Item Price:</b></td>
<td><input type= "text" name= "itemPrice" size= "5" value=""/></td>
</tr>
</tr style= "background: #A8E5FF">   <td><b>Winning Bidders:</b></td>
<td><input type="text" name= "winningBidder" size= "5" />
</td>
</tr>
<tr>   <td><b>How many deals?:</b></td>
<td><input type="text" name= "itemQty" size= "3" value= "1" /></td>
</tr>
</table>
<br/>
<input type="reset" value="Reset Form"><input type="submit" name="submit" value= "Save & Cont."
" />


</form></font>



My process script:
Code: [Select]
<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);

$host= "";
$db_name= "";
$db_user= "";
$db_password= "";


$logUser= $_POST['logUser'];
$deleteBidder = $_POST['deleteBidder'];
$newBidder= $_POST['newBidder'];
$itemDescription= $_POST['itemDescription'];
$itemPrice= $_POST['itemPrice'];
$winningBidder= $_POST['winningBidder'];
$itemQty= $_POST['itemQty'];
ob_start();

if ($_POST['newBidder']) {
$bidderId= $newBidder;

mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM bidders WHERE biddersId='$bidderId'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==0){
// Add $biddersId and redirect to anypage
mysql_Query("INSERT INTO bidders (biddersId)
VALUES ('$bidderId')");
 header("Location: index.php");
exit();
  }
}

if ($_POST['deleteBidder'])
{

mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_query("DELETE FROM bidders WHERE biddersId='$deleteBidder'");
 header("Location: index.php");
exit();
}

if ($_POST['itemDescription'] AND $_POST['itemPrice'] AND $_POST['winningBidder'] AND $_POST['itemQty'])
{


mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM transactions WHERE biddersId='$winningBidder'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);
// If result matched, table row must be 1 row

if($count==0){
echo "That Bidder Number is NOT logged in, ";
echo "would you like to set this bidder as active?";
echo " Enter 1 for NO or 2 for YES";
echo "<form action= \"process.php\" method= \"POST\">";
echo "<input type =\"text\" name= \"logUser\"/>";
echo "<input type= \"submit\" value = \"Submit\"/>";
$logUser= $_POST['logUser'];
exit();
}
if ($logUser= 1) {
header("Location: inprogress.php");
exit();
}

else if ($logUser= 2){
// Add $biddersId and redirect to anypage
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_Query("INSERT INTO bidders (biddersId)
VALUES ('$winningBidder')");
 

mysql_query("INSERT INTO transactions (itemDescription, itemPrice, bidderId, itemQty , totalPrice) 
 VALUES('$itemDescription', '$itemPrice','$winningBidder', '$itemQty', '$totalPrice')")
or die(mysql_error());  
$_SESSION['itemDescription']='$itemDescription'; 
header("Location: index.php");
exit();
   }
}

echo "<font color= \"red\" face=\"calibri\" size=\"4\">That bidder is already logged, Please press your browsers back button and try again.</font>";


ob_end_flush();

?>


DeleteBidder and newBidder are the only variables working?

Hi,   Can anyone recommend some Business Intelligence tools that can be integrated into a PHP (wordpress/joomla) based website?  I've had a good look around the net but they all seem to be written in Java/J2EE and appear to be software based - not sure if im after the possible or impossible here...   Thanks

I am trying to echo out an array from my data base.  I think I have my function created correctly: Noted below is the snippet from my transaction.class.php file

Code: [Select]

<?php

//Retreives data from the database  
public function retrieve_all_data($TransactionDate=0, $TransactionType=0, $TransactionAmount=0, $CurrentBalance=0){
$accounts_query = "SELECT TransactionDate, TransactionType, TransactionAmount, CurrentBalance FROM BankAccount, TransactionType, TransactionLog = " . $this->accountid ." LIMIT 0,30";
$result = mysqli_query($this->connection, $accounts_query);

return $result;
}
?>

I try to echo out using this format but I am not having any luck.

Code: [Select]
<?php 


/*Accounts*/
$currentMember->connection = $conn;
$accounts = $currentMember->retrieve_all_data();

/*Loop through account - Grabs data*/
while($account = mysqli_fetch_assoc($accounts)){
/*Retrieve Balance*/
$transaction = new Transaction($account['TransactionDate'], $account['TransactionType']);
$transaction->connection = $conn;
//$balance = mysqli_fetch_assoc($transaction->retrieve_current_balance());

echo '<tr>' . "\n";
echo "\t" . '<td>' . $account['TransactionDate'] . '</td>' . "\n";
echo "\t" . '<td>' . $account['TransactionType'] . '</td>' . "\n";
echo '<tr>' . "\n";


}
/*Close DB*/
mysqli_close($db->connection);

?>

My error happens on line #81

Code: [Select]
<?php
if (!isset($_POST['submit'])) {
?>
 <h2>Todays Special</h2>
<p>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<select name="day">
<option value="1">Monday/Wednesday
<option value="2">Tuesday/Thursday
<option value="3">Friday/Sunday
<option value="4">Saturday
</select>
input type="submit" name="submit" value="Go">
</form>
<?php
// get form selection
$day = $_POST['day'];
// check value and select appropriate item
switch ($day) {
    case 1:
        $special = 'Chicken in oyster sauce';
        break;
    case 2:
        $special = 'French onion soup';
        break;
    case 3:
        $special = 'Pork chops with mashed potatoes and green salad';
        break;
    default:
        $special = 'Fish and chips';
       break;
}
?>

As the title say, I can not for the life of me get the "$bank" content to display, no matter HOW much I try...
Does anyone see any errors. I am sooooooo wiped out at this!


main page

<?
$body = '

<script type="text/javascript" src="change-content.js"></script>

<div id="addSold">
<form action="'.$_SERVER['REQUEST_URI'].'" method="post" name="form" autocomplete="off">

<fieldset id="Vehicle">
<legend>Vehicle</legend>
<ul>
<li><label for="Year">Year</label>'.$Year.'</li>
<li><label for="Make">Make</label>'.$Make.'</li>
<li><label for="Model">Model</label>'.$Model.'</li>
<li><label for="Trim">Trim</label><input type="text" name="Trim" id="Trim" size="10" value="'.$trim.'" disabled="disabled"></li>
</ul>
<ul>
<li><label for="Mileage">Mileage</label><input type="text" name="Mileage" id="Mileage" size="5" maxlength="6" value="'.$row['mileage'].'"></li>
<li><label for="VIN">VIN</label><input type="text" name="VIN" id="VIN" size="23" maxlength="17" value="'.$row['vin'].'" disabled="disabled"></li>
<li><label for="Color">Color</label>'.$Exterior.'</li>
</ul>
</fieldset>

<fieldset id="Deal">
<legend>Deal</legend>
<ul>
<li>
<label for="soldDte1">Date</label>
<input type="text" name="soldDte1" id="soldDte1" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="08"> / 
<input type="text" name="soldDte2" id="soldDte2" size="1" maxlength="2" onkeyup="return autoTab(this, 2, event)" value="30"> / 
<input type="text" name="soldDte3" id="soldDte3" size="1" maxlength="2" value="'.$year.'">
<a href="#"><img id="date_'.$row[stock].'" src="images/Icons/dateOff.png" onfocus="this.select();lcs(this)" onmouseover="MM_swapImage(\'date_'.$row[stock].'\',\'\',\'images/Icons/dateOn.png\',1)" onmouseout="MM_swapImgRestore()" alt="Choose Date"></a>
</li>
<li>
<label for="salesman">Salesman</label> 
<select name="salesman" id="salesman">
<option></option>
'.$salesmen.'
</select>
</li>
</ul>
<ul>
<li>
<label for="dealType">Deal Type</label>
<select name="dealType" class="select-content" onchange="getFile(this.value)">
<option></option>
<option value="AL">Auto Loan</option>
<option value="Cash">Cash</option>
<option value="CAC">Credit Acceptance</option>
<option value="IH">In House</option>
<option value="SAL">Sensible Auto</option>
</select>
</li>
<li>
<label for="tradeDrop">Trade</label> 
<select name="tradein" id="tradeDrop" onchange="show_hide_trade(this.value);">
<option value="No">No</option>
<option value="Yes">Yes</option>
</select>
</li>
</ul>
</fieldset>

<div id="Bank" class="view">'.$bank.'</div>
</form>
</div>
';
?>


get_Bank.php

<?
if ($_GET['dealType'] == "AL") {
$bank = '
<fieldset id="AL">
<legend>Auto Loan Figures</legend>
<ul>
<li><label for="price">Price</label><input type="text" name="price" id="price" class="price" size="7" onchange="currency(this)"></li>
<li><label for="down">Down</label><input type="text" name="down" id="down" class="price" size="6" onchange="currency(this)"></li>
<li><label for="tax">Tax</label><input type="text" name="tax" id="tax" class="price" size="6" onchange="currency(this)"></li>
<li><label for="reg">Plates</label><input type="text" name="reg" id="reg" class="price" size="4" onchange="currency(this)"></li>
<li><label for="gap">Gap</label><input type="text" name="gap" id="gap" class="price" size="4" onchange="currency(this)"></li>
</ul>
<ul>
<li>
<label for="pymtNum">--------------- Payment ---------------</label>
<input type="text" name="pymtNum" id="pymtNum" size="3" maxlength="3" onkeyup="return autoTab(this, 3, event)"> @ 
<input type="text" name="pymtAmnt" id="pymtAmnt" class="price" size="5" onchange="currency(this)"> per 
<select name="pymtType">
<option value="Weekly" selected="selected">Week</option>
<option value="Monthly">Month</option>
</select>
</li>
<li><label for="APR">APR</label><input type="text" name="APR" id="APR" class="rate" size="6" value="19.00"></li>
</ul>
</fieldset>
';
} elseif ($_GET['dealType'] == "CAC") {
$bank = '
Credit Acceptance stuff goes here
';
} else {
$bank = 'You must choose a bank before continuing';
}

?>


change-content.js
Code: [Select]
window.onload = init;

// finds all <select> tags will class="select-content" and activates function
function init() {
var sel = document.getElementsByTagName("select");
for (var i=0; i<sel.length; i++){
if (sel[i].className == "select-content") {
sel[i].onchange = getFile;
}
sel[i].selectedIndex = 0;
}
}

function getFile (url) {
var url = "AJAX/get_Bank.php?dealType="+ this.value;
if (window.XMLHttpRequest) {xmlhttp=new XMLHttpRequest();}
else {xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");}

xmlhttp.open("GET",url,false);
xmlhttp.send();

// a loop that looks through all <div>s on the page
// and then replaces the id with the value and gets that file
var divs = document.getElementsByTagName("div");
for (var i=0; i<divs.length; i++) {
if(divs[i].id == "bank") {
divs[i].id = this.value;
divs[i].innerHTML=xmlhttp.responseText;
}
}
}

I have created a login page where you can register, log in and log out. Here everything is saved on file (not MySQL or other databases). Everything works fine when I tested this in http://localhost/ but when I upload everything to a Web server, so that you can access them from "outside" then I get lots of error such as


Warning: fopen(userpwd.txt) [function.fopen]: failed to open stream: Permission denied in /afs/ltu.se/systemdata/www/students/somroy-0/gemensam.php on line 13


what can I do to fix this?

Ok, I'm trying to play with custom error handeling, and not getting anywhere. 
I have some code I made up just to mess about and get a feel for this, but no matter what I try I get nothing thrown out and no error caught. 
I did have it all in the one class, but got strongly advised that was a bad bad bad thing to do, so in an effort to keep the focus on the actual problem I've moved it off into it's own class.

Here's the code, it's self contained (as I said its only a play around) but I would really appreciate it if someone could explain why the errors arn't being caught:
<?php
//------------------------------------------------
class dbc {
public $server;
public $host;
public $db;
public $user;
public $pass;

public function set($var, $val=0){
 try{
  if(is_array($var)){
   foreach ($var as $k => $v) {
    if(!$this->$k = $v){
     throw new Exception('Error Setting Database Information :');
    }     
   }  
  }
  else{
   if(!$this->$var = $val){
    throw new Exception('Error Setting Database Information :');
   }
  }
 }
 catch(Exception $e){
  $setError = array('1', 'set', $e->getMessage());
  $error->ErrorHandle($setError);
 }
}
}
//------------------------------------------------    
class errorCatch{
public $severity;
public $methodCall;
public $message;

public function ErrorHandle($error){
 $this->severity = $error['0'];
 $this->methodCalled = $error['1'];
 $this->message = $error['2'];
 if ($this->severity == 1){
  die ("Critical error in call to dbo-&gt;$methodCall: $message");
 }
 die("Warning Call to $methodCall resulted in a non fatal error: $message");
}
}
//------------------------------------------------
$error = new errorCatch;
$con = new dbc;
$set = array('hst'=>'localhost', 'svr'=>'mysql');
$con -> set($set);
var_dump($error);
?>

I'm creating my own lottery feature for my online game, which uses in-game money. I decided to create my own function to compare the numbers of each ticket. Before I started creating the mod, I did some testing to see if my pseudocode function would work. When I go onto my test page, I get this error: Error 324 (net::ERR_EMPTY_RESPONSE): Unknown error.

I've Googled it, and it says that it's a Google Chrome error and that I should restart my browser and so on, which I did. Nothing worked. I've yet to try it in another browser yet.....

My code is below:
<?php
include_once(DIRNAME(__FILE__) ."/globals.php");
ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

function checkResult($numbers, $winNums, $key, $wins) {

if($key >= 7 && $wins >= 7) {

print "Break out <br />";

return $correct;

break;

}

else {

$nums = unserialize($numbers);

$winning = unserialize($winNums);

$p = $nums[$key];

$n = $winning[$wins];

if($n != $p && $n > $p) {

print "Increment \$key <br />";

$key++;

checkResult($numbers, $winNums, $key, $wins);

}

elseif($n != $p && $n < $p) {

print "Increment \$wins <br />";

$wins++;

checkResult($numbers, $winNums, $key, $wins);

}

elseif($n === $p) {

print "Matching! <br />";

$correct++;

$key++;

$wins++;

checkResult($numbers, $winNums, $key, $wins);

}

}
}

$yourNumbers = array(15,20,42,37,4,8);
$winNumbers = array(17,28,20,4,15,39);
$sortYourNumbers = sort($yourNumbers);
$sortWinNumbers = sort($winNumbers);

print_r($yourNumbers);
print "<br />";
print_r($sortYourNumbers);
print "<hr />";
print_r($winNumbers);
print "<br />";
print_r($sortWinNumbers);

$yrs = serialize($yourNumbers);
$wns = serialize($winNumbers);
$correct = 0;

print "<br />";
print $yrs ."<br />";
print $wns;

checkResult($yrs, $wns, 0, 0);

$h->endpage();
?>

Could someone please point out to me why this is causing the unknown error? I've tried other pages on my website, they all work perfectly.

Any help will be appreciated.

I am working on a register script for my site that will give errors when needed.

I am trying to make it so that if the submitted username doesn't equal [A-Za-z0-9-\s]{3,25} then it'll make $error1 = 1.

if(preg_match('/[A-Za-z0-9-\s]{3,25}/i', $_POST['username'], $matches) && strlen($matches[0]) === strlen($_POST['username'])){

$error1 = 1;

}

I've tried putting a ! where the three equal signs are, replaced them, and everything.

I'm practicing some code

here

Code: [Select]
reset($_POST);

while (list ($key, $val) = each ($_POST)) {
if ($val == "";)  $val = "NULL";
$arVals[$key] = (get_magic_qqotes_gpc())  ? $val : addslashes($val);

if($val == "NULL")
$_SESSION[$key] = NULL;
else
$_SESSION[$key] = $val;


if ($key != "access_period" && $key != "passwd")
$arVals[$key] = "'".$arVals[$key]."'";


}

And it's giving me error

Quote

Parse error: parse error in C:\wamp\www\php\user_registration\registered.php on line 26



line 26 is the
Code: [Select]
if ($val == "";)  $val = "NULL";

I wonder what the problem is...

I am making a script that has a Notification/Inbox system in it. Right know it's close to being done, but I have one problem..

My problem is that if a user has >= 1 message in their inbox it shows what it should, but if the user has nothing in the inbox it shows nothing instead of the simple error "You have no message in your inbox".

Code 1:
        $inbox_a = mysql_query("SELECT * FROM notifications WHERE recieverid='". $_SESSION['id'] ."'") or die(mysql_error());

Code 2:

<?php if(!mysql_num_rows($inbox_a) <= 0) { ?>

<tr class="table">

<td class="name"><a href="usercp.php?usercp=inbox&id=<?php echo $msgid; ?>"><h3><?php echo ucFirst($msgname); ?></h3></td>

<td class="revision"><h3><a href="#"><?php echo $msgsendername ?></a></h3></td>

<td class="votes"><h3><?php echo date('D, M d, Y h:i A', strtotime($msgdate)) ?></h3></td>

</tr>

<?php } else { ?>

<tr class="table">

<td class="name">You have no messages in your inbox.</td>

<td class="revision"></td>

<td class="votes"></td>

</tr>

<?php } ?>