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
How to get out of paying ULEZ or similar chargesHow to send a postal cheque to lloyds bank plc
How to stop a form submitting when you press enter php
How to stretch an image in a td cell to cover the whole cell using css
How to make money from your website by doing very little
Quantum Command Phrases and Reality Restructuring
How to make a drop down box submit a form
How do i edit a facebook album name in a group
Visited link to remain same colour
The Quickest Ever Salt Dough Recipe
How to find my saved buttons on paypal
Using the power of fear to bring about a euromillions win
Does Salt and Water Cure Hayfever
A Beginners Guide to Fitness for Women Over 50
How to remove item specifics on ebay
Enable the hidden admin on windows 10
How do I block someone on facebook
What do you need help with in your business
Keep flies off your food this summer
Google ads for electricians in the UK
Create a file to upload pictures or files in php
Correlation doesnt equal causation
Instructions for tell the time galt game
How to make sure facebook picks up the correct picture from a website
Peanut allergy and what to do in an emergency
How to clear your skin of psoriasis
Buyer marked payment as sent when it has not been how do i remove this
What to say when someone asks where is your mask
100 ChatGPT Prompts for Small Business Owners
How to make first letter only captial using php.
How to stop google chrome downloading automatically
How to change your name on facebook