NoSQL DEFINITION: Next Generation Databases mostly addressing some of the points: being non-relational, distributed, open-source and horizontal scalable. The original intention has been modern web-scale databases. The movement began early 2009 and is growing rapidly. Often more characteristics apply as: schema-free, easy replication support, simple API, eventually consistent / BASE (not ACID), a huge data …
Category Archives: MySQL
PHP Mysql Search Sctipt
<?php $hostname_logon = “localhost” ; $database_logon = “” ; $username_logon = “” ; $password_logon = “” ; $connections = mysql_connect($hostname_logon, $username_logon, $password_logon) or die ( “Unabale to connect to the database” ); mysql_select_db($database_logon) or die ( “Unable to select database!” );
Retrieving Records from Multiple Tables
It does no good to put records in a database unless you retrieve them eventually and do something with them. That’s the purpose of the SELECT statement—to help you get at your data. SELECT probably is used more often than any other in the SQL language, but it can also be the trickiest; the constraints …
Concatenate and NULL/Blank fields
CONCAT() and RTRIM() both return NULL if any of their arguments are NULL. So CONCAT(‘xyz’, NULL) returns NULL. RTRIM(NULL) returns NULL. CONCAT(‘xyz’, NULL, ‘123’) returns NULL. coalesce(FIELD, ‘—‘)
Mysql insert string
For starters, you should just use mysql_real_escape_string when inserting into the database – this will ensure that whatever you store is safely encoded, yet retains all of the original information. In terms of output, the key difference between htmlentities and htmlspecialchars is that htmlentities will convert all characters that have entities whereas htmlspecialchars will only convert <, >, …
Execute a database backup query from PHP file