Web Exam 2
Write the code to create two checkboxes input box, as done in program 2
<tr> <td> <input type="checkbox" name="checkbox1" value="checkbox1"> <input type="checkbox" name="checkbox2" value="checkbox2"> </td> </tr>
What will this code do: ../../../chmod 755 *
there is no file or directory name chmod the second and third lines are optional
Save.php summarized
$Telephone=trim($Telephone); if(strlen($Telephone)>0) { $sql="INSERT INTO customers ( Telephone, Motherboard ) VALUES ( '$Telephone', '$Motherboard' )";
What does the WINSCP program do?
transfer files from your local PC to a remote server
Create one table using border 2, color red, with one row and inside this row,create two columns. Inside column one, using the font tag, display GREAT, using Arial font, coloryellow size 3
<body> <table border="2" bordercolor="red"> <tr> <div class="column"> <font face="Arial" color="yellow" size="3">GREAT</font> <br> </div><div class="column"></div> </tr> </table> </body>
Assume that you are in the same folder where the index file is found, create a form to call page3, located in the includes folder, passing its data, hidding.
<form method="post" action="includes/page3"> </form>
What does the PUTTY program do?
Transfers file to and from a local PC to a remote server
What is the name of the folder to place all your program and folders for your website in this class
public_html
Display the data fomr the previous question ($Telephone = $_POST['Telephone'];) in this section
echo 'Telephone: $Telephone'
In which operating system(s) does PUTTY work(s)
Windows
Assuming that you are in the constructor2.php page, write the code to extraxt the data from an input field in program 2 named Telephone
$Telephone = $_POST['Telephone'];
Create a menu using the CSS3 learned in this class, to display two (2) vertical options/links page1 and page2
<nav> <ul> <li> <a href="./page1.html">Page 1</a> <br> <a href="./page2.html">Page 2</a> </li> </ul> </nav>
Write the code to create one dropdown input box, as done in program 2
<select name="Dropdown" size="1"> <option>Dropdown1</option> <option>Dropwdown2</option> </select>
In html, using the font tag, display in three different lines the followng:Line 1 = We aligned to the left using courier size 4 color orangeLine 2 = are aligned to the center using ariel size 5 color blueLine 3 = Web Design aligned to the right using Loma size 6 color red
<td align=left> <font face="courier" size="4" color="orange"> We </font> </td> <td align=right> <font face="Loma" size="6" color="red">Web Design</font> </td>
Write the code to create one Textarea input box, as done in program 2
<textarea name"Textarea" rows="10" cols="3"></textarea>
Create a horizontal menu using hyperlinks for page1, page2 leaving 4 (four) HORIZONTAL spaces between them
<tr> <td> <a href="page1.html" >Page 1</a>     <a href="page2.html" >Page 2</a> </td> </tr>
In which operating system(s) does WINSCP work
Windows
Write the starting part of the form tag, as used in program2
<form method="post" action="Controller2.php">
Find.php summarized
$sql="SELECT * FROM customers where Telephone = '$Telephone'"; if ($result=mysqli_query($connection,$sql)) { $rowcount=mysqli_num_rows($result); while( $row = mysqli_fetch_array( $result ) ) { $Telephone = $row['Telephone']; $Motherboard = $row['Motherboard']; }
What does cellspacing do in HTML
Cellspacing allows us to create spaces between the Adjacent cells
message
if (mysqli_query($connection, $sql)) { //echo "<br>New record created successfully"; $message ="<span style=\"color: red;\">RECORD $found ADDED</span><br\>"; } else { //echo "<br>Error: " . $sql . "<br>" . mysqli_error($connection); $message ="<span style=\"color: red;\">RECORD $found EXISTS NOT ADDED</span><br\>"; } { $message ="<span style=\"color: red;\">RECORD NOT ADDED<BR>Telephone CAN NOT BE EMPTY</span><br\>"; }
Whats is the name for your website's required file, as used in this class
index.html
Delete.php summarized
$record = "RECORD ". $Telephone." DELETED"; $found = $_POST['found']; $sql="DELETE FROM customers WHERE Telephone='$Telephone'"; $Telephone=trim($Telephone);
Write the code used in constructor2.php to find which of the following buttons werepressed in program2.php/pgm2.phpfind, save, delete, modify.
if ( $_POST['find'] ) { echo 'find'; } if ( $_POST['save'] ) { echo 'save'; } if ( $_POST['delete'] ) { echo 'delete'; } if ( $_POST['modify'] { echo 'modify'; }
Create a css section of code named redWhite to set background as color red and letters as color white, as shown in the html head section in this class
redWhite { background: red; color: white; }
Write program 1's MODIFIED menu code that calls program2.php.
<table> <tr> <td> <a href="includes/pgm1.html"> Program 1 </a> </td> <td> <a href="includes/program2.php"> Program 2</a> </td> <td> <a href="index.html"> Home</a> </td> </tr> </table>
Modify.php summarized
$found = $_POST['found']; if ( ( strlen(trim($found)) > 0 ) && ($found == $Telephone) ) { $query = "UPDATE customers SET Telephone = '$Telephone', Motherboard = '$Motherboard' WHERE Telephone = '$Telephone'"; $sql = mysqli_query( $connection,$query ); }
What does cellpadding do in HTML
cellpadding allows us to create padding around the cell content
Create one text field named telephone, as done in program 2
<input type="text" size="4 maxlength="20" name="telephone">
Create a menu using the CSS3 learned in this class, to display two (2) horizontal options/links page1 and page2
<nav> <ul> <li> <a href="page1">page1</a> <a href="page2">page2</a> </li> </ul> </nav>
Write the code to create one submite input box, as done in program 2
<textarea name="comments"></textarea>
Write the heading and closing of the form that calls the constructor2.php program
<form method="post" action="constructor2.php></form>
Write the code to create two radio buttons, as done in program 2
<tr> <td> <input type="radio" name="radiobutton" value="radiobutton1"> <input type="radio" name="radiobutton" value="radiobutton2"> </td> </tr>
Write the code used in program 2 to create the save button
<tr> <td> <input type="submit" name="Save" value="Save"> <td> </tr>
Create one row with one column that will display WELCOME using ARIAL font size 4 color yellow
<tr> <td> <font face="arial" size="4" color="yellow" > WELCOME </font> </td> </tr>
Contact me controller Code to send email
if($_POST['submit']) { $to = "[email protected]"; $subject = "Contact me Controller"; }