Archive for June, 2009
Example: Download Website / Webpage Trough CURL PHP
on June 24, 2009
You can access / display any webpage through the following code: <?php echo DownloadUrl(‘http://www.imjan.com’); // Type Website URL to download function DownloadUrl($Url){ // is curl installed? if (!function_exists(‘curl_init’)){ die(‘CURL is not installed!’); } // create a new curl resource $ch = curl_init(); /* Here you find more options for curl: http://www.php.net/curl_setopt */ // set URL to download curl_setopt($ch, CURLOPT_URL, $Url); // set referer: …
How to increase organic traffic at your website?
on June 20, 2009
Organic traffic gives you real user plus more business for any niche. There are several ways to choose the best keywords for your website to increase your organic traffic of your website. If you follow the following steps you can get more traffic than any other website. * Be specific with niche and find your main competitors? * Fetch their main keywords, and …
Order by vs GROUP By
on June 15, 2009
The easiest explanation is that order by is doing the sorting of a table and the group by clause is used for aggregation of a field.
The CHAR and VARCHAR Types
on June 15, 2009
he CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. As of MySQL 5.0.3, they also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the maximum number of characters you want to store. For example, CHAR(30) can hold up to 30 …
what is the main difference between myisam and innodb?
on June 15, 2009
both myisam and innodb are storange enginein sql. innodb support transaction, foreign key while myisam not support transaction. Other differences are : 1. innodb requires more RAM than mysiam 2. myisam relies on OS for caching while innodb caches with in the engine itself. 3. Most preffered is innodb because – Transaction safe -It has commit, rollback, and crash recovery capabailities – Innodb …
Stored programs include these objects
on June 15, 2009
Stored routines, that is, stored procedures and functions. A stored function is used much like a built-in function. you invoke it in an expression and it returns a value during expression evaluation. A stored procedure is invoked using the CALL statement. A procedure does not have a return value but can modify its parameters for later inspection by the caller. It can also …
Defining Stored Programs (Stored routines, Triggers, Events)
on June 15, 2009
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of a BEGIN … END block that contains a SET statement and a REPEAT loop that itself contains another SET statement: CREATE PROCEDURE …
Using Stored Routines (Procedures and Functions)
on June 15, 2009
Stored routines (procedures and functions) are supported in MySQL 5.1. A stored routine is a set of SQL statements that can be stored in the server. Once this has been done, clients don’t need to keep reissuing the individual statements but can refer to the stored routine instead. Stored routines require the proc table in the mysql database. This table is created during …
which version of mysql can't support stored procedure??
on June 15, 2009
Earlier versions (before 5.0)
MySQL 5.0 New Features: Stored Procedures (By Peter Gulutzan) Introduction This 67 page guide is for long-time MySQL users who want to know “what’s new” in version 5. The short answer is “stored procedures, triggers, views, information_schema”. The long answer is the MySQL 5.0 New Features series, and this book is the first in the series. What I’m hoping to do is make …