Using PHP & MySQLi With A MySQL Database Part 1
Learning how to connect to a MySQLi database is pretty much an essential part of learning PHP in today’s database heavy web development scene. Here is a small tutorial to teach just how it’s done.
Learning how to connect to a MySQLi database is pretty much an essential part of learning PHP in today’s database heavy web development scene. Here is a small tutorial to teach just how it’s done.
XML is used for all types of thing, one of the most commonly known is for RSS feeds. Using PHP & SimpleXML you can parse that feed or any XML file to grab the data and manipulate it however you want. Here’s how it’s done.
A limitation with searches using MySQL is that when using LIKE to find the words queried it will only find them if they are together in the same order they were written. Here is how to change that so the words are found in any order.
In our last tutorial we created a script to connect to the Twitter API, collect our tweets & display them in some simple paragraphs. In this part we are going to add a very important part, file caching. This will stop our script from running out of API requests.
Showing your Twitter timeline, or even just your most recent status update, is becoming increasingly popular. Doing it on a WordPress blog is simple with plugins, but what if you want to do it on a non-WordPress website? Here’s how.
So you want to create an intelligent search for your website? By intelligent you are, of course, talking about the way Wikipedia sends you to the correct page should an exact match be found. Well you’re in luck, here is an easy way to do it using PHP & MySQLi.
Twitter is exceptionally popular for promoting your blog, or business. Having a Twitter social bookmark icon on your blog enables visitors, or even yourself to tweet the current blog article you are reading very quickly & easily. Here is how to create one.
With APIs such as Twitter’s becoming more & more popular connecting to a webservice or webpage in a script is now a common request. As such here is how to fetch a webpage via PHP using cURL.
Twitter Stream is a very simple Twitter plugin designed to easily show your Twitter timeline on your website. It features @reply & #tag highlighting, ‘time ago’ dates & customiseable CSS. Twitter Stream now includes retweet support.
Timthumb is an extremely popular thumbnail regeneration script, with built in caching. While it is an excellent script, it relies on GD which when combined with large images & a shared server is a disaster. Here is how to adapt timthumbs to work with ImageMagick.
It's late here in the UK but it's the 30th so a big Happy Birthday to @Y_Strahovski loads of hugs 'n kisses, hope you have a great day. - 9 hours ago
Wow! Jeffster are awesome and @Y_Strahovski has one hell of a throwing arm, lol. http://yfrog.us/n8b8xz (via @kentuckysocal) - 6 days ago
@AshBob87 No worries. Glad I could help out. ;) - 6 days ago
@AshBob87 No problem. I just found it a few seconds ago. Was sitting in my bookmarks all along. *facepalm* http://bit.ly/cI9cQS - 6 days ago
@AshBob87 Thanks. ;) I can't find the tutorial I followed anymore. :( - 6 days ago