php

Alternate markup for every 6 post - in wordpress

I want to put in and ad code after every 6 post on my blog. I cant really figure out how to break out of the foreach and insert the ad code. ...

Is there a way to send tracking info to Google Analytics from PHP ?

I have a PHP code that will return a image. the link is given to 3rd party. so, i need to keep track where the php request coming from. Because the PHP only return the image, I cannot use the Javascript code for Google analytics. I know that I can get the information from the access.log, but i think I can't dump the access.log to GA f...

PHP sql with foreach loop variable problem

This is really getting frustrating. I have a text file that I'm reading for a list of part numbers that goes into an array. I'm using the following foreach function to search a database for matching numbers. $file = file('parts_array.txt'); foreach ($file as $newPart) { $sql = "SELECT products_sku FROM products WHERE products_sku='...

Import CSV to mysql

I have created a database and table. I have also created all the fields i will be needing. I have created 46 fields including 1 that is my ID for the row. The CSV doesn't contain the id field, nor does it contain the headers for the columns. I am new to all of this but have been trying to figure this out. I'm not on here being lazy askin...

DomDocument::loadHTML() error during phpunit test execution

I am currently trying to write some unit test against my zend framework controller. When I run the following code I receive this error: public function testListActionShouldContainListTable() { $this->loginToSystem(); $uri = $this->_uriBase . 'campaign/list'; $_SERVER["REQUEST_URI"] = $uri; $this->...

Advanced MySQL Search Help

I've been trying to come up with something for a while now to no avail. My MySQL knowledge is rudimentary at best so I could use some guidance on what I should use for the following: I have 2 tables ('bible' and 'books') that I need to search from. Right now I am just searching 'bible' with the following query: SELECT * FROM bible ...

Regex match all newline characters within <p> in PHP

I have the following sample set of data: <p>first line\n second line\n third line\n</p> first line\n second line\n third line\n Using regex, how could I match on the newline characters, but only when they are within the paragraph tags. This code would be used within php. ...

php regexp: remove all attributes from an html tag

i have this html code: <p style="padding:0px;"> <strong style="padding:0;margin:0;">hello</strong> </p> but it should become (for all possible html tags): <p> <strong>hello</strong> </p> this is driving me crazy, is there a regexp expert that can give me a hand? thanks! ...

split a result list from mysql into separate lists based on list length

i have a list of returned rows from mysql that i am outputting using php: echo '<ul class="mylist">'; foreach ($rows as $row) { echo '<li><a href="'.$row->url.'" target="_blank">' . $row->title . '</a></li>'; } echo "</ul>"; works fine, but its a long list and i would like to split it into ul chunks ...

Is there a limitation to the length of the query in mysql?

I am asking this question because I need to know this limitation as I am generating SELECT query in my PHP script and the part of WHERE in this query is generated inside the loop. Precisely it looks like this $query="SELECT field_names FROM table_name WHERE "; $condition="metadata like \"%$uol_metadata_arr[0]%\" "; for($i=1; $i<count...

PHP - ___ encoding to UTF-8 - is there an end-all solution?

I've looked across the web, I've looked through SO, through PHP documentation and more. It seems like a ridiculous problem not to have a standard solution to. If you get an unknown character set, and it has strange characters (like english quotes), is there a standard way to convert them to UTF-8? I've seen many messy solutions using a...

Processing data from an AJAX request

I have a PHP API I'm working with that outputs everything as JSON. I need to call one of the API methods and parse it out using an AJAX request. I am using jQuery (though it shouldn't matter). When I make the request it errors out with a "parsererror" as the textStatus and a "Syntax Error: invalid label" when I make the request. Simpl...

Syncing JS+PHP time

Since the Date constructor is based on your PC's timezone and server-side is obviously dependent on the server's time settings... What procedures can I do to ensure that the timestamps I generate are consistent on both ends? I have a jQuery datepicker setup and I do a lot of work, I also have my own datepicker that's generated from ser...

Advanced PHP sessions

Hey everybody, i'm looking for an advanced tutorial about PHP sessions. With a deep understanding of how they works, avoiding to get into the PHP code. Thanks! ...

What is the best PHP blog script?

Please let me know What the best PHP blog script is. ...

change empty array element to a value

i have an array like this Array ([0]=>'some values'[1]=>'') I want to change the empty elemnt of an array to a value of 5 how can I do that thanks ...

php: remove <p>, </p>, <br> and <br /> from beginning and end of string

help... $chars = " \t\n\r\0\x0B"; $pattern = '('.implode('|',array_map('preg_quote',array('<p>','</p>','<br />','<br>'))).')'."\b"; $data = trim(preg_replace('~'.$pattern.'$~i','',preg_replace('~^'.$pattern.'~i','',trim($data,$chars))),$chars); That code is set to remove all <p>,</p>,<br> and <br /> from the beginning and end of a htm...

Quick and easy flood protection?

I have a site where a user submits a message using AJAX to a file called like.php. In this file the users message is submitted to a database and it then sends a link back to the user. In my Javascript code I disabled the text box the user types into when they submit the AJAX request. The only problem is, a malicious user can just consta...

PHP+GD creating random black thumbnails

Hello, This function is creating some random black images like.. 10% of the time, is not much, but.. you know.. shouldnt be happening. class ImgResizer { private $originalFile = ''; public function __construct($originalFile = '') { $this -> originalFile = $originalFile; } public function resize($newWidth, $targetFile) { if (empt...

Wordpress comments - perform simple math?

I have a Wordpress website in which one of the categories I've stripped the comments field down to basic whole numbers only. The logged in user can enter data on the post via the "comments" field, in basic simple whole numbers. Is there any way to take the MOST RECENT comment on all posts from that category (cat 1) and run basic math? ...