2014 database - course 2 - php

57 %
43 %
Information about 2014 database - course 2 - php
Technology

Published on March 12, 2014

Author: enskylin

Source: slideshare.net

PHP Ensky / 林宏昱

Browser sends HTTP request GET /enskylin HTTP/1.1 Host: www.facebook.com HTTP/1.1 200 OK HTML

Load data from database GET /enskylin HTTP/1.1 Host: www.facebook.com HTTP/1.1 200 OK HTML

generate HTML GET /enskylin HTTP/1.1 Host: www.facebook.com HTTP/1.1 200 OK HTML

HTTP response to browser GET /enskylin HTTP/1.1 Host: www.facebook.com HTTP/1.1 200 OK HTML

CGI and Web server Web server CGI HTTP Request stdin + env stdout HTTP Response + BODY HTTP request body HTTP request header HTTP response head + body

What's PHP • Rasmus Lerdorf, Danmark wrote the first version in 1995, use PHP to maintain his homepage • Originally stood for "Personal Home Page Tools" • It stands for PHP: Hypertext Preprocessor now

What can PHP do • Although PHP is an "hypertext preprocessor" you still can use it to do nearly anything you can do in other language, not just writing a web page C++, JAVA, Python, … • You can use PHP to write a web server, BBS crawler, NP homework, even a win32 program

Hello world the same as #include<iostream> using namespace std; int main () { cout << "Hello world!"; return 0; } in C++ <?php echo "Hello world!"; ?> OR Hello world!

PHP at a glance

Variables $helloWorld = "hello world"; echo $helloWorld; echo $nonExistVar; PHP Notice: Undefined variable: nonExistVar • Variables starts with a $ (dollar) sign • No reserved word. ($if, $else is okay) • The other rules is the same as C/C++

Types • Basic – Boolean -> TRUE / True / true / FALSE / False / false – Integer -> -(2^n) ~ 2^n - 1, n = 32 or 64 overflow: integer to float conversion – Float -> IEEE 64bit format – String • Complex – Array – Object

Type verification var_dump($variable) // can print out the type of $variable var_dump(2147483647); // int(2147483647) var_dump(2147483648); // float(2147483648) var_dump( array(1,2,3) ); array(3) { [0]=> int(1) [1]=> int(2) [2]=> int(3) }

Strings $string1 = "this is a stringn!"; // this is a string // ! $string2 = 'this is a string, toon!'; // this is a string, toon! $string3 = $string1 . " and " . $string2; // this is a string // ! and this is a string, toon!

Variables in String $score = 95; echo "Ensky's score is: " . $score; echo "Ensky's score is: {$score}"; // Ensky's score is: 95 echo 'Ensky's score is: {$score}"; // Ensky's score is: {$score} // not work with expression echo "Hi {1+1}"; // Hi {1+1}

Strings (cont'd) There is no "char type" $string = "this is a string!"; var_dump($string); // string(17) "this is a string!" var_dump($string[0]); // string(1) "t" $string[0] = 'T'; echo $string; // This is a string!

Implicitly type conversion In PHP, type conversions are implicitly. BEWARE OF IT!! var_dump("123" + 456); // int(579) var_dump(456 + "1 apple a day keeps…"); // int(457) var_dump(456 + "1,000"); // int(457)

Explicitly type conversion $score = 60; var_dump( (float) $score); // float(60) var_dump( (string) $score); // string(2) "60" var_dump( (bool) $score); // bool(true)

== and === $a == $b TRUE if $a is equal to $b after type juggling. var_dump( 123 == "123" ); // bool(true) var_dump( "0" == "0.00" ); // bool(true) var_dump( "0" == 0 ); // bool(true)

== and === var_dump( "0" == null ); // bool(false) var_dump( "0" == false ); // bool(true) var_dump( null == false ); // bool(true) !!!!!! var_dump( "0" == false && false == "" ); // bool(true) var_dump( "0" == "" ); // bool(false) !!!!!!

== and === We can use === to avoid unexpected equality var_dump( "0" === null ); // bool(false) var_dump( "0" === false ); // bool(false) var_dump( false === "" ); // bool(false) var_dump( "0" === false && false === "" ); // bool(false) var_dump( "0" === "" ); // bool(false)

== and === • $a == $b Equal TRUE if $a is equal to $b after type juggling. • $a === $b Identical TRUE if $a is equal to $b, and they are of the same type. • Note: var_dump( 123 === "123" ); // bool(false) http://tw2.php.net/ternary

Variable scopes in C in C++, { } introduces a variable scope for example { int a = 0; } cout << a << endl; // reports error, a is in the inside scope

Variable scopes in PHP in PHP, only Function introduces a new scope { $a = 1; } echo $a; // 1

Variable scopes in PHP in PHP, only Function introduces a new scope function setA () { $a = 1; // local variable } function printA () { echo $a; // no, undefined $a } setA(); printA(); // PHP Notice: Undefined variable: a

Variable scopes in PHP Use global keyword to access the global variable AVOID!! function printA () { global $a; echo $a; } $a = 1; printA(); // 1

functions in PHP PHP's function acts like C/C++ function fib ($n) { return $n <= 2 ? 1 : fib($n-1) + fib($n-2); } echo fib(9); // 34

functions in PHP Default function arguments function printScore($score = 0) { echo "your score is: {$score}"; } printScore(); // your score is 0 printScore(100); // your score is 100

Arrays • PHP's array is very powerful, hence very inefficient • You can use it like – Array in C / ArrayList in Java / List in Python – Map in C / HashMap in Java / Dictionary in Python • With PHP's powerful built-in array functions, array can easily becomes many data structure like Dequeue, Queue, Stack • You can put anything in array, even another array, or an object;

Arrays You can use like a simple C-style array $scores = array(30, 35, 45, 25); print_r($scores); /* Array ( [0] => 30 [1] => 35 [2] => 45 [3] => 25 ) */ key value

Arrays Totally the same as $scores = array(0 => 30, 1 => 35, 2 => 45, 3 => 25); print_r($scores); /* Array ( [0] => 30 [1] => 35 [2] => 45 [3] => 25 ) */ key value

Arrays or a HashMap $menu = array( 'beef noodles' => 260, 'noodles' => 60, 'beef' => 200 ); echo "price of beef is: $" . $menu['beef']; // price of beef is: $200 key value

Arrays or act as an queue $queue = array(); $queue[] = '1'; $queue[] = '2'; $queue[] = '3'; echo array_shift($queue); // 1 print_r($queue); /* Array ( [0] => 2 [1] => 3 ) */ auto key value

Arrays or act as an stack $queue = array(); $queue[] = '1'; $queue[] = '2'; $queue[] = '3'; echo array_pop($queue); // 3 print_r($queue); /* Array ( [0] => 1 [1] => 2 ) */ auto key value

Arrays hold a structured document $persion = array( 'name' => 'ensky', 'age' => 23, 'works' => array( 'NCTU computer science TA', '2014 Database TA' ) ); key value value no key, auto assign one

Control Structures • Nearly the same as C++ • if, else if, else • switch, case, default • do … while • while • for • break, continue • return

Control Structures Foreach: $array = array(1, 2, 3); foreach ($array as $value) { echo $value . " "; } // 1 2 3

Control Structures Foreach: $array = array('a' => 'apple', 'b' => 'banana'); foreach ($array as $key => $value) { echo "{$key}:{$value} "; } // a:apple b:banana

PHP and HTML Let's start with Hello world

PHP & HTML - Hello world Let's start with Hello world == index.php == <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>Hello world! Title</title> </head> <body> <p>Hello world!</p> </body> </html>

Recall PHP Hello world the same as #include<iostream> using namespace std; int main () { cout << "Hello world!"; return 0; } in C++ <?php echo "Hello world!"; ?> OR Hello world!

PHP & HTML – print variable <?php $name = 'ensky'; ?> … <body> <p>Hello world! <?php echo $name; ?></p> <p>Hello world! <?= $name ?></p> </body> …

PHP & HTML – print data <?php $dict = array('a' => 'apple', 'b' => 'banana'); ?> … <?php foreach ($dict as $key => $val): ?> <p><?= $key ?> : <?= $val ?></p> <?php endforeach; ?>

HTML Forms

HTML forms How to create a form in HTML? 1. create a form tag <form action="login.php" method="POST"> </form> where to send GET or POST?

HTML forms How to create a form in HTML? 2. put some input <form action="login.php" method="POST"> <input type="text" name="email"> <input type="password" name="password"> </form> http://www.w3schools.com/tags/att_input_type.asp

HTML forms How to create a form in HTML? 2. put some inputs <form action="login.php" method="POST"> <input type="text" name="email"> <input type="password" name="password"> <button type="submit">免費註冊</button> </form>

POST /login.php HTTP/1.1 Host: your_hostname <form action="login.php" method="POST"> <input type="text" name="email"> <input type="password" name="password"> <button type="submit">免費註冊</button> </form> email=enskylin@gmail.com& password=nctu5566 /login.php

email=enskylin@gmail.com& password=nctu5566 /login.php In login.php ----- <?php echo $_POST['email']; echo $_POST['password']; ?> POST /login.php HTTP/1.1 Host: your_hostname

HTTP & states

HTTP is a stateless protocol

When you open a browser, navigate to a url

HTTP Request

HTTP response

and it is done.

How do we preserve the "state"? login or not? who are you? what did you buy?

Cookie! • HTTP protocol defined a spec called "cookie" • which can help server to identify clients HOW?

client request HTTP Request

server response with set-cookie header HTTP response Set-Cookie: name=ensky HTML … Server asked me to save the cookie!

The next client request will bring the cookie set by server HTTP Request cookie: name=ensky

Server is able to identify which client it is. HTTP Request cookie: name=ensky Oh! you're ensky

Cookie's problem • However, Cookie identification is too weak! • Anyone who can make a fake identification HTTP Request cookie: name=ensky Oh! you're ensky I'm Cracker

Session • One approach is session • Server gives client a "temporally key" HTTP Request

After the request, server will generate the temporarily key session name 0aj9 ensky s4df dy93 HTTP Request generate a temp key, expire in a short time

Response with session(temp key) HTTP Request HTTP response Set-Cookie: session=0aj9 HTML … session name 0aj9 ensky s4df dy93

Server can then identify successfully by correct key HTTP Request cookie: session=0aj9 Oh! you're ensky session name 0aj9 ensky s4df dy93

Use session Set ------ <?php session_start(); $_SESSION['name'] = 'ensky';

Use session Get ------ <?php session_start(); echo $_SESSION['name'];

Use session Destroy ------ <?php session_start(); $_SESSION = array(); session_destroy();

Use session • Note: session_start(); must be call before any HTML output – why?

Practice • write a webpage – login (using predefined username / password) • output login error when input wrong username or password – echo out current DateTime(ex: 2014/3/4 9:55:54) using PHP date() function • see PHP doc • shows only when user is logged-in successfully – logout • after logout, user cannot use any function without login • Just practice, no need to hand in

Appendix

Run PHP script • Since PHP is a server-side CGI, you cannot just open PHP script in your browser • After written PHP script by IDEs I suggested last week, you should put it in CS web server, and reach it by http://people.cs.nctu.edu.tw/~your_id/file_name.php or your own webserver and reach it by http://localhost/file_name.php

functions in PHP Defines as anonymous function $fib = function ($n) { … } echo $fib(9); inner function function a () { $n = 0; $b = function () use ($n) { // you can use $n here }; } since PHP 5.3

functions in PHP Reference arguments function addN (& $n) { $n++; } $n = 0; addN($n); echo $n; // 1

Redirect • how to redirect to another webpage? <?php header('location: another_webpage.php'); exit; note: you must call header before any HTML output, just like session_start();

PHP Module In PHP, you can import other file into a file lib.php ----- <?php function fib($a) { return … } page.php <?php require_once "lib.php"; echo fib(3); http://www.php.net/manual/es/function.in clude.php

Add a comment

Comments

Louis Vuitton US Outlet | 06/02/15
http://www.cheapforlouisvuitton.in.net/cheap louis vuittonhttp://www.louisvuittonoutlet2015.in.net/Buy Louis Vuitton 2015 Louis Vuitton US Outlet http://www.louisvuittonoutlet2015.us.com/
Cheap Retro Jordan | 09/02/15
http://www.louisvuittonsales.us.com/louis vuitton outlet Cheap Retro Jordan http://www.cheapjordansretroforsale.us.com/
 | 10/05/15
http://www.shalongguojislgj.com/ | 11/05/15
http://www.o19r4x.com/F_1/ | 11/05/15
http://www.3blfqu.com/F_4/ | 11/05/15
www.ymzjn.com | 11/05/15
 | 11/05/15
¥
http://www.16888pos.com/sitemap. | 11/05/15
http://www.tiantianyulecheng.cn/ | 11/05/15
 | 12/05/15
http://www.ug2unm.com/sitemap.tx | 12/05/15
http://www.huojianyulecheng.cn/F | 12/05/15
http://www.jinzanyulechang.cn/si | 12/05/15
ǿӲ
http://www.rpmy.net/F_1/ | 12/05/15
ʲô
http://www.sxjzynt.com/F_4/ | 12/05/15
ȥҽԺ
www.ybxjyL.com | 12/05/15
ƽ˳ | 12/05/15
http://www.shenhuayulecheng.com. | 13/05/15
ë
ۯ | 13/05/15
www.luanping.net.cn | 13/05/15
http://www.jsk7.com/F_3/ | 13/05/15
http://www.caishenyulechengcsylc | 13/05/15
http://www.jinniuguojiyulechengj | 13/05/15
http://www.huangguan0088hg0088.c | 13/05/15
http://www.ptysst.com/F_4/ | 14/05/15
 | 14/05/15
http://www.kfkcck.com/F_2/ | 14/05/15
http://www.miandianguoganduchang | 14/05/15
http://www.0717traveL.com/F_3/ | 14/05/15
http://www.kaixuanmenduchang.com | 14/05/15
http://www.LzxxL.com/F_1/ | 14/05/15
üɽ | 15/05/15
http://www.weiaiyb.com/F_4/ | 15/05/15
http://www.xinhaotiandixhtd.com/ | 15/05/15
̫˧
 | 15/05/15
¹Ȫ | 15/05/15
http://www.wzjujing.com/F_2/ | 16/05/15
 | 16/05/15
http://www.jsk7.com/F_3/ | 16/05/15
http://www.hengfengyulecheng.cn/ | 16/05/15
 | 17/05/15
 | 17/05/15
http://www.ttyule.com.cn/F_3/ | 17/05/15
http://www.jiazhouyulecheng.cn/F | 17/05/15
 | 18/05/15
1000
www.pingding.net.cn | 18/05/15
http://www.shenhuayulechengshylc | 18/05/15
http://www.wanzhongtuku.cn/sitem | 18/05/15
http://www.tjaibian.com/F_4/ | 18/05/15
http://www.weinisirenduchangwnsr | 18/05/15
www.yuanshi.org.cn | 18/05/15
http://www.yycLfs.com/sitemap.ht | 18/05/15
Ů
http://www.p0ikww.com/F_3/ | 19/05/15
http://www.hhemj.com/F_4/ | 19/05/15
 | 19/05/15
www.zhaoxian.net.cn | 19/05/15
http://www.tjaibian.com/F_1/ | 19/05/15
http://www.miandianduchang.cn/F_ | 20/05/15
 | 20/05/15
http://www.nermai.com/F_4/ | 20/05/15
http://www.3vllqx.com/F_1/ | 20/05/15
ǰһ
http://www.dtg41r.com/F_3/ | 20/05/15
ɵ
ʯ | 20/05/15
 | 20/05/15
http://www.xianggangduchangxgdc. | 20/05/15
̫
http://www.huangchengyulechenghc | 21/05/15
װһ
http://www.sjbrad.com/sitemap.ht | 21/05/15
http://www.xingjiduchang.com.cn/ | 21/05/15
www.shyozdhkj.com | 21/05/15
http://www.lilaiyulechengllylc.c | 21/05/15
http://www.xinxintuku.cn/F_2/ | 21/05/15
http://www.yijiutuku.cn/F_4/ | 22/05/15
 | 22/05/15
http://www.1nqh54.com/F_2/ | 22/05/15
 | 22/05/15
http://www.guiliutuku.cn/sitemap | 22/05/15
http://www.mygnpx.com/sitemap.ht | 22/05/15
http://www.liuhetuku.cn/F_1/ | 22/05/15
http://www.hyjsLzp.com/F_2/ | 22/05/15
http://www.fzsjtdz.com/F_4/ | 23/05/15
www.taizhong.net.cn | 23/05/15
http://www.weinisirenduchangwnsr | 23/05/15
www.cshaoc.com | 23/05/15
www.dfyz6789.com | 23/05/15
http://www.b1q235.com/F_4/ | 23/05/15
MD
http://www.shkezen.com/F_3/ | 24/05/15
www.shyozdhkj.com | 24/05/15
www.cj17917.com | 24/05/15
 | 24/05/15
http://www.wbdqw.com/F_3/ | 24/05/15
http://www.m88-mingsheng.com/F_4 | 24/05/15
http://www.laopujingyulecheng.cn | 25/05/15
www.cdLmhf.com | 25/05/15
http://www.g3h2iq.com/sitemap.ht | 25/05/15
http://www.zgbyby.com/F_1/ | 25/05/15
 | 25/05/15
http://www.kkyulecheng.com.cn/F_ | 25/05/15
http://www.yonglibo.cn/sitemap.t | 25/05/15
http://www.yingfengyulechengyfyl | 26/05/15
www.usabcc.com | 26/05/15
 | 26/05/15
http://www.www-hg0088-com.cn/F_2 | 26/05/15
һȺҽ
http://www.amaniyulecheng.com.cn | 26/05/15
ʮ
www.sxtdqj.com | 26/05/15
http://www.huangguantouzhu.cn/si | 26/05/15
ƽ˳ | 26/05/15
http://www.hst-wh.com/F_1/ | 27/05/15
http://www.msudmh.com/F_2/ | 27/05/15
sb
http://www.jinshaqipaijsqp.com/F | 27/05/15
http://www.besky-jz.com/F_4/ | 27/05/15
www.ybxjyL.com | 27/05/15
 | 27/05/15
http://www.Long-bund.com/sitemap | 27/05/15
www.yzhsnj.com | 28/05/15
http://www.shisanzhangyulecheng. | 28/05/15
http://www.jinniuyulechengjnylc. | 28/05/15
Ϊʲô
http://www.lilaiguojionline.cn/F | 28/05/15
www.bjjxgd.com | 28/05/15
www.sivncn.com | 29/05/15
http://www.jinpaiyule.com.cn/F_6 | 29/05/15
http://www.meijibaby.com/sitemap | 29/05/15
http://www.27gwh0.com/F_5/ | 29/05/15
http://www.mszex.com/sitemap.txt | 29/05/15
www.gzmgxb.com | 29/05/15
http://58yulecheng.yolasite.com/ | 29/05/15
http://www.xiLaigeng.com/sitemap | 30/05/15
 | 30/05/15
www.mszex.com | 30/05/15
http://www.mygnpx.com/sitemap.tx | 30/05/15
 | 30/05/15
http://www.dumadm.com/F_5/ | 30/05/15
www.sjztpyjx.com | 30/05/15
S JB B
www.bjjjdc.com | 30/05/15
http://www.m88-mingsheng.com/F_6 | 31/05/15
http://zhenrenyule.fourfour.com/ | 31/05/15
http://www.Lycaopi.com/F_5/ | 31/05/15
http://www.guobodongfanggbdf.com | 31/05/15
http://www.niuyueyulechengnyylc. | 31/05/15
http://www.LvduhoteL.com/F_5/ | 01/06/15
www.nbt158.com | 01/06/15
Ҫ
http://www.hbrongLi.com/sitemap. | 01/06/15
 | 01/06/15
ƶ
http://www.1gw893.com/sitemap.tx | 01/06/15
99 | 01/06/15
http://www.baiheyulechengbhylc.c | 01/06/15
www.ybxjyL.com | 01/06/15
http://landunzaixian.yolasite.co | 02/06/15
http://www.kmhqxLqc.com/F_6/ | 02/06/15
һ
http://www.k7yulechang.cn/sitema | 02/06/15
www.xrgscs.com | 02/06/15
http://www.sxyfywz.com/sitemap.t | 02/06/15
 | 02/06/15
Ҫ
http://www.ahjLqh.com/sitemap.ht | 02/06/15
ȫ
 | 02/06/15
www.Long-bund.com | 02/06/15
http://www.aomenyulecheng.com.cn | 03/06/15
http://www.liuhecaituku.com.cn/F | 03/06/15
http://www.cd-yj.com/sitemap.htm | 03/06/15
www.sc-cxjt.com | 03/06/15
http://www.dafa888-df888.com/sit | 04/06/15
http://www.baixiaojiecaisetuku.c | 04/06/15
http://www.mygsz.com/F_5/ | 04/06/15
12bet | 04/06/15
http://1q464u.blog.com/ | 04/06/15
http://www.jiebaoyulechengjbylc. | 04/06/15
www.dfyz6789.com | 04/06/15
http://www.jiulongyulechengjlylc | 04/06/15
www.cdLmhf.com | 04/06/15
http://www.eeiw0v.com/F_6/ | 05/06/15
http://z6e6c4.blog.com/ | 05/06/15
http://www.sxtdqj.com/sitemap.tx | 05/06/15
http://www.xayLex.com/sitemap.tx | 05/06/15
ͦ
http://www.cshaoc.com/sitemap.ht | 05/06/15
http://www.ynnjmy.com/sitemap.tx | 05/06/15
http://www.lh9fje.com/F_5/ | 05/06/15
www.jsk7.com | 05/06/15
http://www.aomenweinisirenduchan | 05/06/15
http://www.scjinhaiLi.com/sitema | 06/06/15
http://www.t7dctv.com/sitemap.ht | 06/06/15
 | 06/06/15
http://www.hbxcjsj.com/F_5/ | 06/06/15
http://xinaomenyulecheng.blinkwe | 06/06/15
http://www.yingfengguoji-yfgj.co | 06/06/15
www.sc-cxjt.com | 06/06/15
http://www.jinzanyulechang.cn/si | 06/06/15
http://www.sxyobon.com/sitemap.h | 06/06/15
 | 06/06/15
http://www.yameiyuleam8.cn/F_6/ | 06/06/15
http://www.4hmbta.com/F_5/ | 06/06/15
http://www.whkhoa.com/sitemap.tx | 06/06/15
 | 07/06/15
http://www.Lswybg.com/sitemap.tx | 07/06/15
 | 07/06/15
N
http://www.tangchaoyulecheng.cn/ | 07/06/15
http://www.msudmh.com/F_5/ | 07/06/15
 | 07/06/15
http://www.taojinyingyulecheng.c | 08/06/15
http://www.g7ukq2.com/sitemap.tx | 08/06/15
http://www.24ftog.com/F_5/ | 08/06/15
 | 08/06/15
http://www.botiantangonline.cn/s | 08/06/15
http://www.sanyayulecheng.cn/F_5 | 08/06/15
http://www.zzzj888.com/sitemap.h | 08/06/15
˫
 | 08/06/15
 | 09/06/15
ΰ | 09/06/15
www.028yLf.com | 09/06/15
http://www.lilaiguoji-llgj.com/s | 09/06/15
G3 | 09/06/15
www.cdhwms.com | 09/06/15
http://www.dafa888game.cn/F_6/ | 09/06/15
http://www.huangjinchenghjc.com/ | 10/06/15
http://www.junboguojijbgj.com/si | 10/06/15
 | 10/06/15
http://www.cnLianguo.com/sitemap | 10/06/15
zf
 | 10/06/15
һ
http://www.zcmpw.com/sitemap.txt | 10/06/15
www.besky-jz.com | 10/06/15
http://www.yxjzfs.com/sitemap.tx | 10/06/15
Ӧ
http://www.chuangfutuku.cn/F_5/ | 10/06/15
http://www.gangjingtuku.cn/sitem | 10/06/15
http://www.bjzafiro.com/F_6/ | 11/06/15
http://www.chLiw.com/sitemap.txt | 11/06/15
http://www.jiuzhouyulecheng.com. | 11/06/15
Сʱ

Related presentations

Related pages

Databases & SQL Training Courses - Find more than 15,000 ...

... Find Microsoft SQL database training courses tailored to your ... (2) 3 days. 1,195 GBP ... PHP & MariaDB for Web Development Course Overview The PHP ...
Read more

MySQL Tutorials | Lynda.com

9 MySQL courses · 558 video tutorials ... and functions), and discover how to connect to a MySQL database and develop a complete web ... MySQL, and PHP, ...
Read more

PHP Tutorial: PHP/MySQL for Beginners | Udemy

By the end of the course you will be able to use advanced database operations with PHP and ... 2 pages ... tool to a more supported course on PHP. ...
Read more

PHP: Hypertext Preprocessor

Persistent Database Connections Safe Mode ... The PHP development team announces the immediate availability of PHP 7.0.2. 31 reported bugs has ...
Read more

SQLCourse - Interactive Online SQL Training for Beginners

SQLCourse.com: an interactive ... Advertise on SQLCourse.com: 12: Database Links: 13: Technology Jobs: Free Newsletters: ... SQL Course Curriculum; 1: 2: 3 ...
Read more

MySQL :: MySQL Training from Oracle University

Training on Demand courses from Oracle University include ... MySQL for Database Administrators course is for DBAs and other database ... MySQL and PHP ...
Read more

PHP Tutorials | Lynda.com - Online Video Tutorials ...

Designed for intermediate users, our PHP tutorials can help you learn PHP inside and out. Find out how to use PHP with a MySQL database, and how to know if ...
Read more

Develop a PHP Web Application with Oracle Database 11g

Developing a PHP Web Application with Oracle Database ... This tutorial helps you get started with PHP and Oracle Database ... Install Oracle Database 11.2 .
Read more

SQL Server Database Administration | Course 2108

SQL Server Database ... Administrator and want to learn what's new in SQL Server 2014. Is this the right course for ... and Database Mail: 2.0:
Read more

Data manipulation API - MoodleDocs

Data manipulation API; ... which is defined in moodle_database.php; ... From Moodle 2.5.1 onwards, you should use the get_course function instead of ...
Read more