Jump to content

irene169

Members
 View Profile  See their activity

  • Posts

    10

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

irene169's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. irene169
    Anyone can help? when we are displaying the data in text field inside an updating form, the code would be like this : First Name: <input type="text" name="ud_first" value="<? echo $first; ?>"> Last Name: <input type="text" name="ud_last" value="<? echo $last; ?>"> however, when it comes to the radio buttons or drop down menu, how should i write the code?? should i make it like this? --> <label> <input name="gender" type="radio" value="male" checked="<?php echo $gender;?>"/> </label> Male <label> <input name="gender" type="radio" value="female" checked="<?php echo $gender;?>"/> Female</label> and <label> <select name="prof"> <option value="<?php echo $prof; ?>" selected="selected"> <?php echo $prof?> </option> <option value="General Staff"> General Staff</option> <option value="Executive"> Executive</option> <option value="Senior Executive"> Senior Executive</option> <option value="Supervisor"> Supervisor</option> <option value="Junior Management"> Junior Management</option> <option value="Others"> Others</option> </select> </label> Your help would be highly appreciated...thanks..
  2. irene169
    Thanks a lot.............thanks a million...... :).... it works....:D....
  3. irene169
    i dunno why my session in the page couldnt work.. once i click on the login button after i insert the username and password...it jz show me this --> -------------------------------------------------------------------------------------------------------------------- Warning: Cannot send session cookie - headers already sent by (output started at c:\phpdev\www\new\session_assign.php:5) in c:\phpdev\www\new\session_assign.php on line 27 Warning: Cannot send session cache limiter - headers already sent (output started at c:\phpdev\www\new\session_assign.php:5) in c:\phpdev\www\new\session_assign.php on line 27 Welcome to Advance2004 Sdn. Bhd. , shian Click here to view the shopping catalog. --> Start Shopping -------------------------------------------------------------------------------------------------------------------- it does show me the session name and message that i want.. but how can i get rid of the warning??... is there any error ??... here is my coding --> [u]form coding [/u] ------------------------------------------------------------------------------------------------------------------------ <html> <head> <title>Customer Log-in</title> <p align="center"> <font size=10 face="Verdana"> Customer Login </font> </p> <br> <br> <p align="center"> <font face="Arial Black" size=3 color=483d8b> <form action="session_assign.php" method="POST"> <label for="username"> Username: </label> <input type="text" name="username" size="20" max length="30"> <br> <br> <br> <label for="pw">Password:</label> <input type="password" name="pw" id="pw"> <br> <br> <input type="submit" value="Login"><a href="mainpage"></a> </form> </p> <br> <br> <p align="center"> <font face="Rockwell Extra Bold" size=5 color=fa8072> New User? <a href=register.html>Click here</a> </font> </p> </body> </html> --------------------------------------------------------------------------------------------------------------------- [u]php coding : [/u] --------------------------------------------------------------------------------------------------------------------- <html> <title>User Login Status</title> <body bgcolor="lightblue"> <?php $dbase="customer1"; $tname="cus_login"; mysql_connect('localhost') or die("Cannot connect to the Database"); mysql_select_db("$dbase") or die ("Cannot select Database"); $user=$_REQUEST['username']; $password=$_REQUEST['pw']; $query="SELECT * FROM cus_login WHERE user_id='$user' and user_pw='$password'"; $result=mysql_query($query); $coun=mysql_num_rows($result); if($coun==1) { session_start(); $_session['user']=$user; echo "Welcome to Advance2004 Sdn. Bhd. ,&nbsp;" . $_session['user'] ; echo "<br>Click here to view the shopping catalog. -->"; ?> <a href="shopping.php"> Start Shopping </a> <?php } else { ?> <p align="center"> <font face="rockwell extra bold" size=6> Login Status </font> <br> <hr> <br> <p align="center"> <font face="arial" size="4"> Wrong User ID or Password Please click here to login again --> <a href="login_assign.php">Login Form</a> <br> If you are not a member, please click here to register. --> <a href="assign3.php">Registration Form</a> </font> </p> <?php } ?> </body> </html> --------------------------------------------------------------------------------------------------------------------- hope some1 can help me in this... thanks a million... regards.. irene
  4. irene169
    so...i need to have a new table in my database to accept all the input fr the form and then displaying all the items that the customer's select in the new page......this new page is taking the data from the new table...right??...calculation can be done within this page ya??....coz i need to sum up all the items' cost... the customer_id in the new table... should i get the data from the session of that page ??...or some where else?.... actually... im quite slow in learning... sorry... hope u can give me more ideas..... thanks a lot... regards.. irene
  5. irene169
    again...i have problem in developing the shopping cart... [b]the database:[/b] create database product; create table item( prodID int(5) not null, prodName varchar(20), prodPrice float(6), PRIMARY KEY (prodID) )TYPE = MyISAM; insert into item( prodID, prodName, prodPrice) values(101, 'Kingston', 29.90); insert into item( prodID, prodName, prodPrice) values(104, 'Apache', 39.90); insert into item( prodID, prodName, prodPrice) values(104, 'Toshiba', 49.90); insert into item( prodID, prodName, prodPrice) values(104, 'Panasonic', 39.90); [b]here is my code:[/b] <html> <head> <title>Products</title> </body> <p><CENTER><FONT SIZE=+3 FONT COLOR="gold" FACE="Arial"><b><marquee>PRODUCTS .... PRODUCTS .... PRODUCTS</marquee></b></FONT><CENTER> <?php $connection=mysql_connect('localhost','root') or die ('Unable to connect'); mysql_select_db('product') or die ('Unable to select database!'); $query='SELECT*FROM item'; $result=mysql_query($query) or die ('Error in query:$query.'.mysql_error()); if (mysql_num_rows($result)> 0) { ?> <table border="1" align=center> <tr><td>&nbsp</td><td><b>ID</b></td><td><b>NAME</b></td><td><b>PRICE</b></td><td>< b>Quantity</b></td></tr> <?php while($row=mysql_fetch_row($result)) { $Id=$row[0]; $prod[$Id]['desc']=$row[1]; $prod[$Id]['price']=$row[2]; echo'<tr><td><a href="description.html"><img src="1.jpg" height="130" width="140" align="left"></td>'; echo '<td>'.$Id. '</td>'; echo '<td>'.$prod[$Id]['desc'] . '</td>'; echo '<td>'.$prod[$Id]['price'] . '</td>'; echo '<td><form action="cart.php" method="POST"> <input size=3 type="text" name=\"a_qty[".$Id."]\"></td>'; echo '</tr>'; } ?> <tr><td colspan="3"></td> <td colspan="2"><input type="submit" name="add" value="Add items to cart"></td> </form> </table> <?php } else { echo 'No rows Found!'; } mysql_free_result($result); mysql_close($connection); ?> </body> </head> </html> actually...i have no problem with the code above... but can i know... how can i get the quantity being insert in the form...and sent the input into database..??... wat should i do the next?...i mean how can i get the data from the customer after the click "add items to cart" ...?? the assignment question is like this --> 2. Shopping Cart Module(15 Marks) a. Display the list of products available for the user to buy online. (5 Marks) b. If he selects items put them in the shopping cart. And display the list of items selected by the customer along with its cost. (5 Marks) c. Allow the customer to update or clear the shopping cart. (5 Marks) i have been stucked here..can any1 help me??..please......... thanks regards... irene
  6. irene169
    [!--quoteo(post=370552:date=May 2 2006, 09:17 AM:name=craygo)--][div class=\'quotetop\']QUOTE(craygo @ May 2 2006, 09:17 AM) [snapback]370552[/snapback][/div][div class=\'quotemain\'][!--quotec--] ok you could have kept the same code. The problem was you named your submit button register and in your code you were looking for submit. If you change this line: [code]if(!$_POST['submit'])[/code] to this [code]if(!$_POST['register'])[/code] You will be all set Ray [/quote] i ll try it... thanks a lot...ray..
  7. irene169
    dear all...problem solved..... thanks a million for ken, ray and radox... thanks a lot for u guys' help.... i just separate the coding without using <?$_SERVER=['PHP_SELF']?> thanks for everything... ...
  8. irene169
    [!--quoteo(post=370457:date=May 1 2006, 10:22 PM:name=craygo)--][div class=\'quotetop\']QUOTE(craygo @ May 1 2006, 10:22 PM) [snapback]370457[/snapback][/div][div class=\'quotemain\'][!--quotec--] Are you getting any type of error?? Ray [/quote] hey ray... thanks for giving me reply... the page didnt show any error message...but whenever i click submit button...it still displaying the same page .. and all the input didnt go into my database table.. data base table is showed empty set... i saw my lecturer jz nw..she asked me to seperate the form and the php code .. i have already change it..still it's the same.. i will copy paste the coding again here.... regards.. irene
  9. irene169
    helo there.... i have some problem with my php scripts.....i dunno why the php that i run, it could not connect(i guess) to the database itself..coz..when i click submit..the input cannot be save into the database...wat's wrong it is i wonder.... hope some1 can help me in this...thanks... here is my php script: <html> <head><title> User Sign UP</title></head> <body bgcolor=f0fff0> <p align="center"> <font size="10" face="rockwell extra bold"> <br>User Sign Up<br><hr> </h1> </font> </p> <table> <tr><td><font face="arial" size=5><b>Register:</b> Enter Information </font> </td></tr> <tr><td><font face="arial" size=3><b>Your Personal Information</b> - <font face="arial" size=2>All fields are required</font> </td></tr> </table> <?php if(!$_POST['submit']) { ?> <form action = "<?=$SERVER['PHP_SELF']?>" method="POST"> <p align="center"> <table> <tr><td><font face="Arial">First Name : </font></td><td> <input type="text" size=20 name="fname"></td></tr> <tr><td><font face="Arial">Last Name : </font></td><td> <input type="text" size=20 name="lname"></td></tr> <tr><td><font face="arial"> Gender : </font></td> <td> <input name="gender" type="radio" value="m"><font face="arial" size=2>Male</font><br> <input name="gender" type="radio" value="f"><font face="arial" size=2> Female</font></td> </tr> <tr> <td><font face="arial">Date of Birth:</font> </td> <td> <select name="birthmonth"> <option value=""> -- month -- </option> <option value="01">Jan</option> <option value="02">Feb</option> <option value="03">Mar</option> <option value="04">Apr</option> <option value="05">May</option> <option value="06">Jun</option> <option value="07">Jul</option> <option value="08">Aug</option> <option value="09">Sep</option> <option value="10">Oct</option> <option value="11">Nov</option> <option value="12">Dec</option> </select> <select name="birthday"> <option value=""> -- day -- </option> <option value="01">1</option> <option value="02">2</option> <option value="03">3</option> <option value="04">4</option> <option value="05">5</option> <option value="06">6</option> <option value="07">7</option> <option value="08">8</option> <option value="09">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option value="13">13</option> <option value="14">14</option> <option value="15">15</option> <option value="16">16</option> <option value="17">17</option> <option value="18">18</option> <option value="19">19</option> <option value="20">20</option> <option value="21">21</option> <option value="22">22</option> <option value="23">23</option> <option value="24">24</option> <option value="25">25</option> <option value="26">26</option> <option value="27">27</option> <option value="28">28</option> <option value="29">29</option> <option value="30">30</option> <option value="31">31</option> </select> <select name="birthyear"> <option value=""> -- year -- </option> <option value="1990">1990</option> <option value="1989">1989</option> <option value="1988">1988</option> <option value="1987">1987</option> <option value="1986">1986</option> <option value="1985">1985</option> <option value="1984">1984</option> <option value="1983">1983</option> <option value="1982">1982</option> <option value="1981">1981</option> <option value="1980">1980</option> <option value="1979">1979</option> <option value="1978">1978</option> <option value="1977">1977</option> <option value="1976">1976</option> <option value="1975">1975</option> <option value="1974">1974</option> <option value="1973">1973</option> <option value="1972">1972</option> <option value="1971">1971</option> <option value="1970">1970</option> <option value="1969">1969</option> <option value="1968">1968</option> <option value="1967">1967</option> <option value="1966">1966</option> <option value="1965">1965</option> <option value="1964">1964</option> <option value="1963">1963</option> <option value="1962">1962</option> <option value="1961">1961</option> <option value="1960">1960</option> <option value="1959">1959</option> <option value="1958">1958</option> <option value="1957">1957</option> <option value="1956">1956</option> <option value="1955">1955</option> <option value="1954">1954</option> <option value="1953">1953</option> <option value="1952">1952</option> <option value="1951">1951</option> <option value="1950">1950</option> <option value="1949">1949</option> <option value="1948">1948</option> <option value="1947">1947</option> <option value="1946">1946</option> <option value="1945">1945</option> <option value="1944">1944</option> <option value="1943">1943</option> <option value="1942">1942</option> <option value="1941">1941</option> <option value="1940">1940</option> <option value="1939">1939</option> <option value="1938">1938</option> <option value="1937">1937</option> <option value="1936">1936</option> <option value="1935">1935</option> <option value="1934">1934</option> <option value="1933">1933</option> <option value="1932">1932</option> <option value="1931">1931</option> <option value="1930">1930</option> <option value="1929">1929</option> <option value="1928">1928</option> <option value="1927">1927</option> <option value="1926">1926</option> <option value="1925">1925</option> <option value="1924">1924</option> <option value="1923">1923</option> <option value="1922">1922</option> <option value="1921">1921</option> <option value="1920">1920</option> </select> </td></tr> <tr><td><font face="Arial">Street Address : &nbsp;&nbsp;&nbsp;&nbsp; </font> </td> <td><input type="text" size=20 name="add1"></td><tr> <tr><td></td><td><input type="text" size=20 name="add2"></td><tr> <tr><td></td><td><input type="text" size=20 name="add3"></td><tr> <tr><td><font face="Arial"> City:</font> </td><td> <input type="text"size=20 name="city"><br></td></tr> <tr><td><font face="arial">Zip/ Postal Code :</font></td> <td><input type="text" size=20 name="zcode"></td> </tr> <tr><td><font face="arial">Country : </font></td> <td><select name="country"><option value=""> -- Country -- </option> <option value="US">UNITED STATES</option> <option value="CA">CANADA</option> <option value="AF">Afghanistan</option> <option value="AL">Albania</option> <option value="DZ">Algeria</option> <option value="AS">American Samoa</option> <option value="AD">Andorra</option> <option value="AO">Angola</option> <option value="AI">Anguilla</option> <option value="AQ">Antarctica</option> <option value="AG">Antigua and Barbuda</option> <option value="AR">Argentina</option> <option value="AM">Armenia</option> <option value="AW">Aruba</option> <option value="AU">Australia</option> <option value="AT">Austria</option> <option value="AZ">Azerbaijan</option> <option value="BS">Bahamas</option> <option value="BH">Bahrain</option> <option value="BD">Bangladesh</option> <option value="BB">Barbados</option> <option value="BY">Belarus</option> <option value="BE">Belgium</option> <option value="BZ">Belize</option> <option value="BJ">Benin</option> <option value="BM">Bermuda</option> <option value="BT">Bhutan</option> <option value="BO">Bolivia</option> <option value="BA">Bosnia-Herzegovina</option> <option value="BW">Botswana</option> <option value="BV">Bouvet Island</option> <option value="BR">Brazil</option> <option value="IO">British Indian Ocean Territory</option> <option value="BN">Brunei Darussalam</option> <option value="BG">Bulgaria</option> <option value="BF">Burkina Faso</option> <option value="BI">Burundi</option> <option value="KH">Cambodia</option> <option value="CM">Cameroon</option> <option value="CV">Cape Verde</option> <option value="KY">Cayman Islands</option> <option value="CF">Central African Republic</option> <option value="TD">Chad</option> <option value="CL">Chile</option> <option value="CN">China</option> <option value="CX">Christmas Island</option> <option value="CC">Cocos (Keeling) Islands</option> <option value="CO">Colombia</option> <option value="KM">Comoros</option> <option value="CG">Congo</option> <option value="CD">Congo (Democratic Republic)</option> <option value="CK">Cook Islands</option> <option value="CR">Costa Rica</option> <option value="HR">Croatia</option> <option value="CU">Cuba</option> <option value="CY">Cyprus</option> <option value="CZ">Czech Republic</option> <option value="DK">Denmark</option> <option value="DJ">Djibouti</option> <option value="DM">Dominica</option> <option value="DO">Dominican Republic</option> <option value="TP">East Timor</option> <option value="EC">Ecuador</option> <option value="EG">Egypt</option> <option value="SV">El Salvador</option> <option value="GQ">Equatorial Guinea</option> <option value="ER">Eritrea</option> <option value="EE">Estonia</option> <option value="ET">Ethiopia</option> <option value="FK">Falkland Islands</option> <option value="FO">Faroe Islands</option> <option value="FJ">Fiji</option> <option value="FI">Finland</option> <option value="FR">France</option> <option value="FX">France (European Territory)</option> <option value="GF">French Guiana</option> <option value="TF">French Southern Territories</option> <option value="GA">Gabon</option> <option value="GM">Gambia</option> <option value="GE">Georgia</option> <option value="DE">Germany</option> <option value="GH">Ghana</option> <option value="GI">Gibraltar</option> <option value="GR">Greece</option> <option value="GL">Greenland</option> <option value="GD">Grenada</option> <option value="GP">Guadeloupe</option> <option value="GU">Guam</option> <option value="GT">Guatemala</option> <option value="GN">Guinea</option> <option value="GW">Guinea Bissau</option> <option value="GY">Guyana</option> <option value="HT">Haiti</option> <option value="HM">Heard and McDonald Islands</option> <option value="VA">Holy See (Vatican)</option> <option value="HN">Honduras</option> <option value="HK">Hong Kong</option> <option value="HU">Hungary</option> <option value="IS">Iceland</option> <option value="IN">India</option> <option value="ID">Indonesia</option> <option value="IR">Iran</option> <option value="IQ">Iraq</option> <option value="IE">Ireland</option> <option value="IL">Israel</option> <option value="IT">Italy</option> <option value="CI">Ivory Coast (Cote D'Ivoire)</option> <option value="JM">Jamaica</option> <option value="JP">Japan</option> <option value="JO">Jordan</option> <option value="KZ">Kazakhstan</option> <option value="KE">Kenya</option> <option value="KI">Kiribati</option> <option value="KW">Kuwait</option> <option value="KG">Kyrgyzstan</option> <option value="LA">Laos</option> <option value="LV">Latvia</option> <option value="LB">Lebanon</option> <option value="LS">Lesotho</option> <option value="LR">Liberia</option> <option value="LY">Libya</option> <option value="LI">Liechtenstein</option> <option value="LT">Lithuania</option> <option value="LU">Luxembourg</option> <option value="MO">Macau</option> <option value="MK">Macedonia</option> <option value="MG">Madagascar</option> <option value="MW">Malawi</option> <option value="MY">Malaysia</option> <option value="MV">Maldives</option> <option value="ML">Mali</option> <option value="MT">Malta</option> <option value="MH">Marshall Islands</option> <option value="MQ">Martinique</option> <option value="MR">Mauritania</option> <option value="MU">Mauritius</option> <option value="YT">Mayotte</option> <option value="MX">Mexico</option> <option value="FM">Micronesia</option> <option value="MD">Moldova</option> <option value="MC">Monaco</option> <option value="MN">Mongolia</option> <option value="MS">Montserrat</option> <option value="MA">Morocco</option> <option value="MZ">Mozambique</option> <option value="MM">Myanmar</option> <option value="NA">Namibia</option> <option value="NR">Nauru</option> <option value="NP">Nepal</option> <option value="NL">Netherlands</option> <option value="AN">Netherlands Antilles</option> <option value="NC">New Caledonia</option> <option value="NZ">New Zealand</option> <option value="NI">Nicaragua</option> <option value="NE">Niger</option> <option value="NG">Nigeria</option> <option value="NU">Niue</option> <option value="NF">Norfolk Island</option> <option value="KP">North Korea</option> <option value="MP">Northern Mariana Islands</option> <option value="NO">Norway</option> <option value="OM">Oman</option> <option value="PK">Pakistan</option> <option value="PW">Palau</option> <option value="PS">Palestinian Territory</option> <option value="PA">Panama</option> <option value="PG">Papua New Guinea</option> <option value="PY">Paraguay</option> <option value="PE">Peru</option> <option value="PH">Philippines</option> <option value="PN">Pitcairn</option> <option value="PL">Poland</option> <option value="PF">Polynesia</option> <option value="PT">Portugal</option> <option value="PR">Puerto Rico</option> <option value="QA">Qatar</option> <option value="RE">Reunion</option> <option value="RO">Romania</option> <option value="RU">Russian Federation</option> <option value="RW">Rwanda</option> <option value="GS">S. Georgia &amp; S. Sandwich Isls.</option> <option value="SH">Saint Helena</option> <option value="KN">Saint Kitts &amp; Nevis Anguilla</option> <option value="LC">Saint Lucia</option> <option value="PM">Saint Pierre and Miquelon</option> <option value="VC">Saint Vincent &amp; Grenadines</option> <option value="WS">Samoa</option> <option value="SM">San Marino</option> <option value="ST">Sao Tome and Principe</option> <option value="SA">Saudi Arabia</option> <option value="SN">Senegal</option> <option value="SC">Seychelles</option> <option value="SL">Sierra Leone</option> <option value="SG">Singapore</option> <option value="SK">Slovakia</option> <option value="SI">Slovenia</option> <option value="SB">Solomon Islands</option> <option value="SO">Somalia</option> <option value="ZA">South Africa</option> <option value="KR">South Korea</option> <option value="ES">Spain</option> <option value="LK">Sri Lanka</option> <option value="SD">Sudan</option> <option value="SR">Suriname</option> <option value="SZ">Swaziland</option> <option value="SE">Sweden</option> <option value="CH">Switzerland</option> <option value="SY">Syrian Arab Republic</option> <option value="TW">Taiwan</option> <option value="TJ">Tajikistan</option> <option value="TZ">Tanzania</option> <option value="TH">Thailand</option> <option value="TG">Togo</option> <option value="TK">Tokelau</option> <option value="TO">Tonga</option> <option value="TT">Trinidad and Tobago</option> <option value="TN">Tunisia</option> <option value="TR">Turkey</option> <option value="TM">Turkmenistan</option> <option value="TC">Turks and Caicos Islands</option> <option value="TV">Tuvalu</option> <option value="UG">Uganda</option> <option value="UA">Ukraine</option> <option value="AE">United Arab Emirates</option> <option value="GB">United Kingdom</option> <option value="UY">Uruguay</option> <option value="UM">USA Minor Outlying Islands</option> <option value="UZ">Uzbekistan</option> <option value="VU">Vanuatu</option> <option value="VE">Venezuela</option> <option value="VN">Vietnam</option> <option value="VG">Virgin Islands (British)</option> <option value="VI">Virgin Islands (USA)</option> <option value="WF">Wallis and Futuna Islands</option> <option value="EH">Western Sahara</option> <option value="YE">Yemen</option> <option value="YU">Yugoslavia</option> <option value="ZR">Zaire</option> <option value="ZM">Zambia</option> <option value="ZW">Zimbabwe</option></select></td> </tr> <tr><td><font face="arial"> Primary Telephone </font></td> <td><input type="text" size=2 name="phone1"> - <input type="text" size=10 name="phone2"></td></tr> <tr><td><font face="arial"> Email Address : </font></td> <td><input type="text" size=20 name="email"></td> </tr> </table> </p> <br> <hr> <br> <table> <tr><td><font face="arial"><b>Your User ID and Password </b> </font> - <font face="arial" size=2> All fields are required </td><tr> </table> <p align="center"> <table> <tr><td><font face="arial">Create an UserID : </font></td> <td><input type="text" size=20 name="userID"></td> </tr> <tr><td><font face="arial"> Password : </font></td> <td><input type="password" size=20 name="pw"></td> </tr> <tr><td><font face="arial"> Confirm Password : </font></td> <td><input type="password" size=20 name="pw2"></td> </tr> <tr><td><font face="arial"> Secret Question : </font></td> <td><select name="SecretQ"> <option value="0">Pick a suggested question...</option> <option value="1">What street did you grow up on?</option> <option value="2">What is your mother's maiden name?</option> <option value="3">What is the name of your first school?</option> <option value="4">What is your pet's name?</option> <option value="5">What is your father's middle name?</option> <option value="6">What is your school's mascot?</option> </select> <br></td></tr> <tr> <td></td> <td> <font face="arial" size=2> You will be asked for the answer to your secret question if you forget your password. </font> </td></tr> <tr><td><font face="arial"> Secret Answer : </font></td> <td><input type="text" name="SecretA" size=20> </td></tr> </table> <br> <p align="center"> <input type="submit" value="Register" name="register">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <input type="reset" value="Reset" name="reset"> </p> </form> <?php } else { $fname =$_POST['fname']; $lname =$_POST['lname']; $gender =$_POST['gender']; $bmonth =$_POST['birthmonth']; $bday =$_POST['birthday']; $byear =$_POST['birthyear']; $add1 =$_POST['add1']; $add2 =$_POST['add2']; $add3 =$_POST['add3']; $city =$_POST['city']; $zcode =$_POST['zcode']; $country =$_POST['country']; $phone1 =$_POST['phone1']; $phone2 =$_POST['phone2']; $email =$_POST['email']; $userID =$_POST['userID']; $pw =$_POST['pw']; $connection = mysql_connect('localhost','root') or die ('Unable to open a connection with database server'); mysql_select_db('cus_info') or die ('Unable to select database'); $query = "INSERT INTO cus_info(user_id, user_pw, f_name, l_name, gender, bmonth, bday, byear, add1, add2, add3, city, zcode, country, phone1, phone2, email) VALUES ('$userID', '$pw', '$fname', '$lname', '$gender', '$bmonth', '$bday', '$byear', '$add1', '$add2', '$add3', '$city', '$zcode', '$country', '$phone1', '$phone2', '$email')"; $result = mysql_query($query) or die ("Error in query: $query . " . mysql_error()); echo " User information has been successfully registered !"; echo mysql_affected_rows(); mysql_close($connection); } ?> <br> <br> <hr> <p align="center"> <font size=2 face=arial color=8b6969> Copyright © 2002-2004 <br> Advance2004 Sdn. Bhd All Rights Reserved.<br> ThumbDrive Trademark <br> Registered in Malaysia.<br> </p> </body> </html>
  10. irene169
    [b]EDITED BY WILDTEEN88: PLEASE POST YOUR PROBLEM IN A NEW THREAD RATHER THAN IN A CURRENT THREAD WHICH YOUR PROBLEM DOESN'T RELATE TO THANK YOU[/b]
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.