Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts

    Why the data is not in my database files.?

    Hi...

    i need some help here..

    i am creating a website for my final project... which it is reservation system.. after i've key in all the data and click on submit button, it's link to another page... and then when i try open the database. whatever data i've keyed in earlier is not in the database files...

    what should i do? help me..

    im using windows XP , i've also installed IIS... and i've already set the the data source (ODBC ) ... what else should i have to set ?

  • #2
    ess
    ess is offline
    Regular Coder
    Join Date
    Oct 2006
    Location
    United Kingdom
    Posts
    865
    Thanks
    7
    Thanked 29 Times in 28 Posts
    Are you sure that the data has been submitted successfully to the database?

    What programming language are you using to add data to the database?

    Please submit a sample so we can help you out.

  • #3
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,631
    Thanks
    4
    Thanked 147 Times in 138 Posts
    what database are you using? mysql? mssql? oracle? access?

  • #4
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    i've save this as.. Reservation.htm



    <html>

    <head>
    <title>Room Reservation</title>
    <base target="_self">
    <script Language="JavaScript">
    <!--
    function Form1_Validator(theForm)
    {

    var alertsay = ""; // define for long lines
    // alertsay is not necessary for your code,
    // but I need to break my lines in multiple lines
    // so the code won't extend off the edge of the page

    // check if ReservationID field is blank
    if (theForm.id.value == "")
    {
    alert("Please enter a value for the \"Reservation ID\" field.");
    theForm.id.focus();
    return (false);
    }

    // only allow numbers to be entered
    var checkOK = "0123456789";
    var checkStr = theForm.id.value;
    var allValid = true;
    var allNum = "";
    for (i = 0; i < checkStr.length; i++)
    {
    ch = checkStr.charAt(i);
    for (j = 0; j < checkOK.length; j++)
    if (ch == checkOK.charAt(j))
    break;
    if (j == checkOK.length)
    {
    allValid = false;
    break;
    }
    if (ch != ",")
    allNum += ch;
    }
    if (!allValid)
    {
    alert("Please enter only digit characters in the \"Reservation ID\" field.");
    theForm.id.focus();
    return (false);
    }


    // check if name field is blank
    if (theForm.txtname.value == "")
    {
    alert("Please enter a value for the \"Name\" field.");
    theForm.txtname.focus();
    return (false);
    }

    // allow ONLY alphabetic keys, no symbols or punctuation
    // this can be altered for any "checkOK" string you desire
    var checkOK = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
    var checkStr = theForm.txtname.value;
    var allValid = true;
    for (i = 0; i < checkStr.length; i++)
    {
    ch = checkStr.charAt(i);
    for (j = 0; j < checkOK.length; j++)
    if (ch == checkOK.charAt(j))
    break;
    if (j == checkOK.length)
    {
    allValid = false;
    break;
    }
    }
    if (!allValid)
    {
    alert("Please enter only alphabetic characters in the \"Name\" field.");
    theForm.txtname.focus();
    return (false);
    }

    // check if the street address field is blank
    if (theForm.txtadd.value == "")
    {
    alert("Please enter a value for the \"Street Address\" field.");
    theForm.txtadd.focus();
    return (false);
    }

    // check if city field is blank
    if (theForm.txtcity.value == "")
    {
    alert("Please enter a value for the \"City\" field.");
    theForm.txtcity.focus();
    return (false);
    }

    // check if state field is blank
    if (theForm.txtstate.value == "")
    {
    alert("Please enter a value for the \"State or Province\" field.");
    theForm.txtstate.focus();
    return (false);
    }

    // check if zip code field is blank
    if (theForm.txtzip.value == "")
    {
    alert("Please enter a value for the \"Zip Code\" field.");
    theForm.txtzip.focus();
    return (false);
    }

    // only allow numbers to be entered
    var checkOK = "0123456789";
    var checkStr = theForm.txtzip.value;
    var allValid = true;
    var allNum = "";
    for (i = 0; i < checkStr.length; i++)
    {
    ch = checkStr.charAt(i);
    for (j = 0; j < checkOK.length; j++)
    if (ch == checkOK.charAt(j))
    break;
    if (j == checkOK.length)
    {
    allValid = false;
    break;
    }
    if (ch != ",")
    allNum += ch;
    }
    if (!allValid)
    {
    alert("Please enter only digit characters in the \"zip code\" field.");
    theForm.txtzip.focus();
    return (false);
    }

    // check if country field is blank
    if (theForm.txtcountry.value == "")
    {
    alert("Please enter a value for the \"Country\" field.");
    theForm.txtcountry.focus();
    return (false);
    }

    // check if email field is blank
    if (theForm.txtemail.value == "")
    {
    alert("Please enter a value for the \"Email\" field.");
    theForm.txtemail.focus();
    return (false);
    }

    // test if valid email address, must have @ and .
    var checkEmail = "@.";
    var checkStr = theForm.txtemail.value;
    var EmailValid = false;
    var EmailAt = false;
    var EmailPeriod = false;
    for (i = 0; i < checkStr.length; i++)
    {
    ch = checkStr.charAt(i);
    for (j = 0; j < checkEmail.length; j++)
    {
    if (ch == checkEmail.charAt(j) && ch == "@")
    EmailAt = true;
    if (ch == checkEmail.charAt(j) && ch == ".")
    EmailPeriod = true;
    if (EmailAt && EmailPeriod)
    break;
    if (j == checkEmail.length)
    break;
    }
    // if both the @ and . were in the string
    if (EmailAt && EmailPeriod)
    {
    EmailValid = true
    break;
    }
    }
    if (!EmailValid)
    {
    alert("The \"E-mail\" field must contain an \"@\" and a \".\".");
    theForm.txtemail.focus();
    return (false);
    }

    // check if no drop down has been selected
    if (theForm.card.selectedIndex < 0)
    {
    alert("Please select one of the \"Credit Cards\" options.");
    theForm.card.focus();
    return (false);
    }

    // check if the first drop down is selected, if so, invalid selection
    if (theForm.card.selectedIndex == 0)
    {
    alert("The first \"Credit Card\" option is not a valid selection.Please select your Credit Card Selection");
    theForm.card.focus();
    return (false);
    }

    // check if card holder name field is blank
    if (theForm.txtcname.value == "")
    {
    alert("Please enter a value for the \"Cardholder's Name\" field.");
    theForm.txtcname.focus();
    return (false);
    }

    // check if both name and card holder name fields are the same
    if (theForm.txtname.value != theForm.txtcname.value)
    {
    alert("The Name and the Cardholder Name are not the same. Please re-enter!");
    theForm.txtcname.focus();
    return (false);
    }

    // check if card holder number field is blank
    if (theForm.txtcnumber.value == "")
    {
    alert("Please enter a value for the \"Credit Card Number\" field.");
    theForm.txtcnumber.focus();
    return (false);
    }

    // only allow 0-9 and hyphen to be entered
    var checkOK = "0123456789-,";
    var checkStr = theForm.txtcnumber.value;
    var allValid = true;
    var decPoints = 0;
    var allNum = "";
    for (i = 0; i < checkStr.length; i++)
    {
    ch = checkStr.charAt(i);
    for (j = 0; j < checkOK.length; j++)
    if (ch == checkOK.charAt(j))
    break;
    if (j == checkOK.length)
    {
    allValid = false;
    break;
    }
    if (ch != ",")
    allNum += ch;
    }
    if (!allValid)
    {
    alert("Please enter only digit characters in the \"Credit Card Number\" field.");
    theForm.txtcnumber.focus();
    return (false);
    }

    // check if no drop down or first drop down is selected, if so, invalid selection
    if (theForm.date_month.selectedIndex <= 0)
    {
    alert("Please select a month.");
    theForm.date_month.focus();
    return (false);
    }

    // check if no drop down or first drop down is selected, if so, invalid selection
    if (theForm.date_year.selectedIndex <= 0)
    {
    alert("Please select a year.");
    theForm.date_year.focus();
    return (false);
    }

    // because this is a sample page, don't allow to exit to the post action
    // comes in handy when you are testing the form validations and don't
    // wish to exit the page
    alertsay = "Please check all the data, if you satify...please click OK."
    alert(alertsay);
    return (true);
    // replace the above with return(true); if you have a valid form to submit to
    return (true);
    }
    //--></script>

    </head>

    <body bgcolor="#000066" text="#FFFFFF" link="#FFFF00" vlink="#FF00FF">

    <h1 align="center"><u>Room Reservation</u></h1>

    <p align="center">&nbsp;</p>

    <form METHOD="POST" ACTION="RoomOK.asp" onsubmit="return Form1_Validator(this)" name="Form1">

    <p>&nbsp;</p>

    <p><font size="4">Fill in the blank of&nbsp; your contact detail:-</font></p>
    <blockquote>
    <table width="497">
    <tr>
    <td ALIGN="right" width="168">Reservation ID</td>
    <td width="319">&nbsp;<input name="id" size="11"> </td>
    </tr>
    <tr>
    <td ALIGN="right" width="168"><em style="font-style: normal">Name:</em></td>
    <td width="319"><b>&nbsp;<input NAME="txtname" SIZE="35"> </b> </td>
    </tr>
    <tr>
    <td ALIGN="right" width="168"><em style="font-style: normal">Street Address:</em></td>
    <td width="319"><b>&nbsp;<input NAME="txtadd" SIZE="35"></b></td>
    </tr>
    <tr>
    <td ALIGN="right" width="168"><em style="font-style: normal">City:</em></td>
    <td width="319"><b>&nbsp;<input NAME="txtcity" SIZE="35"></b></td>
    </tr>
    <tr>
    <td ALIGN="right" width="168"><em style="font-style: normal">State/Province:</em></td>
    <td width="319"><b>&nbsp;<input NAME="txtstate" SIZE="35"> </b></td>
    </tr>
    <tr>
    <td ALIGN="right" width="168">
    <p align="left"><em style="font-style: normal">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    &nbsp;
    Zip/Postal Code:</em></td>
    <td width="319"><b>&nbsp;<input NAME="txtzip" SIZE="13" MAXLENGTH="12"></b></td>
    </tr>
    <tr>
    <td ALIGN="right" width="168"><em style="font-style: normal">Country:</em></td>
    <td width="319"><b>&nbsp;<input NAME="txtcountry" SIZE="25"></b></td>
    </tr>
    <tr>
    <td ALIGN="right" width="168"><em style="font-style: normal">E-mail:&nbsp; </em></td>
    <td width="319"><b>&nbsp;<input NAME="txtemail" SIZE="25"></b></td>
    </tr>
    </table>
    </blockquote>
    <p>&nbsp;</p>
    <p><b>Please provide the following Room Reservation information:</b></p>
    <table border="1" width="23%">
    <tr>
    <td width="100%" align="left" bgcolor="#FFFF00"><font size="4">&nbsp;
    <font color="#000000" size="4"><b><u>Room Types:</u></b></font></font></td>
    </tr>
    </table>
    <table border="1" width="767" height="238">
    <tr>
    <td width="252" height="42"><font size="3"><input type="checkbox" name="C1" value="ON">
    Dormitory&nbsp; - RM 8.00</font></td>
    <td width="499" height="42"><font size="3"><input type="checkbox" name="C5" value="ON">
    Triple Room with Fan - RM 30.00</font></td>
    </tr>
    <tr>
    <td width="252" height="42"><font size="3"><input type="checkbox" name="C2" value="ON">
    Private Dorm - RM 10.00</font></td>
    <td width="499" height="42"><font size="3"><input type="checkbox" name="C6" value="ON">
    Quadruple Room with Fan - RM 40.00</font></td>
    </tr>
    <tr>
    <td width="252" height="42"><font size="3"><input type="checkbox" name="C3" value="ON">
    Single Room with Fan - RM 20.00</font></td>
    <td width="499" height="42"><font size="3"><input type="checkbox" name="C7" value="ON">
    Double Room with Air Condition - RM 40.00</font></td>
    </tr>
    <tr>
    <td width="252" height="42"><font size="3"><input type="checkbox" name="C4" value="ON">
    Double Room with Fan - RM 25.00</font></td>
    <td width="499" height="42"><font size="3"><input type="checkbox" name="C8" value="ON">
    Triple Room with Air Condition - RM 50.00</font></td>
    </tr>
    <tr>
    <td width="757" height="81" colspan="2">
    <font size="3">Additional Chargers:</font>
    <p><font size="3"><input type="checkbox" name="C9" value="ON"> Pillow&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;
    <input type="text" name="txtExPillow" size="2">Quantity&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
    <input type="checkbox" name="C10" value="ON"> Mattress&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <input type="text" name="txtExMattress" size="2">Quantity&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>
    <input type="checkbox" name="C11" value="ON">
    Blanket&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb sp;
    <input type="text" name="txtExBlanket" size="2">Quantity&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</font></p>
    <p><font size="3">&nbsp;RM 5.00 for each Quantity.&nbsp;</font></p>
    <p>&nbsp;</td>
    </tr>
    <tr>
    <td width="252" height="27">
    <p align="right"><font face="Times New Roman">
    <em style="font-style: normal"><b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </b>
    Credit Card:</em></font></td>
    <td width="499" height="27">
    <b>
    <font face="Times New Roman">
    &nbsp;<select name="card" size="1">
    <option>Select Your Credit Card</option>
    <option value="V">Visa</option>
    <option value="M">MasterCard</option>
    <option value="D">Diner's Club</option>
    <option value="A">American Express</option>
    </select> </font> </b>
    </td>
    </tr>
    <tr>
    <td ALIGN="right" width="252" height="20"><font face="Times New Roman">
    <em style="font-style: normal">Cardholder Name:</em></font></td>
    <td width="499" height="20"><b><font face="Times New Roman">&nbsp;<input TYPE="TEXT" NAME="txtcname" SIZE="35"></font></b></td>
    </tr>
    <tr>
    <td ALIGN="right" width="252" height="26"><font face="Times New Roman">
    <em style="font-style: normal">Card Number:</em></font></td>
    <td width="499" height="26"><b><font face="Times New Roman">&nbsp;<input NAME="txtcnumber" SIZE="35"></font></b></td>
    </tr>
    <tr>
    <td ALIGN="right" width="252" height="25"><font face="Times New Roman">
    <em style="font-style: normal">Expiration Date:</em></font></td>
    <td width="499" height="25"><b><font face="Times New Roman">&nbsp;Month&nbsp;<select NAME="date_month">
    <option VALUE="0">----
    <option VALUE="1">January
    <option VALUE="2">Febuary
    <option VALUE="3">March
    <option VALUE="4">April
    <option VALUE="5">May
    <option VALUE="6">June
    <option VALUE="7">July
    <option VALUE="8">August
    <option VALUE="9">September
    <option VALUE="10">October
    <option VALUE="11">November
    <option VALUE="12">December
    </select> Year
    <select NAME="date_year">
    <option VALUE="0">----
    <option VALUE="2005">2005
    <option VALUE="2006">2006
    <option VALUE="2007">2007
    <option VALUE="2008">2008
    <option VALUE="2009">2009
    <option VALUE="2010">2010

    </select> </font> </b> </td>
    </tr>
    <tr>
    <td width="757" colspan="2" height="46">
    <p></p>
    </td>
    </tr>
    </table>
    <blockquote>
    <p>&nbsp;</p>
    </blockquote>
    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    <input TYPE="SUBMIT" VALUE="Submit "> &nbsp;&nbsp; <input TYPE="RESET" VALUE="Reset Form">
    <p>&nbsp;&nbsp;&nbsp;&nbsp;</p>
    <p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;& nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp ;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    Back to <a href="Indroduction.htm">HOME</a></p>
    <p>&nbsp;</p>
    </form>
    <hr>

    <p align="center"><font size="2" face="Times New Roman">
    Copyright© 2004 Sumitha@Sumi </font><font face="Wingdings" size="3">?</font><font size="2">&nbsp;
    </font><font size="2" face="Times New Roman"><small>All rights reserved.</small></font></p>

    <p align="center">&nbsp;</p>

    </body>

    </html>

  • #5
    New Coder
    Join Date
    Dec 2006
    Location
    Malaysia.
    Posts
    32
    Thanks
    19
    Thanked 0 Times in 0 Posts
    after click submit button on the reservation form, it's link to RoomOk.asp


    <html>

    <head>
    <title>Your Reservation Form has been submitted!!! </title>
    <!--#include file=connection.inc -->
    </head>

    <body background="BLACK01.GIF" text="#FFFFFF" link="#FFFF00" vlink="#FF00FF" bgproperties="fixed">
    <%
    'set the connection to the local server and the variable name is myconn
    'connection time out is 60 seconds
    'goto the control panel select the ODBC Data Sources(32 bits)
    'goto System DSN tab, select add
    'choose the Microsoft Access Driver (*.mdb)
    'enter the Data Source Name eg.IAD Project website
    'select the database you have created

    Set myconn=server.CreateObject("ADODB.Connection")
    myconn.open "Provider=Microsoft.jet.oledb.4.0;data source=" & Server.MapPath("Hotel Reservation.mdb")
    Set Rs=Server.Createobject("ADODB.Recordset")
    ssql="select * from Reservation"
    rs.open ssql,myconn,1,2

    Dim frmid,frmname,frmadd,frmcity,frmstate,frmzip,frmcountry,frmemail,frmdorm,frmdouble,frmtriple,frmdoub lea,frmtriplea,frmquad,frmsingle,frmpdorm,frmpillow,frmblanket,frmmattress,frmepillow,frmeblanket,fr memattress,frmcard,frmccard,frmcnumber
    frmid=request("id")
    frmname=request("txtname")
    frmadd=request("txtadd")
    frmcity=request("txtcity")
    frmstate=request("txtstate")
    frmzip=request("txtzip")
    frmcountry=request("txtcountry")
    frmemail=request("txtemail")
    frmpillow=request("C9")
    frmblanket=request("C11")
    frmmattress=request("C10")
    frmcard=request("card")
    frmccard=request("txtccard")
    frmcnumber=request("txtcnumber")
    frmmonth=request("date_month")
    frmdorm=request("C1")
    frmdouble=request("C4")
    frmtriple=request("C5")
    frmdoublea=request("C7")
    frmtriplea=request("C8")
    frmquad=request("C6")
    frmsingle=request("C3")
    frmpdorm=request("C2")
    frmepillow=request("txtExPillow")
    frmeblanket=request("txtExBlanket")
    frmemattress=request("txtExMattress")


    rs.addnew
    rs("ReservationID")=frmID
    rs("Name")=frmname
    rs("Street Address")=frmadd
    rs("City")=frmcity
    rs("State or Province")=frmstate
    rs("Zip Code")=frmzip
    rs("Country")=frmcountry
    rs("Email")=frmemail
    rs("Cardholder's Name")=frmccard
    rs("Credit Card Number")=frmcnumber
    rs("date_month")=frmmonth
    rs("Dorm")=frmdorm
    rs("Private Dorm")=frmpdorm
    rs("Double")=frmdouble
    rs("Triple")=frmtriple
    rs("Single")=frmsingle
    rs("Quad")=frmquad
    rs("Doublea")=frmdoublea
    rs("Triplea")=frmtriplea

    rs.update
    myconn.close
    set myconn=nothing
    %>

    <p>&nbsp;</p>
    <p>&nbsp;</p>
    <p><br>
    <font face="Monotype Corsiva" size="7">Your reservation details has been submitted...</font></p>
    <p><font face="Monotype Corsiva" size="7">The confirmation letter will be send
    at your Email account within 1 hours...&nbsp;</font></p>
    <p><font face="Monotype Corsiva" size="7">Thank you!!!&nbsp;&nbsp;</font></p>
    <p align="center">&nbsp;&nbsp; <font face="Times New Roman" size="4">Back to <a href="Indroduction.htm">HOME</a></font></p>
    <hr>
    <p align="center"><font size="2" face="Times New Roman">
    Copyright© 2004 Sumitha@Sumi </font><font face="Wingdings" size="3">?</font><font size="2">&nbsp;
    </font><font size="2" face="Times New Roman"><small>All rights reserved.</small></font></p>

    </body>

    </html>


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •