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 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Dec 2011
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to make a spreadsheet like form

    I am making a spreadsheet form. I need it to have editable cells like in MS Excel, and I got the HTML and CSS to get the layout, but I can't figure out how to make it save the input values. I keep getting the following error every time I try to save input data: "Not Found. The requested URL /process.php was not found on this server."

    I need the form to be editable by me and my coworkers, just like an Excel spreadsheet. I think it is a Javascript I need, but not sure. Can anyone help?

    This is the code I got so far (Thank you!):

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>SLO Matrix/title>
    <style type=text/css'>
    table {
    border-collapse: collapse;
    border: 1px solid black;
    } // style for thin border around the cells and collapse
    th {
    border: 1px solid black;
    width: 10%;
    }
    td {
    width: 10%;
    border: 1px solid black;
    } // width for left columns




    </style>
    </head>
    <form action="/process.php" method="get"slomatrix">
    <table cellspacing="0">
    <caption>
    SLO Matrix
    </caption>
    <tr>
    <th scope="col"> Name </th>
    <th scope="col"> Course </th>
    <th scope="col"> Old SLO </th>
    <th scope="col"> Updated SLO </th>
    </tr>
    <tr>
    <td><input type="text" name"teacherName1" /></td>
    <td><input type="text" name"courseName1" /></td>
    <td><input type="text" name"oldSlo1" /></td>
    <td><input type="text" name"updatedSlo1" /></td>
    </tr>
    <tr>
    <td><input type="text" name"teacherName2" /></td>
    <td><input type="text" name"courseName2" /></td>
    <td><input type="text" name"oldSlo2" /></td>
    <td><input type="text" name"updatedSlo2" /></td>
    </tr>
    </table>
    <input type="submit" class="save" value="Save" />
    </form>

    <body>
    </body>
    </html>

  • #2
    Senior Coder
    Join Date
    Aug 2010
    Location
    High Point, NC
    Posts
    3,335
    Thanks
    5
    Thanked 363 Times in 360 Posts
    The error is self explainatory. Its looking for a page called process.php, which is the action the form is trying write too. To pass form data, a standard html form is not enough. You need to pass the input values using the name attribute of each input field.

    So my question is do you have a process.php page? and is it uploaded to the server?
    Teed

  • #3
    New Coder
    Join Date
    Apr 2011
    Location
    Canada
    Posts
    23
    Thanks
    0
    Thanked 2 Times in 2 Posts
    What you need is another file called process.php where PHP will save the data that you have entered. The issue you are having is not an HTML one, but PHP. You might take a look at http://php.about.com/od/phpbasics/ss/mysql_files.htm to learn how to save the data in a MySQL database using PHP, which is how I would recommend saving the information.

    Also, method="get"slomatrix", what are you trying to do with the slomatrix" randomly added at the end there, it doesn't really fit / won't do anything.


  •  

    Tags for this Thread

    Posting Permissions

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