background preloader

Mysql

Facebook Twitter

10 Exceptional WordPress Hacks. Advertisement One of the reasons people love WordPress so much is its great flexibility.

10 Exceptional WordPress Hacks

You can change the software’s appearance with themes. You can enhance its functionality with plug-ins. And, last but not least, you can totally unleash WordPress’ power with hacks. Some time ago, we wrote a post showing 10 Killer WordPress Hacks1. Today, let’s do it again with 10 new and totally killer WordPress hacks to make your blog stand out from the crowd. You may be interested in the following related posts: 1. The problem. The solution. Code explanation. Animated Ajax Record Deletion Using jQuery. I'm a huge fan of WordPress' method of individual article deletion.

Animated Ajax Record Deletion Using jQuery

You click the delete link, the menu item animates red, and the item disappears. Here's how to achieve that functionality with jQuery JavaScript. The PHP - Content & Header The following snippet goes at the top of the page: if(isset($_GET['delete'])) { $result = mysql_query('DELETE FROM my_table WHERE item_id = '. The following is used to display the records: $result = mysql_query('SELECT * FROM my_table ORDER BY title ASC',$link);while($row = mysql_fetch_assoc($result)) { echo '<div class="record" id="record-',$row['item_id'],'"><a href="? The jQuery JavaScript For every link, we add a click event that triggers the AJAX request. How would you use this? Be Heard. 40+ Invaluable PHP Tutorials and Resources - Nettuts+

jQuery, Ajax, Json and Php. Modified Preorder Tree Traversal Component (Articles) Storing Hierarchical Data in a Database [PHP &amp; MySQL Tutoria. Now, let’s have a look at another method for storing trees.

Storing Hierarchical Data in a Database [PHP &amp; MySQL Tutoria

Recursion can be slow, so we would rather not use a recursive function. We’d also like to minimize the number of database queries. Preferably, we’d have just one query for each activity. We’ll start by laying out our tree in a horizontal way. Start at the root node (‘Food’), and write a 1 to its left. We’ll call these numbers left and right (e.g. the left value of ‘Food’ is 1, the right value is 18). Before we continue, let’s see how these values look in our table: Note that the words ‘left’ and ‘right’ have a special meaning in SQL. Retrieve the Tree If you want to display the tree using a table with left and right values, you’ll first have to identify the nodes that you want to retrieve.

SELECT * FROM tree WHERE lft BETWEEN 2 AND 11; That returns: Well, there it is: a whole tree in one query. SELECT * FROM tree WHERE lft BETWEEN 2 AND 11 ORDER BY lft ASC; The only problem left is the indentation. <? The Path to a Node. Macdiggs.com » Blog Archive » Integration of Spry and PHP/MySQL. Adobe have recently released its Spry Ajax framework for public beta-test by developers and I've been playing with this baby for a while.

macdiggs.com » Blog Archive » Integration of Spry and PHP/MySQL

And here's some kind of report of what I have learned. Spry is Adobe's Ajax library for manipulating XML data. ProQuest Information and Learning - 0131867164 - core WEB APPLIC. The programmer's Guide to building robust web applications with PHP and MySQL This is a comprehensive, practical guide for programmers who want to develop production-quality, database-enabled web applications with PHP and MySQL.

ProQuest Information and Learning - 0131867164 - core WEB APPLIC

Long-time developer Marc Wandschneider systematically addresses the entire process: not only coding, but also upfront application, user interface and database design, PLUS security, testing, and more. You'll walk through building three applications from start to finish: a calendaring system, a weblog engine, and an e-commerce store. Along the way, you'll master essential strategies for creating robust web database applications and learn how to avoid the common pitfalls that trip up many developers moving to PHP and MySQL. Announcing Payjacks, an Object-Oriented PHP/Ajax Web Application.

I am happy to announce the immediate availability of Payjacks, currently at version 0.2.0.

Announcing Payjacks, an Object-Oriented PHP/Ajax Web Application

Payjacks is a PHP/Ajax web application framework I’ve written using the object-oriented features in PHP5+. Payjacks can be downloaded here: What is Payjacks? Payjacks is an object oriented PHP-Ajax web application framework I’ve written to help write robust and organised web applications. It was designed to require a minimal amount of effort to get your own web application up and running, while helping with such tasks as accessing a (MySQL, currently) database or providing a framework for sending asynchronous Ajax requests back to the server. Payjacks uses many of the new object-oriented features in PHP 5 to do its work, and handles most of the details required to run a robust web application. Some of the main features are: Fully object-oriented. Flashcomguru.com: &#039;Streaming&#039; flv video via PHP, take. Following a really interesting thread on the chattyfig Flashcomm list I have now been able to put together a simple video player which is capable of requesting and playing parts of a flv video file that have not previously been downloaded.

Flashcomguru.com: &#039;Streaming&#039; flv video via PHP, take

PerlHP - A travesty. Introduction PerlHP is an attempt to give Perl the same simplicity and hackiness that PHP has spent years trying to forget.

PerlHP - A travesty

It lets you put together simple dynamic web pages more quickly than writing them in plain Perl, and with less mental anguish than writing them in PHP. It is also cheerfully obfuscated, but luckily you don't need to actually look at it to use it. PerlHP started out as a joke, but it did turn out to be useful - for instance, I wrote this page using it.