PHP MySQL Tips | Paul Cracknell

PHP to limit a text string to a number of words

Recently I had cause to show an excerpt of information which would then link to another page for the complete article. I had to show a limited number of words from the entire article as a teaser. I managed to do this with a little function. function limit_words($string, $word_limit) { $words = explode(" ",$string); [...]

02Dec '12 3

PHPmyAdmin importing csv file to MySql database

In: PHP MySQL Tips/By: admin/1 Comment/

This is pretty easy once you work out a couple of the idiosyncrasies involved in the process. These are my tips to help if you are experiencing difficulties. 1. When you develop your excel file save it out as a csv file. This means do not save it as a work book or any other [...]

06Nov '12 0 Be the first to like this.

PHP Here Doc

In: PHP MySQL Tips/By: admin/0 Comment/

The Here Doc is most useful when you have a long string with many double quotes that need to be escaped by a backslash. $pix .= ("<li><input type="checkbox" name="picture[]" value="'. $root.$dir.' '.$file.'" /> Value One</li>"); The same string with a “Here Doc”. $pix = <<<END ("<li><input type="checkbox" name="picture[]" value="'. $root.$dir.' '.$file.'" /> Value One</li>") END; [...]

02Nov '12 3

PHP loading multiple checkbox input into separate rows in MySql

In: PHP MySQL Tips/By: admin/0 Comment/

Some time back now, in an image gallery I was developing, I had a folder with images the directory that had not been added to the database. To add the selected images by the user I decided to use checkboxes. Each selected box represented the path to where the images was stored. This is the [...]

30Oct '12 0 Be the first to like this.

Validating an email address with PHP

In: PHP MySQL Tips/By: admin/0 Comment/

Dodgy email addresses from people can be a problem but not any more with this little function that checks an email address with regular expression. Here is the code, call it from within your script. $checkEmail = info@example.com echo validEmail($checkEmail); function validEmail($email){ // Valid Email address Regular expression // No spaces in [...]