Use PaaS service to host your web - with pagodabox

Fundamental PHP & Web Development

Transcript

1. Use PaaS service to host your web - with pagodabox Fundamental PHP & Web Development ! lecturer : Lucien Lee 李柏緯 Lecture 10
2. ! Cloud Computing
3. Cloud Computing
5. Paas •Provide API to deploy your service •You don’t set up a really remote environment. • Just use platform and set configuration. •Pay on demand
8. Basic outline 1. Register With Pagoda Box 2. Create Your Application 3. Set Up Git 4. Create Your SSH Key 5. Deploy Your Code 6. Set Your Domain
9. Sign up
10. Create new app
12. ? Git
13. Git
14. Why version control •Reversibility •Concurrency •History
15. Example
16. Git for Windows
17. Set Up SSH Keys 1. cd ~/.ssh 2. ssh-keygen -t rsa -C "your_email@youremail.com" 3. cat ~/.ssh/id_rsa.pub 4. copy and paste
18. Paste to Pagoda Box Account Settings
19. There is a GUI method
20. There is a GUI method
21. There is a GUI method
22. There is a GUI method
23. Some commands your need
24. git init initial to use git
25. git remote add pagoda <remote address> SET REMOTE ADDRESS!
26. git push pagoda master DEPLOY!
27. Set environment configuring your app for Pagoda Box
28. BoxFile web1: name: albumapp shared_writable_dirs: [photo, thumbnail] php_date_timezone: Asia/Taipei php_extensions: [mysql, gd] php_file_uploads: "1" db1: name: albumdb type: mysql
29. ? How to connect DB
30. Environment variables $link = mysql_connect( $_SERVER['DB1_HOST'], $_SERVER['DB1_USER'], $_SERVER[‘DB1_PASS'] );
31. Simple Case create Table in php file
32. Copy sql and query $sql_album = "CREATE TABLE IF NOT EXISTS `Album` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(128) NOT NULL, `Owner` varchar(32) NOT NULL, `Timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;"; ! mysql_query($sql_album);
33. Copy sql and query $sql_photo = "CREATE TABLE IF NOT EXISTS `Photo` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(128) NOT NULL, `Filename` varchar(64) NOT NULL, `Comment` text, `AlbumID` int(11) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;"; ! mysql_query($sql_photo);
34. Copy sql and query $sql_user ="CREATE TABLE IF NOT EXISTS `User` ( `Account` varchar(32) NOT NULL, `Password` varchar(32) NOT NULL, `Name` varchar(32) NOT NULL, PRIMARY KEY (`Account`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;"; ! mysql_query($sql_user);
35. HOW TO MANAGE DB •You can use phpmyadmin too •Connect DB by tunnel.
36. … Go further, learn more
37. Security issue how to defense with cracker attack?
38. Use PDO to link DB Better way to connect DB
39. Try some Framework cakePHP, condeignIter, ZEND, YII…
40. Login with other sites Facebook, google, twitter…
41. Thank you guys!