PHPBuilder.com - General Help

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

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

[RESOLVED] regex help, matching $i number of numbers in $var - stuck

kender — Sun, 12 May 2013 05:48:40 GMT

Okay, I am trying to check a $var for numbers, anywhere in the $var

What I have is

PHP Code:


if(($number != 0) && (preg_match('/[0-9]{'.$number.'}/', $var) == 0))

{

  // throw error

}

Where $number is a user defined quantity of numbers that must be in the $var.. unfortunately this preg_match only checks for side by side, but it could be anywhere in the $var

eg:

PHP Code:


$var = 'fa5ba5rwbv';

$number = 2;

this should pass, but doesn't with my expression... but I can't find an example matching my specific need... can anyone help here?

load average for intervals measured in seconds rather than minutes?

sneakyimp — Sat, 11 May 2013 22:22:09 GMT

I was wondering if there might exist a linux command or php function that will tell me how busy my CPU is? I've gotten accustomed to typing 'w' which gives me a load average (not quite the same thing as CPU utilization but pretty good) or 'top' (which does actually calculate some kind of CPU % utilization).

Unfortunately, the 'w' command only shows load averages over 1, 5, and 15 minutes. I need something that looks at a shorter interval (e.g., 15 seconds). Can anyone tell me how I might get load average on the order of seconds rather than minutes?

Why do I need this? Because I'm writing a multi-threaded PHP script and would like it to be able to utilize all available resources up to a point -- I want to check the CPU utilization before deciding how many threads to spawn.

Safe deployment of incremental changes from SVN to a production machine?

sneakyimp — Wed, 08 May 2013 18:37:56 GMT

I'm working on a project where we use SVN for our source code control. When changes are committed to the repository, a process on the svn server takes care to copy the changed files to our development server.

Our production server, however, has no such automatic connection -- and for good reason. We automatically deploy committed code changes to the dev server for the purpose of testing. by the time anything gets committed to the repo, we have typically tested it on our local workstations. We don't want to auto-deploy repo changes to our live server for obvious reasons -- something could easily break.

The question I have is once we are convinced that the repo changes need to be rolled out to the production server, what is the best way?

I have suggested running svn export on the production server when we are ready but my coworker is balking -- says it makes him too nervous. Furthermore, svn export will fetch the entire repo unless I explicitly limit the command to some subdirectory or individual file. Additionally svn export might alter file permissions, preventing apache from writing certain data files and/or source files and/or configuration files. There's also the possibility that one might check one's local configuration file into the repo and this would ultimately end up in dev/test/sandbox credentials finding their way onto a production server.

Can anyone recommend a sound approach to the workstation-dev server-production server setup when using svn? At the moment, we are manually tracking changed files and uploading them to the production server via FTP. This is a chore and prone to human error.

script to export all documents uploaded online website stored in Mysql database.

sipiwind — Tue, 07 May 2013 17:12:56 GMT

All,

I need some help with a script(php, sql, etc) to run on MySQL database, to export all the documents which users uploaded on to the online web application. The documents are in different file type (eg. pdf, mword, ms-powerpoint, ms-excel, etc). The data is stored on one table.

Thank you all,

Using Pagination and search function together

phpnewbie34 — Tue, 07 May 2013 11:41:38 GMT

Good afternoon friends at PHPBUILDER

I have a script that allows a user to type in a search term and the page will refresh with relevant search terms

My pagination script uses $_GET to display information and so does my search script.

How do I display both the page=X and search=X on the same page

Whenever I click the NEXT button on my site, index.php?search= turns into index.php?page=

Any suggestions for adding both GET statements to the URL?

Is pagination compatible with PHP search function.

Thanks :) :)

Live Keyword Search

phpnewbie34 — Sat, 04 May 2013 12:12:11 GMT

Good morning programmers,

I'm looking to create a live keyword search using PHP, MySQL

Is this possible to do without using Javascript or another programming language?

Any suggestions would be much appreciated

Parse error: syntax error, unexpected '<' in /home/manotoin/public_html...

bihamta — Fri, 03 May 2013 22:57:49 GMT

hi
i see this error when i try too remember my login password:
Parse error: syntax error, unexpected '<' in /home/manotoin/public_html/index.php on line 21

Code:




/*

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

|     e107 website system

|

|     Copyright (C) 2001-2002 Steve Dunstan (jalist@e107.org)

|     Copyright (C) 2008-2010 e107 Inc (e107.org)

|

|

|     Released under the terms and conditions of the

|     GNU General Public License (http://gnu.org).

|

|     $URL: https://e107.svn.sourceforge.net/svnroot/e107/trunk/e107_0.7/index.php $

|     $Revision: 11678 $

|     $Id: index.php 11678 2010-08-22 00:43:45Z e107coders $

|     $Author: e107coders $

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

*/







require_once('class2.php');



if (file_exists('index_include.php')) {

        include('index_include.php');

}



if (!is_array($pref['frontpage']) && $pref['frontpage'] != 'Array') {

        if (!$pref['frontpage'] || $pref['frontpage'] == 'Array.php') {

                $up_pref = 'news.php';

        } else if ($pref['frontpage'] == 'links') {

                $up_pref = $PLUGINS_DIRECTORY.'links_page/links.php';

        } else if ($pref['frontpage'] == 'forum') {

                $up_pref = $PLUGINS_DIRECTORY.'forum/forum.php';

        } else if (is_numeric($pref['frontpage'])) {

                $up_pref = $PLUGINS_DIRECTORY.'content/content.php?content.'.$pref['frontpage'];

        } else if (substr($pref['frontpage'], -1) != '/' && strpos($pref['frontpage'], '.') === FALSE) {

                $up_pref = $pref['frontpage'].'.php';

        } else {

                $up_pref = $pref['frontpage'];

        }

        unset($pref['frontpage']);

        $pref['frontpage']['all'] = $up_pref;

        save_prefs();

}



$query = (e_QUERY && e_QUERY != '' && !$_GET['elan']) ? '?'.e_QUERY : '';



if ($pref['membersonly_enabled'] && !USER) {

        header('location: '.e_LOGIN);

        exit;

} else if (isset($pref['frontpage']['all']) && $pref['frontpage']['all']) {

        $location = ((strpos($pref['frontpage']['all'], 'http') === FALSE) ? e_BASE : '').$pref['frontpage']['all'].$query;

} else if (ADMIN) {

        $location =  ((strpos($pref['frontpage']['254'], 'http') === FALSE) ? e_BASE : '').$pref['frontpage']['254'].$query;

} else if (USER) {

        require_once(e_HANDLER.'userclass_class.php');

        $class_list = get_userclass_list();

        foreach ($class_list as $fp_class) {

                $inclass = false;

                if (!$inclass && check_class($fp_class['userclass_id'])) {

                        $location = ((strpos($pref['frontpage'][$fp_class['userclass_id']], 'http') === FALSE) ? e_BASE : '').$pref['frontpage'][$fp_class['userclass_id']].$query;

                        $inclass = true;

                }

        }

        $location = $location ? $location : ((strpos($pref['frontpage']['253'], 'http') === FALSE) ? e_BASE : '').$pref['frontpage']['253'].$query;

} else {

        $location = ((strpos($pref['frontpage']['252'], 'http') === FALSE) ? e_BASE : '').$pref['frontpage']['252'].$query;

}



// handle redirect and include front page methods

if(isset($pref['frontpage_method']) && $pref['frontpage_method'] == "include") {

        if($location == "news.php") {

                require_once("news.php");

        } elseif ($location == PLUGINS_DIRECTORY."forum/forum.php") {

                require_once($PLUGINS_DIRECTORY."forum/forum.php");

        } elseif (preg_match('/^page\.php\?([0-9]*)$/', $location)) {

                $e_QUERY = preg_match('/^page\.php\?([0-9]*)$/', $location);

                require_once("page.php");

        } else {



                  header("Location: {$location}");

                exit();

        }

} else {

        list($page,$str) = explode("?",$location."?"); // required to prevent infinite looping when queries are  used on index.php.

        if($page == "index.php") // Welcome Message is the front-page.

        {

              require_once(HEADERF);

                 require_once(FOOTERF);

                  exit;

        }

        elseif($page != "index.php") // redirect to different frontpage.

        {

                header("Location: {$location}");

        }



        exit();

}



?>

help with if ( ) statement

msnhockey — Fri, 03 May 2013 21:22:25 GMT

Below I have some code that I am trying to fix within the stuff I have colored red..

before I had the code like this if(($i == 4 || $i == 5 ) && !mysql_numrows($ssresult)){
and the $i == 4 and $i == 5 represent when a game goes into overtime and are only displayed if the game goes that far
$i == 4 is 1st Overtime and $i == 5 is 2nd overtime.

recently i had a game go into 3rd overtime but the code i originally had didn't allow for me to display that when the game went that far so i tried adding in $i == 6 for 3rd overtime and with the code below that is red it only shows the 1st overtime and 3rd overtime and skips the 2nd overtime..

been trying different things but not getting the right combo...also been looking at this thread http://php.net/manual/en/control-structures.if.php

Code:

 $player_scores = array();

$teams_scores = array(0, 0);

for($i=1;$i<=6;$i++){

        $ssresult = mysql_query("SELECT * FROM `goalinfo` WHERE gameid = '" . $id . "' AND goalperiod = '" . $i . "' ORDER BY goaltime");

        if($ssresult){



$test_ss = 1;

                

                if(($i == 4 || $i == 5 || $i == 6) && !mysql_numrows($ssresult)){

                        $test_ss = 0;

                        }

        if($test_ss == 1)

        {                

                switch($i){

                        case 1:$periodname = "1ST";break;

                        case 2:$periodname = "2ND";break;

                        case 3:$periodname = "3RD";break;

                        case 4:$periodname = "1ST OVERTIME";break;

                        case 5:$periodname = "2ND OVERTIME";break;

                        case 6:$periodname = "3RD OVERTIME";break;

                        }

here are different things i have tried so far
if(($i == 4 || $i == 5 || $i == 6) && !mysql_numrows($ssresult)){

or

if(($i == 4 || $i == 5) && ($i == 6) && !mysql_numrows($ssresult)){

or

if(($i == 4) || ($i == 5) || ($i == 6) && !mysql_numrows($ssresult)){

or

if(($i == 4 && $i == 5 && $i == 6) && !mysql_numrows($ssresult)){

webid php error help

ianhaney — Fri, 03 May 2013 17:50:58 GMT

Hi

I am using webid for a website I am doing for a customer and have added some extra fields to the sell item page and just before I submit it, the data I entered is not showing up in the confirm listing bit and was wondering if anyone could point me in the right direction, I did check the error log and found this but am bit unsure what to change or alter

PHP Parse error: syntax error, unexpected ')', expecting '&' or T_STRING or T_VARIABLE or '$' in /home/sites/247autotrade.com/public_html/sell.php on line 551, referer: http://247autotrade.com/select_category.php

Below is line 551 from the coding

foreach ($system->SETTINGS['make'] as $key => $val)

That line is taken from the following

// MAKE
$TPL_make = '' . "\n";
foreach ($system->SETTINGS['make'] as $key => $val)
{
//$TPL_item_condition .= "\t" . '' . "\n";
}
$TPL_make .= '' . "\n";

I have a screenshot if anyone needs to see the screenshot of the issue

mail() issues

harkly — Fri, 03 May 2013 14:21:29 GMT

I using this simple code to send a test message if I put in my url it won't send, more like it sends but never gets received no matter what email account I use. If I put in another url it works fine.

Does anyone know what causes that and how I can go about fixing it??

in this code I added a '2' to the url and it works, take the 2 out - nothing

PHP Code:


    mail('me@yahoo.com', 'Account Info', 'is this working? www.wlsingle2s.com');

?>

I am trying this code out on 2 different servers and it definity stops when I enter the one particular url - how do I check why?

[RESOLVED] Big Picture Question: Javascript in the grand scheme of things for a php/MySQL coder?

Joseph Sliker — Thu, 02 May 2013 20:26:12 GMT

Hi; This is a question for any of you who use Javascript a LOT as well as php...

With all the help I have gotten here over the years, I've gotten pretty comfortable creating MySQL databases and forms ad reports using php to feed and report from my tables.

I've been reading a Javascript book (thinking I might find some stuff that is easier/more efficient to do, using that language.) but so far, I keep thinking "Oh, I could do that with php by (blah, blah, blah) ..." but I suspect this is happening because I am only focused on the general concepts that I already understand.

Are there some things that you think are much easier/more efficient to do with Javascript? What are some things that are difficult or impossible to do with php that you CAN do with Javascript?

Thanks.

Parse error

Mad Max — Wed, 01 May 2013 21:57:58 GMT

Hi All,

Hope you're well.

I'm trying to code a bit of PHP for my website, though I must say I'm rather new to the whole thing. I followed a YouTube clip the results of which you've no doubt come across before as it contained an open-line error that has caused a lot of people problems. However, I've taken this and used it to develop three of scripts, none of which works for me due to a parsing error:

Quote:

Parse error: syntax error, unexpected T_VARIABLE [...] on line 38

Line 38 is

Code:

        $theResults = <<

 Here's the example of one of the codings, the solution to which will no doubt shed light on the other two.




	PHP Code:
	



/* Subject and e-mail variables */



    $emailSubject = 'Customer Request: Ask a Question';

    $webMaster = 'myemail@mydomain.co.uk';

    

/* Gsthering data variables */



    $titleField = $_POST['title'];

    $firstnameField = $_POST['first_name'];

    $surnameField = $_POST['surname'];

    $emailField = $_POST['email'];

    $daytimetelField = $_POST['daytime_tel'];

    $eveningtelField = $_POST['evening_tel'];

    $marketingsourceField = $_POST['marketing_source'];

    $messageField = $_POST['message'];

    $termsandconditionsField = $_POST['terms_and_conditions'];

    

    $body = <<



Title: $titleField 


First Name: $firstnameField 


Surname: $surnameField 



Daytime Telephone: $daytimetelField 


Evening Telephone: $eveningtelField 



Marketing Source: $marketingsourceField 


Accepts T&Cs: $termsandconditionsField 



Message:
 $messageField

EOD;



    $headers = "From: $email\r\n";

    $headers .= "Content-type: text/html\r\n";

    $success = mail($webMaster, $emailSubject, $body, $headers);

    

/* Results rendered as HTML */



    $theResults = <<

***Snip - this area contains the HTML code for the results which I've cut down for readability***



EOD;

echo $theResults;



?>


 I'm absolutely stumped. I've checked for rogue spaces or lines not closed properly but can't find anything - your help would be most gratefully received.



Kind regards,



Max



Add/remove input field and mysql.
3faces — Wed, 01 May 2013 12:02:54 GMT
How add one more input value and save same row database two values.

Like this: 

Name:

[Textbox1]

Values:

[Textbox2][textbox2] [add new]



[Submit]



Create new table in database and table name is "Textbox1" values.

And save that new table one row "textbox2" and "textbox3" values.



Thanks for help!