473,378 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Date from form to mySQL

How do I take a field from a form and store it on in a mySQL table?

TIA, Lee
Aug 10 '05 #1
4 1762
*** Lee David wrote/escribió (Wed, 10 Aug 2005 16:18:49 -0500):
How do I take a field from a form and store it on in a mySQL table?


Do you want an explanation of *all* the process or you have a very specific
question? There're many things involved as to explain it all: HTML, forms,
database management and design, data validation in PHP, database access...

--
-- Álvaro G. Vicario - Burgos, Spain
-- http://bits.demogracia.com - Mi sitio sobre programación web
-- Don't e-mail me your questions, post them to the group
--
Aug 11 '05 #2
> How do I take a field from a form and store it on in a mySQL table?

Do you know how to do ANYTHING with mySQL in PHP?
Do you know how to send form fields to a PHP script?

Let us know what you can do in PHP.

I don't like offering complete code because I end up doing all the work, and
you learn nothing.

Aug 11 '05 #3
Lee David wrote:
How do I take a field from a form and store it on in a mySQL table?

TIA, Lee


Hi Lee,

As others have mentioned, this is too broad a question for a good
answer from the group.

Here's a rough outline of what you need to study to work out your own
answer:
HTML-- <form>, <input>, possibly other form fields
Javascript-- client-side validation techniques
PHP-- $_GET() and $_POST(), server-side validation, data
transformation
PHP-- the mysql_whatever() functions (or possibly the PEAR module)
MySQL-- database definitions, INSERT queries

I think that's a comprehensive, eagle's view of the terrain. I'm sure
if I missed something really big, someone will jump in and mention it.

If you use this outline, you will probably have questions that are more
specific which the group would be able to respond to.

Aug 11 '05 #4
In article <14*****************************@40tude.net>, Alvaro G Vicario wrote:
*** Lee David wrote/escribió (Wed, 10 Aug 2005 16:18:49 -0500):
How do I take a field from a form and store it on in a mySQL table?


Do you want an explanation of *all* the process or you have a very specific
question? There're many things involved as to explain it all: HTML, forms,
database management and design, data validation in PHP, database access...


the data from your form will arrive in (among other places) an array called
$_REQUEST you take it from there and create the mysql commands to store it
in your table.

--

Bye.
Jasen
Aug 17 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Jeroen | last post by:
Hi, I'm searching but not finding :( I need the code that creates automatic the days in a month So like for this month, it creates the days in this format 01-Oct, 02-Oct, .... This...
2
by: Paul Beckett | last post by:
I have successfully used strtotime to format the date on a webpage that is pulled form a MySQL database in the form yyyy-mm-dd. However, in another part of the webpage, I have to insert another...
5
by: Dominique Javet | last post by:
Hello, I'm new to php and mysql and I use Dreamweaver MX 2004, so sorry for this "newbie" question... I've found no answer in the forum ... I've a date problem with my formular. In my mysql DB...
8
by: nimish | last post by:
I have Month, Day and Year fields on my form. When I submit this form I want to create a valid date from all three fields before inserting into MYSQL table. I tried following:...
1
by: Jason | last post by:
I have a form which ads a technician service ticket into mysql. The fields are tech name time spent service client name etc... I assumed that mysql was storing the date of each record...
1
by: DD | last post by:
I have a mainform with a subform. The main form as a dropdown box "chooseDate", in the afterupdate event i requery the subform so all records with the same date are viewed. Now i only want to...
2
by: Kun | last post by:
I have an html form that takes dates and inserts them into a mysql file. Currently, users have to type in dates in the yyyy-mm-dd format. As of now, this process works with the sql. However, I...
3
by: dave | last post by:
I need to compute an expiration date based on the number of hours, days, or months purchased. The expiration date needs to be expressed in minutes something like '1260481600'. How can I get the...
6
by: ruraldev | last post by:
I have been trying my best to display a chosen date as dd-mm-yyyy but insert it into the mysql database as yyyy-mm-dd, I know it must be simple but no matter what I try I can't get it to work. At...
3
by: janetopps | last post by:
I have a news website, with asp pages, which was on Access, and i upgraded to MySQL, i used Bullzip to transfer the data. It had about 1000 pages, which im now able to pull up on the public side. Im...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.