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
Boost your business Promote your site here for freeDhlpay.co.uk spam text email mob 07494431073
How to stop text enhance pop ups showing on webpages.
Natural Remedies and Dietary Approach for Psoriasis
Why Blind Faith Leads to Catastrophe
The Hidden Question That Tricks Your Brain Into Attracting Massive Wealth Effortlessly
The Hidden Question That Tricks Your Brain Into Attracting Massive Wealth Effortlessly
Parking charge Notice by private car parks not council.
Excellent Snacks to have on the carnivore diet
If Your Friends Jumped Off a Bridge Would You
How to find my saved buttons on paypal
Are you a commercial electrical company
Instructions for tell the time galt game
How to stop people stealing your downloads when using paypal
Quantum Command Phrases and Reality Restructuring
How to make a drop down box submit a form
Why do people actually sell on ebay
How to return only part of a feild from database using php substr but to take into account spaces
Why Ditching the News Could Transform Your Mental Health
Some things I am selling please look through thank you
How to get scammers off the phone and have some fun
Drop down list of towns and cities in England
How Niching Down Your Product Can Skyrocket Your Profits
The Hidden Truth That Ends All Loneliness Forever
Why Mastering One Skill Is Your Fastest Path to Financial Success
Why Your Prescription Drugs Might Be Hiding the Real Problem
Why You Should Launch Your Business Now and Ditch the Quest for Perfection
How to relieve cure a sore throat
6 weeks to achieve your goal chart.
How to get rid of an infestation of wasps or bees or actually any flying insects
Why Nothing Seems to Work Out and How to Turn Your Life Around
Climate change is it real or made up.
Master the Art of Saying No Without Guilt
My child is being bullied at school
What do you need help with in your business
Delete Remove a file from your sever using php
Enable the hidden admin on windows 10