• Could you give me an idea of where I should start to set up a database with some 15 fields at the server (JustHost)?

    I have created the database but have no idea where to go from here…

    Thank you

    qim

Viewing 6 replies - 1 through 6 (of 6 total)
  • What are you trying to accomplish?

    in you would like to create a table, you need to goto phpmyadmin or some sort of mysql interface to create data in your new database.

    Then you can add a table, and insert fieldnames.

    Thread Starter qim

    (@qim)

    Hola gabriel

    In fact, I think I’ve solved the first part by setting up a table in the server through phoMyAdmin (incidentally a password that can have numbers and letters should be classified as what? Int, varchar, ??)

    What I think and would apprciate it if you could confirm is to do something to my HTML file to marry the class of fields to what is in the server database table, i.e. name (varchar), should have a complimentary code in html. is this correct?

    then, I guess I need to do something in php (never did!) to get the things talking to each other… I am doing a register page and when the submit button is pressed hopefullu the data will end up in the server database.

    Am I making sense?

    This forum is for wordpress. What I think you are trying to do is create a simple registration page, you can do this with wordpress and some plugins like contact form 7.

    But if you are trying to create this using html/php/mysql you need to create php form proccessor page, html form page.

    the html form page will contain the user registration form and the processor page will contain the php data. you need to connect your php script to the database and then process the data from the form and insert into the database.

    Look research php/mysql

    Thread Starter qim

    (@qim)

    I tried the WP plugins and they did not do what I wanted. I am vey new to all this (less than 2 weeks…)Could you point me in the right direction with one example, and i will try to do the rest? For instance one of th15 fields of my registry webpage is “Agency name” and in the server database table it is also “Agency name”. What do I have to do with the HTML code for the eventual php to be able to read it and link with the server?

    At the monet the line goes like this:

    <table style="width: auto; text-align: center; margin: 0 auto;">
        <tr>
            <td>
               Agency name
            </td>
            <td>
               IATA number
            </td>
        </tr>
        <tr>
            <td>
                <input type="text" />
            </td>
            <td>
                <input type="text" />
            </td>
        </tr>
        <tr>
            <td>
                City
            </td>
            <td>
                Country
            </td>
        </tr>
        <tr>
            <td>
                <input type="text" />
            </td>
            <td>
                <input type="text" />
            </td>
        </tr>
    </table>

    you need to create a form. Then point the form submission data to your form processor.

    <form action=”processor.php” method=”POST”>
    ENTER your HTML form inputs here
    </form>

    google is the best place to start. Search create contact form with php or create registration form with php

    Thread Starter qim

    (@qim)

    Gracias, Gabriel. I’ll have ago at it.

    qim

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘database in server’ is closed to new replies.