PHP-Presentation - PHP/MySQL Michael Powell Basic PHP Echo Statement Variable and Echo

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
PHP/MySQL Michael Powell
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Basic PHP Echo Statement: <?php echo “Hello World”; ?> Variable and Echo: <?php $var=“Hello World”; echo $var; ?> Include: <?php include(menu.php); ?>
Background image of page 2
MySQL: Things You Need Database User Name Do not use “root” Password Tables in the Database Records/Rows Fields/Columns
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Databases 1 Database can be assigned to a whole site. If sections of a website do not need to interact, they can run just fine with separate databases. Separate databases/tables for each user is better for security.
Background image of page 4
Tables Normally Required: Table for Users – If the site has tracking or is interactive you will need a users table. Table for IPs/Logging – Can keep you from having to look at server logs if security becomes an issue. Optional: Submissions – Comments or content can be stored. Web Pages – Pages can be stored and called on when a user accesses a certain link.
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Think of everything you might need in the future, not what is just required now. This can save you time from having to change coding later. Do not overlap fields. I will not go into depth about this, but you should not have multiple fields in different tables storing the same information. You can call the information through a unique
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/13/2011 for the course CIS 3003 taught by Professor Staff during the Fall '08 term at University of Florida.

Page1 / 23

PHP-Presentation - PHP/MySQL Michael Powell Basic PHP Echo Statement Variable and Echo

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online