answersLogoWhite

0

You will need a table first, this can be created via your Database - PHPMyAdmin,

  • So, the first step would be to go to your Control Panel for your website, down to PHPMyAdmin and then to the database you are going to be creating the table in
  • Once there, you should see an option at the bottom of your page, not in the left hand menu. 'Create new table on database NAMEOFDATABASE'
  • Name the table, Remember, names of tables shouldn't have spaces, use underscores if you need a space. You will also need to input the amount of fields.
  • Once the fields are correctly named and whatnot, you can start thinking about inputting data into the table.
  • Go to your page editor for a php file you should have created. You should know a little about PHP if you're wanting to input items with PHP, so, let's get to Inputting.

Inputting data in PHP - MySQL

  • Say you've created a registration form, you have all the fields filled out correctly for the person to Register their details, now you need a way for your website to remember that they are now a member right?
  • The table you should have created in your database is a users table, with fields for the Username, Password (which remember, should be set to MD5 in it's function setting), the gender of the Registering user and their email address. (4 fields altogether then.)
  • Once you have created variables, query checks for the items that need it and MD5'd the passwords, a query is needed to input the details.

e.g

mysql_query("INSERT INTO `users` VALUES('$name','$pass','$gender','$email')") or die("Errored due to:
".mysql_error());

This will Input the values into the table you created with the details of the registering person.

Notice that any form element in an HTML page will automatically be available to your PHP scripts.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What is a data capture form?

Before setting up a database the data must be collected. This can be done using a data capture form.


How can i Have php post to self with mysql?

Mysql is an Database where Data from HTML forms will be inserted to it by some scripts like ASP 3 (classic), ASP.NET, PHP, ColdFusion and... What you need is a form (By HTML), an Database and table in Mysql and PHP to insert data from your form to the table. mysql insert command is: INSERT INTO table_name_here (column1, column2, ..) VALUES (value_of_column_1, value_of_column_2, ...)


Does a relational database store data in the form of a list?

A relational database stores data in the form of TABLES.


What are the importance of table form query in database?

In database system the data is stored in the form of table. So to store the data in the database, table are very important in a database system.


Can you create a database with only a form?

Yes , you can create a database using a form . But you have to do two things First make a form in html or jsp whatever you like. Then Connect the form to database using java database connectivity.Yes, we can create database with a form. First create a form using html or jsp then we can connect it to database using JDBC.


Is there a difference between a database and a data capture form?

Yes, a very fundamental one. The form is the interface that allows you (or a user) to add data to the database. The database is the thing that stores the information and retrieves it when queried by the database operator.


How do you insert value to a dropdownlist from textbox input php?

Store the textbox input in a database using a html form prefarably. Using a loop get all the textbox input from database and use print/echo to show them in a dropdown.


What are database ables?

Database is the collection of data which are interrelated with each other. Data in database is stored in form of table these tables are known as database tables.


What is the code to insert table in signup form in HTML?

First you have to get the data from signup form. Then using <td> and <tr> you can populate the results.


How do I create a form which will then upload to a database that I can access in Microsoft Access?

Have your form's input insert into a database (SQL, Oracle, etc) then access that database through Access's ODBC connection.


What is full form of ADODC?

Activex data object Database connection Activex data object Database connection


What is a data form in Excel?

A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.A data form is a form that enables you to enter data into it which is then put into cells. The data must be in a table format, and is like a database. You type the data into the form, one record at a time and it is transferred onto the worksheet. It helps to automate the process of putting in data, similar to what you would see on a database application that uses forms.