polling system part 1 creating php & mysql files cis 254
TRANSCRIPT
![Page 1: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/1.jpg)
Polling System Part 1
Creating PHP & MySQL Files
CIS 254
![Page 2: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/2.jpg)
Polling System
• Create Database
• Upload Table information through PHP
• Creating Require() Files
• Add Polls
• Load Poll Data
• Vote For– Setting Cookies
![Page 3: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/3.jpg)
Create Database
• Using Telnet and MySQL Admin– Create DB INTpoll– Set Permissions
• GRANT for DB and TABLE
![Page 4: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/4.jpg)
Upload Table information through PHP
• In A PHP File, – Create connection to database – Create table in mysql_query statement– Insert tQable data in mysql_query statement– One statement per INSERT statement– Use echo mysql_error for troubleshooting
![Page 5: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/5.jpg)
Creating Require() Files
• Allow you to insert information from a outside file into a current file.– Useful for headers, footers and commonly
required variables.
• Create Connect.php
• Use REQUIRE() for connection variables
• Commonly called includes
![Page 6: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/6.jpg)
Add Polls
• File used to input poll questions into system
• Poll questions come from database
• See file addpolls.php
![Page 7: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/7.jpg)
Load Poll Data
• Loads Questions into Flash according to selection. – See loadpolldata.php
![Page 8: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/8.jpg)
Vote For
• Check for previous votes– Using a cookie
• Update record with votes
• Send poll data back to flash– See votefor.php
![Page 9: Polling System Part 1 Creating PHP & MySQL Files CIS 254](https://reader035.vdocuments.us/reader035/viewer/2022071718/56649ec05503460f94bcac9f/html5/thumbnails/9.jpg)
Setting Cookies
• Cookies allow tracking of previous votes