HI, I applied to a company and took a test.
I then was told I got rejected but they won't tell me why.
the test was confusing.
I had to in php make a html form with inputboxes that would input the persons first name , last name, and phone number. This is code one.
they then asked for code part 2 to then display what was just inputted into the database
here is the code:
CODE
<?php
//Database Connection
$msdb = mysql_connect("localhost", "root", "");
mysql_select_db("test", $msdb) or die(mysql_error());
/*
GENERAL INFORMATION:
Below is the current table structure for 'members':
=====
ID: id (autoincrement)
First Name
Last Name
Phone Number
=====
PUT YOUR NAME HERE PLEASE:my name
PART 1:
-------
* Below, write the PHP code to insert a first name, last name, and phone number
into the 'members' table. Use an HTML form to collect this information, then store it to the 'members' table.
//
*/
if (!isset($_POST["submit"])) {
echo "<html><head><link rel=\"stylesheet\" type=\"text/css\" href=\"/test.css\"/><form action=\"test.php\" method=\"POST\">";
echo "<table>";
echo "<tr>";
echo "<td id=\"first\" width=\"50%\">First Name:</td><td width=\"50%\"><input id=\"one\" name=\"firstname\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td id=\"last\" width=\"50%\">Last Name:</td><td width=\"50%\"><input id=\"two\"name=\"lastname\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td id=\"phone\"width=\"50%\">Phone Number:</td><td width=\"50%\"><input id=\"three\" name=\"phone_number\" size=\"18\" type=\"text\" />";
echo "</tr>";
echo "<tr>";
echo "<td colspan=\"2\"><input id=\"submit\" type=\"submit\" name=\"submit\" value=\"submit\"</td>";
echo "</tr>";
echo "</table>";
echo "</form><img id=\"output\" src=\"lightblue.jpg\">";}
if(isset($_POST["submit"])){
$first_name=$_POST["firstname"];
$last_name=$_POST["lastname"];
$phone_number=$_POST["phone_number"];
$q = mysql_query("SELECT * FROM members WHERE firstname ='$first_name' AND phone = '$phone_number'");
$r = mysql_num_rows($q);
if($r==0){
$q2=mysql_query("INSERT INTO `members` (firstname,lastname,phone) VALUES ('$first_name','$last_name','$phone_number')");}
/*Part one that I made shows first a html fourm where you can input the first name and last name and phone number. Then once the person clicks the submit button it will then store that info into the mysql database.Also $q2 this would run only if the record dosen't exist in the database.*/
/*
PART 2:
-------
* Below, write the PHP code to retrieve the previously inserted record from the
'tests' table and display it in the browser.*/
$q3 = mysql_query("SELECT * FROM `members` WHERE firstname ='$first_name' AND phone = '$phone_number'") or die (mysql_error());
$row = mysql_fetch_assoc($q3);
$first_name2=$row["firstname"];
$last_name2=$row["lastname"];
$phone_number2=$row["phone"];
echo"<html><title>Output</title><head><link rel=\"stylesheet\" type=\"text/css\" href=\"/test.css\"/></head><a id=\"first\">First Name: $first_name2</a><br>
<a id=\"last\">Last Name: $last_name2</a><br>
<a id=\"phone\">Phone Number: $phone_number2</a>
<img id=\"output\"src=\"lightblue.jpg\"></html>";}
/*This code would print out to the screen with html. It would only show the record that was just inserted(meaning part 1 code)*/
?>
I got confused on what field they are using in the members table.
the file above is what they gave me I just added the codes except for the mysql connect I didn't do that they did.
The file above say's the fields are First name, Last name, Phone Number. How ever they gave me an sql file which I will show below.
This sql files shows that the field names are firstname, lastname, phone .
I used the sql fields thinking this was correct.
here is the file:
SQL
-- phpMyAdmin SQL Dump
-- version 2.8.0.3
-- [url=http://www.phpmyadmin.net]http://www.phpmyadmin.net[/url]
--
-- Host: localhost
-- Generation Time: Jan 17, 2007 at 05:24 PM
-- Server version: 4.0.26
-- PHP Version: 4.4.2
--
-- Database: `test`
--
-- --------------------------------------------------------
--
-- Table structure for table `members`
--
CREATE TABLE `members` (
`id` int(11) NOT NULL auto_increment,
`firstname` varchar(50) default NULL,
`lastname` varchar(50) default NULL,
`phone` varchar(50) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
UNIQUE KEY `firstname_2` (`firstname`),
UNIQUE KEY `lastname` (`lastname`),
KEY `firstname` (`firstname`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;
--
-- Dumping data for table `members`
--
INSERT INTO `members` (`id`, `firstname`, `lastname`, `phone`) VALUES (3, 'moo', 'moo', 'moo'),
(4, 'mooo', 'moooo', 'moooo'),
(5, 'jjj', 'jjj', 'jjj'),
(6, 'hh', 'h', 'hhh'),
(7, 'ggg', 'gg', 'gggg'),
(8, '', '', ''),
(9, 'uity', 'uityuit', 'iuty'),
(10, 'hhh', 'hh', 'hhh'),
(11, 'll', 'll', 'lll'),
(12, 'jimmy', 'dickinson', '123234142'),
(13, 'jjjj', 'jjjjjjjj', 'jjj');
Is there anything else that is wrong???
This post has been edited by hockey97: 2 Oct, 2008 - 04:10 PM
2 Oct, 2008 - 04:01 PM
| 