Sometimes you have to work on a subdomain on a WordPress site where you set your robots.txt to not to crawl it. Or you do work on your local machine. But when it’s finished…you’ll have to move it to the final domain. But how ? Here is a basic synopsis of what you need to...
MySQL Stored procedu...
posted by xav
Easy as pie hint. Sometimes in a development you need some business logic on the database side. In MySQL (just as in Oracle) you can use stored procedures and call them inside your application. It is like leaving some business logic to the database, and that business logic is executed on the...
Mysql Replace functi...
posted by xav
Here is a quicky to replace a string inside a column: update yourTable set theColumn = replace(theColumn,'oldString','newString')
Basic PHP/MySQL Snip...
posted by xav
<?php //I connect to what database server $con = mysql_connect("localhost","user","password"); //Am I connected ? if (!$con) { die('Could not connect: ' . mysql_error()); } // I select the database from within the database...


Abduzeedo