1 / 12

PHP and SQL Integration: Basic Form Handling and Data Display

This document outlines the process of creating a simple PHP web application that includes form handling and SQL database interactions. It features an HTML form where users can select a weekday and enter their first and last names. Upon submission, the PHP script captures these inputs, connects to an SQL database, retrieves data, and displays it in an HTML table format. The tutorial serves as a foundational guide for beginners to understand the integration of HTML, PHP, and SQL in web development.

bruno-rojas
Télécharger la présentation

PHP and SQL Integration: Basic Form Handling and Data Display

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Back to html / php / sql

  2. HTML Hello World <html> <head> <title>Page Title</title> </head> <body> <h1>Hello World!!</h1> </body> </html>

  3. A little more <html> <head> <title> Page Title </title> <link rel="stylesheet" href="mystyle.css" type="text/css" /> </head> <body> <p>My name is: <strong>Elizabeth Thiry</strong></p> <p>My user ID is: exn152</p> <p>I am a student at <a href="http://www.personal.psu.edu/exn152"> PSU </a></p> </body> </html>

  4. CSS p { color:#666; font-size:.8em; padding-left:9em; } a { color: green; text-decoration:overline; } strong { color: purple; font-size:larger; }

  5. Hello World With HTML and PHP <html>   <head>    <title>PHP Test</title>  </head>   <body>   <?php echo '<p>Hello World</p>'; ?>    </body> </html>

  6. Forms <html> <head> <title>PHP Test</title> </head> <body> <h1>Form Page</h1> <form action=“action.php" method="post"> <p>Select a day: <select name="weekday"> <option>Sunday</option> <option>Monday</option> <option>Tuesday</option> <option>Wednesday</option> </select><br /> First Name: <input name="fname" type="text" /> <br /> Last Name: <input name="lname" type="text" /> <br /> <input type="submit" /> </form> </body> </html>

  7. Action.php <html> <head> <title>PHP Test</title> </head> <body> <h1>My PHP Action Page</h1> <p> <?php $weekday = $_POST['weekday']; $fname = $_POST['fname']; $lname = $_POST['lname']; echo "You selected ". $weekday . "<br />"; echo "Thank you ". $fname ." ". $lname ."<br />"; ?> </p> </body> </html>

  8. Connecting to SQL <html> <head> <title>Lab 5</title> </head> <body> <h1>Form Page</h1> <form action="lab5_action.php" method="post"> <p>Select a day: <select name="weekday"> <?php

  9. Connecting to SQL.. Cont…. <?php $myServer = "updb1.up.ist.psu.edu"; $myUser = "sqlnna102"; $myPass = "snsmR8Wf"; $myDB = "nna102"; //connection to the database $dbhandle = mssql_connect($myServer, $myUser, $myPass) or die("Couldn't connect to SQL Server on $myServer"); //select a database to work with $selected = mssql_select_db($myDB, $dbhandle) or die("Couldn't open database $myDB");

  10. Connecting to SQL.. Cont…. //declare the SQL statement that will query the database $query = "SELECT id, day "; $query .= "FROM Weekdays "; //execute the SQL query and return records $result = mssql_query($query); $numRows = mssql_num_rows($result); echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>"; //display the results while($row = mssql_fetch_array($result)) { echo "<option>" . $row["day"] . "</option>"; } //close the connection mssql_close($dbhandle); ?>

  11. Connecting to SQL.. Cont…. </select><br /> First Name: <inputname="fname" type="text" /> <br /> Last Name: <inputname="lname" type="text" /> <br /> <input type="submit" /> </form> </body> </html>

  12. Displaying in a table echo "<table border='1'> <tr> <th>FirstName</th> <th>LastName</th> </tr>"; //display the results while($row = mssql_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['PlayerFirstName'] . "</td>"; echo "<td>" . $row['PlayerLastName'] . "</td>"; echo "</tr>"; } echo "</table>"; //close the connection mssql_close($dbhandle); ?>

More Related