search



  

Latest 5

Invisible Google Captcha
Posted: 2017-11-10 12:51:42
Font Awesome
Posted: 2017-10-25 01:25:14
PHP Filemtime() Function - Last Updated
Posted: 2017-10-14 14:43:44
Google Charts & Tables
Posted: 2017-09-30 01:05:31
Livre De L'eleveur Griffonnier 1988
Posted: 2017-09-15 09:09:35

Top 5

AKC Stud Book - Scans available
Posted: 2017-04-13 18:23:54 (1984 Reads)
Norwegian Kennel Club Database
Posted: 2015-10-22 10:36:06 (1512 Reads)
ENCI - Italian Studbook
Posted: 2015-10-26 09:54:35 (1348 Reads)
LOSH (Belgium) Scans Available
Posted: 2017-04-29 19:47:07 (1292 Reads)

Join our Newsletter

to get informed about new blog entries!
We care about your privacy - we do not send our Newsletters to all registered users, only if you subscribe HERE!
* indicates required
Choose your Category/Categories

Facebook


Ask for becoming a member of the closed group: Dog Pedigree Databases/Research

The Pedigree Cloud - SQL

All Tags
Google Charts & Tables

Present your data in a beautiful way with Google Charts - no additional software needed, just a little bit of code writing...


MySQL DATE_FORMAT()
SELECT CURDATE();   2017-08-31
With DATE_FORMAT() you can choose the way the date and/or time is shown in mySQL - some examples here, the complete list is shown below:

like and not like in php

Building an if statement in php with 'like' or 'not like' as an operator, the syntax is different to the on in SQL.


Backup your database

I hope that you all backup your databases regularly, and with regularly I mean at least once a day. Those data are too valuable to get lost.
I have been using MySQLDumper for years, a PHP and Perl based tool for backing up MySQL databases and I really loved it. Now with PHP 7 it stopped working properly and the developer decided to stop the work on that project.
So not wanting to make a dump every day manually from the phpAdmin surface, I wrote a php file which runs as a cronjob on my server.
Feel free to use and/or modify the code!


SQL Capitalize String

Do you have members who enter the dog's or person's name in Capitals?
Here is a code that works to make the first letters of each word uppercase.
Example:
ANNABELLE MISS OF SETTERCITY
Annabelle Miss of Settercity


SQL Update Part of a String

You want to update a part of a string in SQL, e.g. you want to change all registry numbers that include "N.H.S.B." to "NHSB"


SQL Update Column

You want to update a complete column in SQL, e.g. you want to change the country code for Great Britain from "GB" to"UK"


SQL TRIM, LTRIM, RTRIM

The TRIM function is used to remove a defined prefix or suffix from a string. If nothing is specified, white spaces are removed.


Render time: 0.11 seconds
208,638 unique visits