PHP - Error Reporting, Specific Settings

is it possible to disable warnings on a specific page?
php.ini set to show warnings

I wish to respond specifically to PDO errors.  $e->getMessage() shows something like the following:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails... SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ...

I suppose I can just look for 1452 and 1062, but thought using http://php.net/manual/en/pdo.errorcode.php would be better, but it is empty.  I am using Server version: 10.2.18-MariaDB MariaDB Server.  Any suggestions?

Thanks

try{
    $this->pdo->prepare($sql)->execute([$value, $id, $this->accountsId]);
}
catch(\PDOException $e) {
    syslog(LOG_ERR, json_encode($this->pdo->errorCode()));
    syslog(LOG_ERR, json_encode($this->pdo->errorInfo()));
}

"00000"
["00000",null,null]

 

Hi there,

I'm writing an application that pulls from two separate web based APIs, collates the data into a single array of data.  Once done, it then enters a loop that cycles through the array and executes a cURL call for each cycle.  This worked perfectly for a controlled set of 10 artificial records and so I've started testing with live data.

On running the code, I eventually the following :
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

I'm not sure how to debug this and so I'm hoping I can find some help here.
I'm running WAMP, and the php.ini contains the following:
max_execution_time = 0   ; Maximum execution time of each script, in seconds
max_input_time = 0   ; Maximum amount of time each script may spend parsing request data

Through testing, I have discovered the following :
The script can do exactly 35 iterations through the loop in under 2 minutes.
Any number greater than this causes the error.
If I skip the first 20 curl submits, I can then do 21 to 55 iterations before failure, so I do not believe it is the 36th value.
If I put a sleep(5) command into the loop, I can still do 35 and no more iterations than that.
If I put a sleep(10) command into the loop, it fails on 35 and needs less.

Code: [Select]
$action = "post";
$url = "http://url.url.url/api/v1.0/udo_Position/create"; // I've replaced the actual URL out of necessity

// set user agent {
print("Setting CURL options, using URL ".$url."<br>");
$cd = curl_init();
curl_setopt($cd, CURLOPT_HEADER, 1);
curl_setopt($cd, CURLOPT_URL, $url);
curl_setopt($cd, CURLOPT_USERPWD, 'username:password');
curl_setopt($cd, CURLOPT_RETURNTRANSFER, 1); // Don't send return value to screen
curl_setopt($cd, CURLOPT_USERAGENT, "Firefox/2.0.0.1"); // spoofing FireFox 2.0
curl_setopt($cd, CURLOPT_VERBOSE, true);
// }

if ($action == 'get') {
;
} elseif ($action == 'post') {
print("POST set;<br>");
print("<pre style='font-family:verdana;font-size:13'>");
print_r($pointval);
print("</pre>");
$pointval["save"] = "Save"; // The AddNew step form requires this.

curl_setopt($cd, CURLOPT_POSTFIELDS, $pointval);
} else {
print("Invalid usage. Please see example<br>");
return;
}

$reply = curl_exec($cd);

$http_status = curl_getinfo($cd, CURLINFO_HTTP_CODE);
print("<pre style='font-family:verdana;font-size:13'>");
print_r($http_status);
print("</pre>");

print("Here is the reply from the AddNew function: <br>");
print("<pre style='font-family:verdana;font-size:13'>");
print_r($reply);
print("</pre>");

if (curl_error($cd)) {
print("Error: ".(curl_error($cd))."<br>");
}

curl_close($cd);
print("Insert Successful.<br>");

I am uncertain whether it is a PHP, Apache or cURL issue at this point.  I have another script that pushes a great deal more cURL calls to the same system but pulls from only one external resource, instead of two.  Any help or suggestions would be appreciated.

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.

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

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 ,

 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.

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);

?>

I use the Wholesale Suite Premium Prices plugin with WooCommerce. I have 6 specific wholesale roles out of 15 that I wish to hide two specific shipping methods from being selected for the 6 exceptions. I'm just trying this on my staging server at this time using a code snippet example that I found and modified for my specific conditions. Would the following work for this purpose?

/* Hide specific shipping methods for specific wholesale roles */
add_filter( 'woocommerce_package_rates', function( $shipping_rates ) {
// User role and shipping method ID to hide for the user role
    $role_shipping_method_arr = array(
    'ws_silvia_silver' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_silver' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_silver_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Premium Standard Shipping (Tracking Service)'),
    'ws_silvia_gold' =>    array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_pst_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    'ws_silvia_gold_tax_exempt' => array( 'Silvia Union Standard Shipping (Tracking Service)'),
    );

    // Getting the current user role
    $curr_user = wp_get_current_user(); 
    $curr_user_data = get_userdata($current_user->ID); 

    // Wholesale Suite Roles 
    if (isset($current_user) && class_exists('WWP_Wholesale_Roles')) {
        $wwp_wholesale_roles = WWP_Wholesale_Roles::getInstance();
        $wwp_wholesale_role = $wwp_wholesale_roles->getUserWholesaleRole(); 

// Loop through the user role and shipping method pair
    foreach( $role_shipping_method_arr as $role => $shipping_methods_to_hide ) {

// Check if defined role exist in current user role or not
    if( in_array( $role, $current_user->roles) ) {

// Loop through all the shipping rates
    foreach( $shipping_rates as $shipping_method_key => $shipping_method ) {
$shipping_id = $shipping_method->get_id();

// Unset the shipping method if found
    if( in_array( $shipping_id, $shipping_methods_to_hide) ) {
unset($shipping_rates[$shipping_method_key]);
}
}
}
}
}
    return $shipping_rates;
});

Any insights as to how to accomplish this would be greatly appreciated. Lyse

what I'm trying to do is to setup a page called settings.php that the admin runs to order to turn option in the web site on or off. I don't know how to do this since I never done this before. My code is below.


<link href="mainframe.css" rel="stylesheet" type="text/css">

<?php
require_once '../config.php';

$db = new DbConnector();
$db->DbConnector();


if(isset($_GET['submit'])) {

$db->query('UPDATE '.SETTING_TABLE.' SET option='.$_POST['banner'].' WHERE setname=''');

  echo 'Process complete';
}

$result = $db->query('SELECT * FROM '.SETTINGS_TABLE);

echo '<table border="1">';
echo '<tr>';

echo '<form action="settings.php" methed="post">';

while($row = $db->fetchArray($result))
  {
   
  echo '<tr>';
  echo '<td>'.$row['setname'].'</td><td><select size="1" name="'.$row['setname']'">';
  echo '<option value="on">on</option>';
  echo '<option value="off">off</option>';
  echo '</td>';  
  echo "</tr>";
  }
  echo '<td><input type="submit" value="Submit" name="submit">';
  echo '</td>';

echo "</tr>";
echo "</form>";
echo "</table>";

/*
*/

?>

<h2>Settings</h2>

<a href = "admin.php">Admin Panel</a>

How do I setup my PHP code and server to accept custom domains on my program like tumblr does? http://www.tumblr.com/docs/en/custom_domains
I know the domain owner needs to do the A name part but what needs to be done my side?

Cheers in advance

Where do PHP configuration settings (e.g. Error-Handling Levels) exist?

I believe they are in a file somewhere?!

Thanks,


Debbie

Hello,

I'm working on a project and at some point ill need to save user specific settings ex: show/hide email etc... configuration file is not the case i thin  because there are specific to every user, database will be the choice but what  practice(logic) is the best to save these settings?
Thank you!

Hi,   I'm not sure if this is possible, however I'm sure somebody will be able to point me in the right direction. Relativley new to php here.   I would like to write a small app that will change my IP/Subnet Mask/Gateway depending on a selection made from a dropdown list. I will have a tota; of 50 different IP settings & drop downs (each drop down will represent a different location)   I have yet to start writing the app, just on paper so far - can this be done?   I have seen examples of batch scripts like the one below that work, would I need to incorporate something like this into my php?

netsh int ipv4 set address name="Local Area Connection" source=static address=10.127.86.25 mask=255.255.255.240 gateway=10.127.86.30

This is just a personal project, I'm trying to further my knowledge!   Thanks   J