Archive | MySQL
PHP Mysql Search Strategies
Posted on 02 June 2011.
Databases
Below is a short list of available databases and a brief description. These are the most commonly used databases. If searching for translations to a specific word or phrase, please select the appropriate database as not all databases are searched by default.
Posted in MySQL, PHP0 Comments
PHP: Multi-word MySQL Search
Posted on 21 April 2011.
Here we have a simple PHP search algorithm that queries a MySQL database and outputs the result. It is a simple alternative to using the FULLTEXT search feature of MySQL.
The script autmatically takes into consideration how many search words are in the search string which is submitted from the HTML search form. It then creates a MySQL query and executes it, displaying the results. You can easily edit the fields that the search script searches by changing the values in the$arrayFields array.
Posted in MySQL, PHP2 Comments
mysql sum if
Posted on 14 April 2011.
In today’s quick tip screencast, we’re going to learn a MySQL query trick. You might be already familiar with the SUM() and IF() functions. We will be combining them to come up with some useful queries. This can reduce the number of queries you need to run for fetching certain types of summary data, and also provide a performance improvement.
Posted in MySQL0 Comments
PHP’s sprintf() on a MySQL query utilizing DATE_FORMAT()
Posted on 07 April 2011.
So what’s the solution? You have to “comment-out” the % that aren’t part of your sprintf() substitution. You can do this by putting another % in front of the ‘%’ symbols in the DATE_FORMAT() function. This deems them as a literal percent-sign instead of the start of another sprintf() “variable”.
Posted in MySQL, PHP0 Comments
Real-World OOP With PHP and MySQL
Posted on 24 March 2011.
Numerous examples from robots to bicycles have been offered as “easy” explanations of what OOP is. I’ve opted to show you how OOP works with a real-life example, for a programmer. By creating a MySQL CRUD class you can easily create, read, update and delete entries in any of your projects, regardless of how the database is designed.
http://net.tutsplus.com/tutorials/php/real-world-oop-with-php-and-mysql/comment-page-1/#comments Continue Reading
Posted in MySQL, PHP0 Comments
Easy Access With PDO CRUD
Posted on 24 March 2011.
Abstract
The term CRUD refers to the four basic functionalities used in most PHP applications.
Posted in MySQL, PHP0 Comments
MySQL Scheduler
Posted on 17 February 2011.
From the release of MySQL 5.1.6 comes the inclusion of a scheduler. The scheduler, as the name suggests, schedules tasks within the database in the same way as triggers. In fact, the scheduler is just that, a temporal trigger. Many of the tasks assigned to the scheduler have been run from cron, but not everybody has access to cron or the windows task scheduler. The MySQL scheduler is not a replacement for these tools as some tasks with PHP scripts need to employ other, non database, events.
Getting Started Continue Reading
Posted in MySQL0 Comments
-
Tom: Thanks really useful tutorial. I also found that ...
-
web hosting pakistan: Hai, just visiting around. Build your blog soon. I...
-
nikmauro: To fix the problem and restore behaviour to how it...
-
DSP: Whats up very cool website!! Man .. Beautiful .. A...
-
patis: me liga logia paragoume ta klidia tou server pou t...
.htaccess
action script
ajax
api
array
as2
as3
cache
class
CSS
development
editor
facebook
Flash
form
function
google
greek
html
html5
illustrator
image
ipad
iphone
javascript
JavaScript - Ajax
jquery
Linux
list
MAC
mail
mootools
MySQL
photoshop
PHP
Plesk
programming
prototype
scripting
seo
spam
TinyMCE
video
widget
wp
Stay up to date
- Subscribe to the RSS feed
- Subscribe to the feed via email
Wedstar.gr
- Mallioras Group
- White Angel
- Tent Style
- Δήμητρα Κορμέντζα Creations Κόσμημα February 11, 2011
- DONATI LTD January 8, 2011
Advertisers
