Category Archives: Tutorials
Force Your Script to Run Longer than Maximum Execution Time
So how does one go about forcing a script to stay alive infinitely until it eventually finishes its job?
Also posted in Technology & Code Tagged infinite execution, maximum execution time, PHP, set time limit, timeout 1 Comment
How to Convert an UTF-16 File to an UTF-8 file using PHP
Taking Andrew Walker's previously mentioned handy little UTF-16 to UTF-8 string converter function, we now have in our means a particularly easy way in which to craft a simple UTF-16 to UTF-8 file converter.
Also posted in Technology & Code Tagged andrew walker, convert, encoding, file convert, PHP, string, string encoding, utf-16, utf-8 Leave a comment
Inserting Backslashes into a Database Table with PHP
Sometimes you need to store things like file paths into a database table during your PHP script's execution. However, on going back to the database after running your script, you might come across your path with all of its backslashes (\) missing!
Getting the First Object Returned by a jQuery Selector
If for instance you have just used a jQuery selector to grab a whole lot of objects and now realize that in actual fact you only want to effect the first object that the selector returned to you, you can rest easy in the knowledge that jQuery as per usual has you covered.
Also posted in Technology & Code Tagged :first, eq(0), first element, jQuery, selector, tutorial Leave a comment
SQL: Finding all Duplicate Records in a Table
Sometimes it is quite handy to see which records based on a particular key appear more than once in a database. The trick here is that we are focusing on a particular column and deeming that should that particular key appear more than once in the table then we have a duplicate scenario.
Posted in Tutorials Tagged duplicate, duplicate records, duplicate values, query, records, sql Leave a comment
SQL: Return all the Names when you have all the IDs
I have all the ID values for wildlife parks but instead of displaying the ID values I want to display the park names. These are stored in a table that has two fields, namely ID and the corresponding display name.
Also posted in Technology & Code Tagged in, sets, single select, sql, sql statement, tutorial Leave a comment
Photoshop: Text Tool Keyboard Shortcuts