PHPBuilder.com - Coding

Displaying number of records in continuous manner in php paging

phpcodingfreak — Fri, 24 May 2013 07:24:21 GMT

I have a page which displays number of records on each page. I am displaying 5 records on each page and then next 5 on the next page and so on. Paging is working fine but the problem is on first page I'm displaying number serial wise next to each record i.e. from 1 to 5. Then on next page it should display numbers from 6 to 10 and on next page 11 to 15 and so on. But on every page numbers start from 1 to 5. My code is below. I have tried different strategies but nothing worked. Please check code and tell me where to make changes so that it works properly. Thanks a ton in advance.

PHP Code:


 

     

        echo $resource->_pageHead; ?> 

        ->displayMessage(); ?> 

                    if($resource->_recordCount > 0) 

            { 

        ?> 

             

                 

                     

                         

                            Sr. No. 

                            Name 

                            Email 

                            Address 

                            City 

                            State 

                            Phone Number 

                            Country 

                            Comment 

                            Inquiry Date 

                            Action 

                         

                     

                     

                                            $i = 1; 

                        $_SESSION['number'] = $i; 

                        $perpage = 5; 

                        $q = mysql_query("SELECT * FROM $resource->_table"); 

                        $total_record = mysql_num_rows($q); 

                        $pages = ceil($total_record/$perpage); 

                        $page = (isset($_GET['page']))?$_GET['page']:1; 

                        $start = ($page-1) * $perpage; 

                        $result = mysql_query("SELECT * FROM $resource->_table LIMIT $start, $perpage"); 

                        while($res = mysql_fetch_array($result)) 

                        { 

                    ?>       

                             

                                echo $i; ?> 

                                echo $res['name']; ?> 

                                echo $res['email'];?> 

                                echo $res['address'];?> 

                                echo $res['city'];?> 

                                echo $res['state'];?> 

                                echo $res['p_code']."-".$res['p_num'];?> 

                                echo $res['country'];?> 

                                echo substr($res['comments'], 0, 100);echo "...";?> 

                                echo $res['inquiry_date'];?> 

                                 

                                    echo $_SERVER['PHP_SELF'].'?action=delete&id='.$res['id'];?>" onclick="return confirm('Do you want to delete this record?');"> 

                                         

                                     

                                 

                             

                                                $i++; 

                        } 

            } 

                    ?>

 

             

                                    $prev=$page-1; 

                    $next=$page+1; 

                    if($prev > 0) 

                    { 

                        echo "$prev'>Prev"; 

                    } 

                    echo "  "; 

                    if($pages >= 1 AND $page <= $pages) 

                    { 

                        for($x=1;$x<=$pages;$x++) 

                        { 

                            echo "  "; 

                            echo ($x==$page) ?"$x style=\"font-weight:normal;\">$x":'.$x.'" >'.$x.''; 

                        } 

                        echo "  "; 

                        if($page<$pages) 

                        { 

                            echo "$next'>Next"; 

                        } 

                    } 

                ?>

Good algorithm for reading tokens from a string

metalmario — Fri, 24 May 2013 01:26:33 GMT

Hi all,

i'm writing a custom code to export a CSV file of products in a database. Here is the idea:
1) A textfield in the web page. It will contain user's choices.
2) A list of allowed tags
3) Unknown separators

Assuming that my database contains only a product(Chair),if user writes :

tag_stock|tag_productname|tag_category

the CSV file will contain :

2|Chair|Furniture

Obiviously, it should be done for every product in my database.
For example, a full CSV file should contain:

2|Chair|Furniture|10|Hammer|Tools|10|Sickle|Tools|... and so on

User defined order must be respected.

The algorithm i thought is something like this

$ops = array("product","chair","furniture") //contains the order of the tags read from the string

foreach(product of my catalog) {
for(i = 0 ; i< ops.lenght ; i++)
Read ops[i]
Execute function contained in ops[i]
}

So here are my questions
1) How can i read multiple tokens sequencely from a string?
2) Is there a way to invoke a function by reading the name from a variable?

Thank you very much. Hints or advices are well accepted :D

simplexml_load_file has begun throwing Max Exec Time error

schwim — Wed, 22 May 2013 12:05:47 GMT

Hi there everyone,

I've got a membermap in which the guys input their address and Google converts it to lat and long and the pin is set. Recently, the geolocation portion of the map has broken. No matter what address is input, the return is:

Quote:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/husaberg/public_html/includes/functions.php on line 67

Here's the function:

Code:

function geocode($address)

{

  $address = urlencode($address);

  $url = "http://maps.googleapis.com/maps/api/geocode/xml?address=$address&sensor=false";

 

  $coords = array('lat' => 0, 'lng' => 0);

  $delay = 0;

 

  $geocode_pending = true;

 

  // load file from url

  while($geocode_pending)

  {

        try

        {

          $xml = simplexml_load_file($url);  // This is line 67.

        }

        catch(Exception $e)

        {

          // return an empty array for a file request exception

          return array();

        }

   

        //get response status

        $status = $xml->Response->Status->code;

   

        if (strcmp($status, '200') == 0)

        {

          $geocode_pending = false;

         

          // get coordinates node from xml response

          $coordsNode = explode(',', $xml->Response->Placemark->Point->coordinates);

          $coords['lat'] = $coordsNode[1];

          $coords['lng'] = $coordsNode[0];

        }

   

        // handle timeout responses and delay re-execution of geocoding

        else if (strcmp($status, 620) == 0)

        {

          $delay += 100000;

        }

   

        usleep($delay);

  }

  return $coords;  

}

I've tried to troubleshoot and although haven't figured out the problem, I've gotten the output on the steps leading up to line 67. Everything seems to be working correctly up to line 67. The URL being passed is:

http://maps.googleapis.com/maps/api/...k&sensor=false

and if you visit the page, you can see that it is returning an xml document. I just don't know why line 67 ( $xml = simplexml_load_file($url); ) just began resulting in error.

While trying to troubleshoot my issue, I saw that this result could also be passed via json as well, but I'm not savvy enough to convert the function to use it, or even to know if that would resolve my issue.

Any thoughts on my issue or a potential workaround would be greatly appreciated!

modifying shoutbox to add an archive

anarchoi — Wed, 22 May 2013 07:32:06 GMT

I have installed a wonderful php/jquery shoutbox, but it lacks an archive function. So i am trying to modify the script to add each message to the database once it is posted.

I edited the addMessage function and added a database query:

Code:

        function addMessage($user, $msg, $color) {

                $user = $this->checkUsername($user); if($user===false) { return $this->jsonEncode(array('error'=>'You cannot use that name!')); }

                if(strlen(utf8_decode($user)) > 100) { return $this->jsonEncode(array('error'=>'Your name is too long!')); } $msg = utf8_encode(addslashes(strip_tags($msg)));

                if(strlen($msg) > 500) { return $this->jsonEncode(array('error'=>'Your message is too long! Limit 500 characters.')); }

                if((empty($user)) || ($user=='Your Name')) { return $this->jsonEncode(array('error'=>'Please enter your name!')); }

                if((empty($msg)) || ($user=='Message')) { return $this->jsonEncode(array('error'=>'Please enter a message!')); }

                if($this->isBanned($_SERVER['REMOTE_ADDR'])===true) { return $this->jsonEncode(array('error'=>'You are banned from this ShoutBox.')); }

                if((empty($_SESSION['ShoutCloud-User'])) || (!isset($_SESSION['ShoutCloud-User'])) || ($_SESSION['ShoutCloud-User']!==$user)) { $_SESSION['ShoutCloud-User'] = $user; }

                if((empty($_SESSION['ShoutCloud_Tag_Color'])) || ($_SESSION['ShoutCloud_Tag_Color']!==$color)) { $_SESSION['ShoutCloud_Tag_Color'] = $color; }

                $allMsgs = unserialize(file_get_contents($this->msgsFile)); if(empty($_SESSION['ShoutCloud-User-Flood'])) { $_SESSION['ShoutCloud-User-Flood'] = 0; }

                if($_SESSION['ShoutCloud-User-Flood'] > time()) { return $this->jsonEncode(array('error'=>'Please do not spam the messages! Wait 5 seconds in between posts.')); } $_SESSION['ShoutCloud-User-Flood'] = time() + 5;

                $allMsgs[] = array('time' => time(), 'user' => $user, 'msg' => $msg, 'color' => $color, 'ip' => $_SERVER['REMOTE_ADDR']); $totalMsgs = count($allMsgs);

                if($totalMsgs > 100) { $difference = ($totalMsgs - 100); $i=1; $allMsgs = array_reverse($allMsgs, true); while($i <= $difference) { $remove = array_pop($allMsgs); $i++; } $allMsgs = array_reverse($allMsgs, true);

                } else { $difference = 0; } $msgFile = fopen($this->msgsFile, 'w');

                if(fwrite($msgFile, serialize($allMsgs))) {

                                $dbtime = time();

                                $dbhost = 'localhost';

                                $dbname = 'pirate_piratepunk';

                                $dbuser = 'pirate_pirate';

                                $dbpasswd = '******';

                                mysql_connect($dbhost, $dbuser, $dbpasswd) or die(mysql_error());

                                mysql_select_db($dbname) or die(mysql_error());

                                $query = "INSERT INTO 1tchat (shout, user, time) VALUES ('$msg', '$user','$dbtime')";

                fclose($msgFile); return $this->jsonEncode(array('status' => 'posted'));

                } else { fclose($msgFile);

                return $this->jsonEncode(array('error'=>'Your message could not be posted at this time.')); }



        }

But nothing is being added to the database. What did i do wrong ?

Full php script:
http://www.pirate-punk.net/tchat/shoutcloud.txt

Javascript:
http://www.pirate-punk.net/tchat/sho.../ShoutCloud.js

Live shoutbox:
http://www.pirate-punk.net/tchat/tch...forumuser=test

Help! PHP and mySQL

jcoder93 — Tue, 21 May 2013 22:39:47 GMT

I have a simple form here:

HTML Code:

"post" enctype="multipart/form-data" action="php/uploadFile.php">



                                                "hidden" name="MAX_FILE_SIZE" value="2000000">

                                                Select File From Your Computer:


                                                "userfile" type="file" id="userfile">


                                                Declare Product Type: 


                                                "product" type="text" id="product">




                                                "upload" type="submit" class="box" id="upload" value=" Upload ">

Here is the uploadfile.php:

PHP Code:


$uploadDir = '../img/products/';



if(isset($_POST['upload']))

{

$fileName = $_FILES['userfile']['name'];

$tmpName = $_FILES['userfile']['tmp_name'];

$fileSize = $_FILES['userfile']['size'];

$fileType = $_FILES['userfile']['type'];

$protype = $_POST['product']['product'];

$filePath = $uploadDir . $fileName;

$result = move_uploaded_file($tmpName, $filePath);

}



if (!$result) {

echo "Error uploading file";

exit;

}



// Create connection

$con = mysql_connect("localhost","root","open4you");

       mysql_select_db("products");



// Check connection

if (mysqli_connect_errno($con))

  {

  echo "Failed to connect to MySQL: " . mysqli_connect_error();

  }



if(!get_magic_quotes_gpc())

{

$fileName = addslashes($fileName);

$filePath = addslashes($filePath);

}



$query = "INSERT INTO productimages (name, size, type, path, product ) ".

"VALUES ('$fileName', '$fileSize', '$fileType', '$filePath', '$protype')";



mysql_query($query) or die('Error, query failed : ' . mysql_error());



mysql_close($con);





echo "
Your Files Were Uploaded
";



}

?>

When running this code, everything works and writes to the database and file location. However, the products field does not write and I receive an error that states:
Undefined index: product in C:\wamp\www\2CO960\php\uploadFile.php on line 10
Any Ideas?

Any help would be greatly rewarded, with praise!

Replace all new lines with
and double new lines with
?

listenmirndt — Mon, 20 May 2013 09:37:30 GMT

Is it possible to replace any double new lines \n with a paragraph tag... while at the same time as replacing and single new lines \n with just a

?

thanks!

Facebook php api feed/ post 'from' parameter?

maxxd — Sun, 19 May 2013 11:22:11 GMT

Hey y'all - I've been looking all over the internet and can't find anyone talking about this, so I may just be crazy, but it appears to be happening. As of last week I had a php script working that would post to a Facebook page (business account) wall on behalf of another user (personal account) via our company app. I was using the 'from' parameter (an array with the Facebook user id and name of the submitter) and it was working perfectly. Suddenly, it seems as though Facebook is not recognizing the 'from' array parameter and the posts are going on to the page wall from the business account.

The script worked as expected on Wednesday of last week, didn't work of Friday and I'm pretty sure nothing changed in the script. Anyone else finding the same or similar behavior or know of a development roadmap announcement that I missed that could explain the difference in behavior? Even knowing that existing scripts are still working as expected would be much appreciated.

Time limitation Function in PHP

realcoder — Sun, 19 May 2013 07:00:54 GMT

Hi everyone
i am working with Time limitation in php and i am new with time function
i want that i can limit someone action for sometime.
Mean if user login first time he has to post(or some other action) within 24 hours otherwise his account will block.
and when he post his time start again from beginning mean again he got 24 hours for next action.

and i also want to limit just one post in 24 hours ...

Please guide me if someone has work with time or know about this

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

    

    }

    }

    }

    }

?>

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!

"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,

Parse error: syntax error, unexpected T_STRING

cimanyenje — Mon, 13 May 2013 04:35:13 GMT

I have this code which I want to show the records of a table and it's giving me a "Parse error: syntax error, unexpected T_STRING", it's saying the error is on this line;

echo "Student NameAddressPhone NumberReg-Number\n";
but I cant see it. what is the problem.

PHP Code:


$db = mysql_connect("localhost", "root");

mysql_select_db("membership",$db);

$query = "SELECT  * FROM members;

$result = mysql_query($query) or die(mysql_error());

if ($mycolumn = mysql_fetch_array($result)) {

echo "<table border=1 align=center cellspacing=0\n";

echo "<tr><th align=left>Student Nameth><th align=left>Addressth><th align=left>Phone Numberth><th align=left>Reg-Numberth>tr>\n";

do {

printf("<tr><td>%s %s %std><td>%std><td>%std><td>%std><td>%std><td>%std>tr>\n",  $mycolumn["title"], $mycolumn["firstname"], $mycolumn["lastname"], $mycolumn["address"],

$mycolumn["phonenumber"], $mycolumn["regnumber"]);

} while ($mycolumn = mysql_fetch_array($result));

//echo "<BR>";

echo "<h3>REGISTERED MEMBERSh3>";

echo "<BR>";

echo "table>\n";

} else {

echo "Sorry, no records were found!";

}

?>

PHPBuilder.com - Coding

Displaying number of records in continuous manner in php paging

echo $resource->_pageHead; ?>

Good algorithm for reading tokens from a string

simplexml_load_file has begun throwing Max Exec Time error

modifying shoutbox to add an archive

Help! PHP and mySQL

Replace all new lines with and double new lines with ?

Facebook php api feed/ post 'from' parameter?

Time limitation Function in PHP

suggestions for control of cluster nodes by a master node?

Handling Paypal Buttons While Updating a Database

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

Trying to write a comment system, please give thoughts.

Formatting text file

"Interprocess" communication and serialized data ...

Parse error: syntax error, unexpected T_STRING

Replace all new lines with
and double new lines with
?