file_get_contents() is a simple screwdriver. Great for
simple GET requests where the header, HTTP request method, timeout,
cookiejar, redirects, and other important things do not matter. file_get_contents requires allow_url_fopen to be TRUE.allow_url_fopen = 1 Syntax to use file_get_contents()$result = file_get_contents('https://www.google.co.in');
Syntax to use curl() // Initiate the curl session $ch = curl_init(); // Set the URL curl_setopt($ch, CURLOPT_URL,); // Removes the headers from the output curl_setopt($ch, CURLOPT_HEADER, 0); // Return the output instead of displaying it directly curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); // Execute the curl session $'https://www.google.co.in'= curl_exec($ch); // Close the curl session curl_close($ch); // Return the output as a variable return $output;result
| value | constant |
|---|---|
| 1 | E_ERROR |
| 2 | E_WARNING |
| 4 | E_PARSE |
| 8 | E_NOTICE |
| 16 | E_CORE_ERROR |
| 32 | E_CORE_WARNING |
| 64 | E_COMPILE_ERROR |
| 128 | E_COMPILE_WARNING |
| 256 | E_USER_ERROR |
| 512 | E_USER_WARNING |
| 1024 | E_USER_NOTICE |
| 6143 | E_ALL |
| 2048 | E_STRICT |
| 4096 | E_RECOVERABLE_ERROR |
//show nothing error_reporting(0); //show everything error_reporting(E_ALL); //using php.ini and ini_set() ini_set('error_reporting', E_ALL);
//show warnings and errors error_reporting(E_ERROR | ERROR_WARNING); //show all types but notices error_reporting(E_ALL ^ E_NOTICE);
file_get_contens('http://hayageek.com') |
1
| $ch = curl_init(); |
1
2
3
| curl_setopt($ch,CURLOPT_URL,"http://hayageek.com");curl_setopt($ch,CURLOPT_RETURNTRANSFER,true);curl_setopt($ch,CURLOPT_HEADER, true); //if you want headers |
1
| $output=curl_exec($ch); |
curl_close($ch); |
$ch = curl_init(); curl_setopt($ch,CURLOPT_URL,$url); curl_setopt($ch,CURLOPT_RETURNTRANSFER,true);// curl_setopt($ch,CURLOPT_HEADER, false); $output=curl_exec($ch); curl_close($ch); return $output;DROP TRIGGER IF EXISTS deleteUser;
DELIMITER |
CREATE TRIGGER deleteUser AFTER DELETE ON ul_logins
FOR EACH ROW BEGIN
DELETE FROM userbase WHERE userID = old.id;
END;
|
DELIMITER ; DELIMITER | CREATE TRIGGER `after_insert_cart_items`AFTER INSERT ON `trigger_cart_items` FOR EACH ROW BEGIN INSERT INTO trigger_cart_log (cart_id, item_id) VALUES (NEW.cart_id, NEW.item_id); END|
DELIMITER ; DELIMITER |
CREATE TRIGGER `after_update_cost` AFTER UPDATE ON `trigger_items_cost` FOR EACH ROW BEGIN UPDATE trigger_items SET price = (NEW.cost * 1.3) WHERE item_id = NEW.item_id; END|
DELIMITER ; CREATE TRIGGER `before_update_cost` BEFORE UPDATE ON `trigger_items_cost` FOR EACH ROW BEGIN IF NEW.cost < 50 THEN SET NEW.cost = 50; ELSEIF NEW.cost > 50 AND NEW.cost < 100 THEN SET NEW.cost = 100; END IF; END 1. WHERE is applied before GROUP BY, HAVING is applied after (and can filter on aggregates).1, 2011-05-20, 100Now, we want to get the
1, 2011-05-21, 50
1, 2011-05-30, 10
2, 2011-05-30, 10
2, 2011-05-20, 20
userids and sum(dailyincome) whose sum(dailyincome)>100<?php
/*** mysql hostname ***/$hostname = 'localhost';
/*** mysql username ***/$username = 'username';
/*** mysql password ***/$password = 'password';
try {
$dbh = new PDO("mysql:host=$hostname;dbname=mysql", $username, $password);
/*** echo a message saying we have connected ***/
echo 'Connected to database';
}
catch(PDOException $e)
{
echo $e->getMessage();
}?> <?phptry {
$dbh = new PDO("firebird:dbname=localhost:C:\Programs\Firebird\DATABASE.FDB", "SYSDBA", "masterkey");
}
catch (PDOException $e)
{
echo $e->getMessage();
}?> <?phptry {
$dbh = new PDO("OCI:", "username", "password")
}
catch (PDOException $e)
{
echo $e->getMessage();
}?> <?phptry {
/*** connect to SQLite database ***/
$dbh = new PDO("sqlite:/path/to/database.sdb");
}
catch(PDOException $e)
{
echo $e->getMessage();
}?> CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...);
You can use one or more columns to create an index. For example, we can create an index on tutorials_tbl using tutorial_author.CREATE UNIQUE INDEX AUTHOR_INDEX ON tutorials_tbl (tutorial_author)
You can create a simple index on a table. Just omit UNIQUE keyword
from the query to create simple index. Simple index allows duplicate
values in a table.mysql> CREATE UNIQUE INDEX AUTHOR_INDEX ON tutorials_tbl (tutorial_author DESC)
There are four types of statements for adding indexes to a table:orderDetails table you have quantityOrder (the number of ordered products) and priceEach (price per product item) columns. However the orderDetails table
does not have computed column to store total sales for each line item
of the order. If it has, the database schema would not be a good design.
In this case, you can create a computed column named total, which is a product of quantityOrder and priceEach to store the computed result. When you query data from the database view, the data of the computed column is calculated on fly.SELECT statement must only refer to one database table.SELECT statement must not use GROUP BY or HAVING clause.SELECT statement must not use DISTICT in the column list of the SELECT clause.SELECT statement must not refer to read-only views.SELECT statement must not contain any expression (aggregates, functions, computed columns…)