How to return only part of a feild from database using php substr but to take into account spaces
I recently needed to get data from a mysql data base but only wanted to return the first 35 characters, but did not want it to cut off in the middle of a word so wanted to make sure that it checked for a space after that and cut off after that space.
Firstly though I had to check that there were enough characters otherwise it would return a false, also if the cutoff point was the last word it would also cut off as it would not find a space, so would return a blank, so in both cases I used the original text as that was fine.
Otherwise it then used the formula below, change len to be the number of characters you want to return. If you have a set number and cant exceed that number just make your $len about 15 lower than you want that should always return less.
Trending right now
Stop paying council tax and remove yourself from their databaseWhy Discipline Beats Motivation Every Time
How to stop people stealing your downloads when using paypal
How to get your child into rainbows brownies guiding scouts beavers when there is a waiting list
How to make sure facebook picks up the correct picture from a website
Promissory Notes and Bills of Exchange
How to stop google chrome downloading automatically
Modifying MS Word Normal.dot .dotm template
How to force a file to download simple
Easy and simple way to cut foam using something you already have in the house
I will bid on your ebay items to increase the price
Why Ditching the News Could Transform Your Mental Health
Why Blind Faith Leads to Catastrophe
What is the difference between Jam and peanut butter Joke on how i met your mother
How to find my saved buttons on paypal
How to get out of paying ULEZ or similar charges
How to flip rotate an image using css
Keep flies off your food this summer
Html apostrophe single quote quote mark
How to unblock a plug hole in your bath
Some things I am selling please have a look
How to stop bank scammers over the phone quickly and easily
How to mute keywords in twitter and hide them from your timeline
How to return only part of a feild from database using php substr but to take into account spaces
How to choose a domain name. Best practice for choosing a domain name.
Healing pneumonia with raw ginger
Why Letting Go is the Key to Scaling Your Business
How to write a good sales page
How to save money on electricity by using a magnet
Create a file to upload pictures or files in php
How to stop coughing quickly and easily
How to remove red wine stains from a carpet new or dried in
How to limit the number of records mysql produces
Foods to avoid during H pylori infection
The secret to getting your kids dressed in 5 minutes or less in the morning
Dhlpay.co.uk spam text email mob 07494431073
Miracles Will Happen For 24 hours after reading
What to say if the police have arrived with the bailiffs.
How to stop videos playing automatically in chrome
If not paying council tax was unlawful....
Visited link to remain same colour
11 Easy to make toys for your baby that they will love
List of Facebook groups that are good to advertise your business on in the UK
What different Text Ads Types are available for Google ADWORDS