It’s probably been in every PHP ‘test’ going and is a very commonly asked question, but it’s something I’ve never covered here at Return True before. So what exactly is the best way to insert data into a MySQL table from a CSV file? Well I can’t say these are the best ways, but here are two ways I’ve come […]
Read moreThis third part of explaining how to use PHP & MySQLi was inspired by ‘abr4xas’ who commented on part 2 of this tutorial. He/she asked how they would go about safely inserting data from the $_POST superglobal into one of their MySQLi queries. So here is how to do exactly that. Prepared Statements One of the best ways to use […]
Read more
Using WordPress for websites that aren’t just weblogs means the need to modify WordPress more & more. Recently I was asked to change the order of the posts displayed when using the post link functions.
Read moreA tricky subject I came across recently was how to use Triggers in a MySQL database. I always stayed away from them as I thought they were difficult to work with, but it turns out they are much easier than I expected.
Read moreFollowing on from the last tutorial, we are going to take a look at how to assemble some slightly more complex queries to filter the results from our many to many relationships.
Read moreA fairly difficult subject to approach in MySQL is Many to Many relationships. The queries can be complicated and the data sets huge, but as it seems to be covered by tutorials very little I thought I’d have a shot a writing a tutorial about it.
Read moreI have had a few questions recently asking what sub queries are and how they are used. While there are a number of articles out there on the subject they don’t explain it in a detailed manner as I would like. So here is my take on them.
Read moreI originally wrote a post about 2 year ago explaining how to store multiple values in a single MySQL row. Now I have more experience with PHP/MySQL I have decided to revisit this topic to clear up any confusion about the method that should be used.
Read moreContinuing on from the last post which covered the basics of connecting to a database using MySQLi, we are going to look at inserting, updating & deleting data. Finally we are going to look at some of the miscellaneous features of MySQLi.
Read moreA 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.
Read more
Recent Comments