473,322 Members | 1,714 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,322 software developers and data experts.

collecting data from forms - when to save

--------------------------------------------------------------------------------

when do i write my data to the data base?

i am building a browser based image map generator using php. each time an image is clicked the coords and a text box contents are to be saved somehow. i am expecting upto 50 lines of data for each image (x coord, y coord and text) :

sample data:
image name x y description
image7.jpg 123 123 wheel
image7.jpg 485 688 tyre
image7.jpg 456 595 bolt

later on i will display the image and create the hotspots image map with the text data (description) as html alt tags.

i have a data table in MYSQL with 4 columns:
1 image name
2 x_coord
3 y_coord
4 text for alt tags

do i collect 50 sets of data in a temp file or array or something and then write it to the database in one go or write each line of data as it is created ? my worry is that if i write to the database it may be a pain to edit any mistakes. so maybe some kind of preview table might be a good idea....
Sep 24 '06 #1
2 1524
ronverdonk
4,258 Expert 4TB
Why are you posting the same thread in 2 different forums???? Don't you think other people also have a right for attention?

Ronald :cool:
Sep 24 '06 #2
Why are you posting the same thread in 2 different forums???? Don't you think other people also have a right for attention?

Ronald :cool:
hi, did not know if this was php or a sql question ! thanks for your attentions if it was of no constructive value.

regards

john
Sep 24 '06 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: serge calderara | last post by:
dear all, I am building an application which is collecting data from a database and display them in a windows form. My idea is to collect those data in a form that, they can be read by my...
0
by: notalent | last post by:
I'm having a problem with a very basic program. I'm creating a app in Visual Studio (2003) C# to zip up a collection of specified files & directories and save them to a certain location. I have...
32
by: Neil Ginsberg | last post by:
We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC linked tables. I recently created a new set of tables for the app, and users are complaining that unsaved data is being...
7
by: Dica | last post by:
i've used the sample code from msdn to create an encyption/decryption assembly as found here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT10.asp i'm...
8
by: Lloyd Sheen | last post by:
I have a problem with persisting the state of a control. It has several properties that can be determined but there is no event to indicate when the property changes. A postback occurs when one...
5
by: Rod | last post by:
I've written 2 ASP.NET applications (I've worked on one with a team and another by myself). In my ASP.NET pages, when saving data to a backend database I've done it by using the click event of a...
0
by: Michael Mitchell via DotNetMonster.com | last post by:
* I need to collect the input data on example1.aspx by hitting the review button. * Out put the data in the corresponding Labels on Example2.aspx. * Save Example2.aspx to a File of the users choice...
5
by: antonyliu2002 | last post by:
I have 4 forms each on a separate page respectively form1.aspx, form2.aspx, form3.aspx, form4.aspx. On top of each of the four pages there are 4 links which link to the aforementioned 4 pages...
17
by: romixnews | last post by:
Hi, I'm facing the problem of analyzing a memory allocation dynamic and object creation dynamics of a very big C++ application with a goal of optimizing its performance and eventually also...
1
by: tommydog | last post by:
when do i write my data to the data base? i am building an image map generator. each time an image is clicked the coords and a text box contents are to be saved somehow. i am expecting upto 50...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...

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.