PHPBuilder.com

[RESOLVED] Recent appearance of error_log in ALL subdirs: "Module 'timezonedb' already loaded"

Joseph Sliker — Fri, 17 May 2013 15:41:01 GMT

Hi; I have just recently noticed that the error_log files in ALL active subdirectories of my site are adding a new line every single, freakin' time a .php page is called!

Each line reads like so (with the correct time/date):

[16-May-2013 14:13:12 America/Los_Angeles] PHP Warning: Module 'timezonedb' already loaded in Unknown on line 0

...I have been working on a bunch of new stuff, but this is even happening in old parts of the site that have not been touched.

I contacted the host provider support board and was advised to add the following line to my .htaccess file

date.timezone = America/Chicago

(I don't think I have ever edited in 5+ years of using this host)

I added that line...which completely disabled my site. So I found that the apparent correct syntax is actually:

SetEnv TZ America/Chicago

...which allowed my site to work once again (phew!)
The error messages are now conveniently tagged with a correct Central timezone stamp, a la:
[16-May-2013 16:48:36 America/Chicago] PHP Warning: Module 'timezonedb' already loaded in Unknown on line 0

I am suspecting this has something to do with a bug in the server's installation or configuration of .php (and therefore I will not be able to fix the constant creation of these error messages). But I am open to suggestion.

If it DOES look like a server-based glitch that the "powers that be" must fix does anybody here know anything specific I can suggest that these folks look at?

Thanks.

suggestions for control of cluster nodes by a master node?

sneakyimp — Thu, 16 May 2013 23:46:02 GMT

I'm working on a project wherein we need to auto-scale our computing resources in response to a daily batch of tasks. Basically, the tasks arrive at midnight when a PHP script runs on a web server and inserts a bunch of records in a database table on a shared mysql server. When these job records have been inserted, I would then like to run another script which interacts with the Rackspace cloud to launch a bunch of virtual server instances to process these jobs.

My main question is Can anyone recommend an effective tool or technique for a master PHP script running on my primary web server to monitor and control these newly allocated virtual servers?

Having thought about this some, I can see that a few types of operations will be necessary:
* once a virtual (slave) server has been launched, hand that slave a unique identifier that it will use to lock records in the job database and then fire up a script on the slave to work on the jobs
* monitor the slaves as they work to keep an eye on load averages, memory usage, job completion rates, and other data related to slave health and performance.
* when the jobs have been completed, de-allocate the slave servers so we save money.

I expect I could do a roll-your-own approach to this but can't help but wonder if some helpful tool already exists that would make this easier.

Handling Paypal Buttons While Updating a Database

sgrd267 — Thu, 16 May 2013 15:24:13 GMT

I am testing ideas for a new section of my company's website. We're doing online magazine subscriptions and I'm trying to find the easiest way to make online renewals automatic.

I have index.html which contains a Paypal button:

Code:









Untitled Document





action="handler.php" method="post" target="_top">

  

  

  

    

      

    

    

      

    

  

        Subscribe or Renew

Notice that I have changed the form action to "handler.php". handler.php queries a database to update the customer's subscription expiration date. So that the customer's subscription will expire one year from the date of renewal. I know that my code doesn't exactly do this, but it still works for my purpose. Once again, I'm just testing and playing around. Here is handler.php:

PHP Code:


$dbhost = "-------";

$dbname = "-------";

$dbuser = "-------";

$dbpass = "-------";



//Connect to server and select databse.

$con = mysql_connect("$dbhost", "$dbuser", "$dbpass");

if (!con){

    die(mysql_error($con));

}



// Select the database.

mysql_select_db("$dbname", $con);



// Query

$sqlone = "SELECT * FROM test WHERE id='1'";

$result = mysql_query ("$sqlone") or die ('Error: '.mysql_error ());

$result = mysql_fetch_array($result);



$date = $result["date"];

$currentyear = substr("$date",0,4);

$currentmonthday = substr("$date",4,9);

$renewedyear = $currentyear + 1;

$reneweddate = "$renewedyear"."$currentmonthday";



// Update the database

$sqltwo = "UPDATE test SET date='$reneweddate' WHERE id = '1'";

mysql_query ("$sqltwo") or die ('Error: '.mysql_error ());

So, once the paypal button has been clicked, everything goes to handler.php, the database updates correctly, and all of the paypal variables go floating off into space never again to serve any purpose. How can I restructure this so that my database gets updated and the paypal shopping cart still works? I thought about passing all the paypal variables to handler.php, but from there how would I pass those variables along to the shopping cart? Any ideas? Any suggestions would be greatly appreciated. Thanks.

Possible to add text to an image... and save the image, not just overlay?

listenmirndt — Thu, 16 May 2013 06:23:53 GMT

I am trying to write permanent text on an image, I've found a GD way to overlay text, but it doesn't actually write the text to the actual photo file, which is what I am hoping to be able to do... is this possible?

Trying to write a comment system, please give thoughts.

JustCoding — Thu, 16 May 2013 03:21:52 GMT

Alright, I have ventured out and attempted to write this code 100% myself. The problem is everything was working just fine until I tried to implement a reply system. This code would probably make a real PHP developer disgusted, I know there is probably an easier/more logical way to do this but from my knowledge this is the only way I know how to go about doing this.

What is your feedback?

PHP Code:


//Get Comments From Database

$comments = mysql_query("SELECT id,user,comment,avatar FROM comments WHERE commentpage='$youtubeid' ") or die(mysql_error());



if (!$comments) {  //Retrieve Comments

        exit;

    }else{



    while ($commentrow = mysql_fetch_row($comments)){

    $comment_id = $commentrow['0']; //Get Comment ID

    $comment_user = $commentrow['1']; //Get Comment Author

    $comment_message= $commentrow['2']; //Get Comment Message

    $comment_avatar = $commentrow['3']; //Get Comment Avatar

    

    

$replies = mysql_query("SELECT user,comment,avatar FROM comments WHERE reply='$comment_id' ") or die(mysql_error());

if (!$replies) {  //Retrieve Reply Comments

        exit;

    }else{



    while ($commentreplyrow = mysql_fetch_row($replies)){

    $comment_replyuser = $commentreplyrow ['0']; //Get Reply Comment Author

    $comment_replymessage= $commentreplyrow ['1']; //Get Reply Comment Message

    $comment_replyavatar = $commentreplyrow ['2']; //Get Reply Comment Avatar

    



    

         echo $comment_user.'
'; //This is just for testing. I will make this look pretty after I get further in development.

     echo $comment_message .'

';



          echo $comment_replyuser.'
';

     echo $comment_replymessage.'
';

    

    }

    }

    }

    }

?>

List of special character

DanDin — Wed, 15 May 2013 21:12:54 GMT

Hello,

I am developing a simple form to collect user information. I want a sample PHP code, that will validate the input string to display whether it has any of the below list of special character in the string.

Special Characters ( - & ' " / \ % * # )

Can one of please help me. More detailed info below:

I have a form that submits the input to a PHP modules using Ajax Post. When my PHP modules reads the POST values, it should validate to check if the special characters are available, if it is available then display "No special characters allowed"

Anyones help will be so greatful

Thank you.

Iterate through JSON data like a multi-d array?/Show all fields/vals for clicked row?

Joseph Sliker — Wed, 15 May 2013 18:30:45 GMT

Hi; My head hurts. I am not _quite_ getting this JSON object stuff.

Three goals here:
1. Run a MySQL query and return the results in JSON
(I can do this...it seems to work fine)

2. show a table that shows short/summary CLICKABLE record rows (that show just a couple of the fields for each of the JSON rows/elements) ...
(I've actually figured out this first part and it seems to work fine)

3. The result of clicking on a specific row (in the table refered to above) results a display in a table/form being shown that will show ALL fields/values for that specific, clicked record.
When I click a row, the row ID _does_ magically appear in the tags located above the summary table.
(THIS IS WHERE I AM STUCK...instead of just seeing that number, I want to see all available details for that specific record/row)

[I can do all of this stuff in php with sessions, and arrays and forms and all that good stuff...but I would like to understand how to do this in javascript/client-side in order to make use of the page more efficient]

Here is the code that seems to be working fine to accomplish steps 1 and 2.
My offerdata.js file:

Code:

$(document).ready(function() {        

$.getJSON('offerdata.php', function(data) {//a summary table that shows, say, 4 out of 12 fields that exist in JSON for each row

      var table=''; 

               table+='';   

      $.each(data, function(index, item){

         table+='';

       });

      table+='OFFER_ID PROPERTY STAFF OFFER_STATUS
'+item.OFFER_ID+' '+item.PROPERTY+' '+item.STAFF+' '+item.OFFER_STATUS+'
';

      $("#content").html(table);        //refer to this id in  tags back at the page 

});        

});
 and back in the  of the page, I have this:

	HTML Code:
	
"offer_id">





"content">

OFFER_ID	PROPERTY	STAFF	OFFER_STATUS
'+item.OFFER_ID+'	'+item.PROPERTY+'	'+item.STAFF+'	'+item.OFFER_STATUS+'

 I am assuming, because I _CAN_ see my summary table, that the complete JSON array (object?) remains available to populate the details table I would like to be able to display.



Somebody give me a nudge in the right direction?



Thanks.



displaying data on a page with databases
chrisguk — Wed, 15 May 2013 12:20:03 GMT
Hi,



I am at the next stage of learning and so far I have a simple select statement working with PDO as illustrated below.  This works fine if you want a list of things or just one thing:



What if, for example I had lets say four products on one page with headings but each product is a different level:



bronze  |  silver  |  gold   |  platinum



Try to imagine that they have similar services but just more of, when you select the higher package.



I am not looking for anyone to write the code for me, just steer me in the right direction.



Here is my code so far which works for one thing.




	PHP Code:
	





$book_query = ("SELECT * FROM packages WHERE service = ? LIMIT 10"); 

if(!$book_stmt = $pdo->prepare($host_query)){ 

    // prepare failed 

    echo "Prepare failed:\n"; 

    print_r($pdo->errorInfo()); 

    echo "
"; 

} else { 

    if(!$book_stmt->execute(array('books'))){ 

        // execute failed 

        echo "Execute failed:\n"; 

        print_r($book_stmt->errorInfo()); 

        echo "
"; 

    } else { 

        // query ran without any errors, you can test if it returned any rows and use them here 

         

    } 

} 

// Database   



if ($book_stmt->rowCount() > 0) {

while ($col = $book_stmt->fetch(PDO::FETCH_ASSOC)) {  

    $title = $col['title']; 

    $author = $col['author']; 

    $descr = $col[''description]; 

    $type = $col['type']; 

    $language = $col['language']; 

    $paperback = $col['paperback']; 

    $currency = $col['currency']; 

    $price = $col['price']; 

     



    } 



} else { 



    $title = 'no data'; 

    $author = 'no data'; 

    $descr = 'no data'; 

    $type = 'no data'; 

    $language = 'no data'; 

    $paperback = 'no data'; 

    $currency = 'no data'; 

    $price = 'no data'; 



} 




 

I hope what i am trying to achieve is clear.  Any help will be great ;)

 


Formatting text file
joane1 — Wed, 15 May 2013 08:41:17 GMT
Hi!

i have some data exactly as below:


	Code:
	
country 

town

monument



france

paris

eiffel



usa

newyork

manatthan

...
 I need to format as below:


	Code:
	
country town monument

france paris eiffel

usa newyork manatthan
 How can I obtain this result?



Thanks!

 


Query with joins, count()s and sum() producing odd results
bunner bob — Wed, 15 May 2013 01:22:31 GMT
Well, probably not "odd" - much more likely bad SQL on my part.



I'm attempting to get a list of all customers, and get each customer's count of orders from the order table, count of cart items from the cart items table, and sum of store credit from the credits table.



=====================================



SELECT c.*, SUM(sc.amount) AS creditTotal, COUNT(o.orderId) AS orders, MAX(o.orderDate) AS lastOrder FROM customers c LEFT JOIN storeCredits sc ON c.customerId=sc.customerId LEFT JOIN orders o ON c.customerId=o.customerId GROUP BY c.customerId ORDER BY c.lastName ASC 



This gets me an "orders" count of 4 for my second customer, which is correct. But when I join cartItems to the query I get an orders count of 8, and a cartItemCount of 8 (should be 2).



SELECT c.*, SUM(sc.amount) AS creditTotal, COUNT(o.orderId) AS orders, MAX(o.orderDate) AS lastOrder, COUNT(ci.cartItemId) AS cartItemCount FROM customers c LEFT JOIN storeCredits sc ON c.customerId=sc.customerId LEFT JOIN orders o ON c.customerId=o.customerId LEFT JOIN cartItems ci ON c.customerId=ci.customerId GROUP BY c.customerId ORDER BY c.lastName ASC 



It's definitely adding the last LEFT JOIN that's messing things up, not adding to the SELECT statement. It seems to be multiplying the COUNT items within the query by each other (4 x 2) instead of keeping them isolated and separate.



Any tips?

 


"Interprocess" communication and serialized data ...
dalecosp — Tue, 14 May 2013 20:45:48 GMT
I'm working on another stage of a large project at work.



After munging some data objects, one process needs to "queue it up" for another to be run at a later time.



Currently I'm thinking to serialize the data and pop it in a table with a couple additional tagging fields.



Something like:




	Code:
	
+------------+-------------+------+-----+---------+----------------+

| Field      | Type        | Null | Key | Default | Extra          |

+------------+-------------+------+-----+---------+----------------+

| id         | int(11)     | NO   | PRI | NULL    | auto_increment |

| clientid   | int(11)     | NO   | MUL | NULL    |                |

| ordernum   | varchar(64) | NO   |     | NULL    |                |

| t_package  | mediumblob  | NO   |     | NULL    |                |

+------------+-------------+------+-----+---------+----------------+
 Is there any reason I shouldn't do it this way?  Some other system?  I really want to keep the object in its previous state, but can't hand it off to the next process immediately.



Thanks in advance,

 


Help with setting page size
Mike_ZA — Tue, 14 May 2013 18:47:13 GMT
Hi, hope someone can help.

I either need a very simple 'set page size' so the "echo" page isn't too large for the table it appears in or somehow change dimensions somewhere.

I am using a PHP form, where people type in the fields in feedback.php, and when they submit, it parses to sendemail.php with the following response:



Thanks for your
 entry . Good luck!



(I am all a bit new to this so I apologise, especially if my terminology usage is out.)



Unfortunately, as the image below shows (comparing the before and after sumbission), the sendemail.php is taking up too much space in the rounded table.  It's for a facebook app I am trying to build.  



Attachment 4889


	

	

	

	
		
			Attached Images
			
			
	
	error.jpg‎ 
(37.6 KB)
 
			
			
	

	

	
 


[RESOLVED] Row 10 no displaying
chrisguk — Tue, 14 May 2013 15:05:26 GMT
I hopefully seem to be getting somewhere from my last post about creating a database script.  But now I seem to be getting an error with the following:




	Code:
	
Notice: Undefined offset: 10 in /var/www/mysite/include/config.php on line 126
 So its this line 126 that the output will not produce:




	Code:
	
 $price = $col[10];
 I ran the query in phpmyadmin to make sure it was working:



SQL result



Host: localhost

Database: mydb

Generation Time: May 14, 2013 at 04:56 PM

Generated by: phpMyAdmin 3.5.8.1deb1 / MySQL 5.5.31-0ubuntu0.13.04.1

SQL query: SELECT * FROM packages WHERE service = 'books' LIMIT 1; 

Rows: 1



service	plan	  title	author descr type language paperback currency price

books 	weekly a	b	  c	  d     e            f             g            h



Here is the code:




	PHP Code:
	



$book_query = ("SELECT * FROM packages WHERE service = ? LIMIT 1");

if(!$book_stmt = $pdo->prepare($host_query)){

    // prepare failed

    echo "Prepare failed:\n";

    print_r($pdo->errorInfo());

    echo "
";

} else {

    if(!$book_stmt->execute(array('books'))){

        // execute failed

        echo "Execute failed:\n";

        print_r($book_stmt->errorInfo());

        echo "
";

    } else {

        // query ran without any errors, you can test if it returned any rows and use them here

        

    }

}

// Database  



if ($book_stmt->rowCount() > 0) {

    while ($col = $book_stmt->fetch())

    {

    $title = $col[3];

    $author = $col[4];

    $descr = $col[5];

    $type = $col[6];

    $language = $col[7];

    $paperback = $col[8];

    $currency = $col[9];

    $price = $col[10];

    



    }



} else {



    $title = 'no data';

    $author = 'no data';

    $descr = 'no data';

    $type = 'no data';

    $language = 'no data';

    $paperback = 'no data';

    $currency = 'no data';

    $price = 'no data';



} 




 



What can I do to correct this?

 


Is my select statement secure enough?
chrisguk — Mon, 13 May 2013 14:37:20 GMT
I have thrown together the following, with a few snippets pulled from various places.  Is it ok to use without the worry of sql injection?




	PHP Code:
	



try {

  // Connect and create the PDO object

  $conn = new PDO("mysql:host=$hostdb; dbname=$namedb", $userdb, $passdb);

  $conn->exec("SET CHARACTER SET utf8");      // Sets encoding UTF-8



  // Define and perform the SQL SELECT query

  $sql = "SELECT * FROM `db_linux`";

  $result = $conn->query($sql);



  // If the SQL query is successfully performed ($result not false)

  if($result !== false) {

    $cols = $result->columnCount();           // Number of returned columns



    // Parse the result set

   if ($sql->num_rows > 0) {

    while ($row = $sql->fetch_object())

    {

        $plan = $row->plan;

        $name = $row->name;

        $text = $row->text;



    }



} else {



    

    $plan = 'no plan';

    $name = 'NA';

    $text = 'NA2';



} 

    

    

  } 




 

 


MYSQL Update
leewad — Mon, 13 May 2013 11:23:59 GMT
HI



Im using the following to update databases




	PHP Code:
	

MYSQL_QUERY( "insert into $table1 SELECT * FROM $table2 where 1 "); 




 

There are 24 fields in each table, my problem is if a reference number ( ie. R12121 ) exists in table1 i want it to update and not add new record, how can this be done?