I have the requirements of getting a simple form to output to a db
file. Currently I am using a form called ennyform and it outputs to a
flat file. The person who want this wants it to be searchable and we
expect to get anywhere from 50 - 300 forms submitted per day. I was
reading that using php to MySQL was the correct way to get output into
a MySQL database. I know this is not the only way but I am on a Linux
platform and it is free. Is this overkill to set this up for a simple
form? Should I continue using the flat file and import it into
something. I am basically fishing for the most efficient way. I am
only assuming PHP to MySQL is the best way. I would just like to know
before I dive into the unknown. My next step would be to figure out
how to set up a page to use PHP to output form fields. And of course I
will have to create the DB.
I hate to say this but yes I am clueless but I was hoping that this
would be a short quik answer from somebody who done these things
already. I just want to pointed in the right direction before I spend
a lot of time with the wrong stuff. Currently I just read the text
file, actually I don't even do that I just read the emails as they are
sent. I rarely go in and look at the text file the form outputs to. I
am going to have to though, very soon.
Thanks A lot 1 2630
The Voivod wrote: I have the requirements of getting a simple form to output to a db file. Currently I am using a form called ennyform and it outputs to a flat file.
What server-side technology/language do you use to output the form
values to the flat file? Couldn't you use the same technology/language
to output them to MySQL?
The person who want this wants it to be searchable and we expect to get anywhere from 50 - 300 forms submitted per day.
Just FYI: this won't cause any problem, whatever technology you use. 300
hits per day is a really small charge.
I was reading that using php to MySQL was the correct way to get output into a MySQL database. I know this is not the only way but I am on a Linux platform and it is free. Is this overkill to set this up for a simple form?
php is very quick and easy to install, as well as MySQL. You shouldn't
have too many problems if you read the manuals at www.php.net.
Should I continue using the flat file and import it into something.
No. This would make things slower, and more difficult to implement.
I am basically fishing for the most efficient way.
For such a small charge, use what you know best, i.e. the easiest
solution for you.
HTH.
JB.
I am only assuming PHP to MySQL is the best way. I would just like to know before I dive into the unknown. My next step would be to figure out how to set up a page to use PHP to output form fields. And of course I will have to create the DB.
I hate to say this but yes I am clueless but I was hoping that this would be a short quik answer from somebody who done these things already. I just want to pointed in the right direction before I spend a lot of time with the wrong stuff. Currently I just read the text file, actually I don't even do that I just read the emails as they are sent. I rarely go in and look at the text file the form outputs to. I am going to have to though, very soon.
Thanks A lot This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Martin Foster |
last post by:
Hi.
I want to do something really simple. I want to be able to write
a custom SQL query in a textbox on a webpage, submit it and then output to
the webpage in the format of MySQL output i.e. like this
+--------+--------+
| str_id | fd |
+--------+--------+
| 1062 | 9.996 |
|
by: Jan Josefowicz |
last post by:
Hi all,
I get following output from "mysqlbinlog mylog-bin-file.001":
# at 4
#030818 13:38:00 server id 1 Start: binlog v 4, server v created
700101 1:00:00
The file mylog-bin-file.001 contains many queries but they don't appear
in the output from mysqlbinlog.
|
by: Todd Cary |
last post by:
My client is using a shared server running MySQL 2.4, however the in
house server is 4.1.12 with mysqldump 10.9. Is there a way to have the
10.9 version output a format that is fully compatible with 2.4?
Some of the CREATE TABLE statements in 10.9 are not accepted by 2.4.
Currently, I am not using any of the switches in creating the output
file other than the -u, -h and -p.
Todd
|
by: Bob Bedford |
last post by:
Hello,
I've a file wich must answer a request. For this my file must generate an
XML output.
That's work fine but sometimes I get a wrong mysql query. In this case, I've
to manage the output message. Problem: the mysql error message is shown, so
the answer will have the mysql error then the XML output, and this don't
works for the "reading" script.
|
by: evan.lavidor |
last post by:
Hi all,
Forgive me if this topic has been discussed before. I've been doing
some searching and have yet to come across the answer I'm looking for.
I'm new to PHP, and I'm trying to call a MySQL stored procedure (using
mysqli) that has both input and output parameters. I have no problems
passing in the relevant params, but calling the output params is
confusing me. Most of the examples I see online deal with returning
| |
by: IamtheEvster |
last post by:
Hi All,
I am currently using PHP 5 and MySQL 5, both on Fedora Core 5. I am
unable to call a MySQL stored procedure that returns output parameters
using mysql, mysqli, or PDO. I'm having a hell of a time with it...
The following comes from phpinfo():
PHP Version: 5.1.2
mysql Client API version: 5.0.18
mysqli Client API version: 5.0.18
|
by: PW |
last post by:
I am trying to create a crosstab report in ASP. I'm using ASP/VBScript and
Access database. I used Access to create the SQL query, then copied the SQL
and embedded it in my ASP like this ...
mySQL = ""
mySQL = mySQL & "TRANSFORM Sum(Transactions.Hours) AS SumOfHours "
mySQL = mySQL & "SELECT Transactions.Activity" & myActSecond & " as
myActivity, Sum(Transactions.Hours) AS myHours "
mySQL = mySQL & "FROM Transactions "
mySQL = mySQL...
|
by: sparkw |
last post by:
I am using WinXP, GNU Emacs 23, MySQL 5.
When I start a mysql process with `sql-mysql' in emacs, no output is
displayed in the buffer until I quit or kill the process.
After I add the following line into the initialization file of emacs,
(setq sql-mysql-options '("-C" "-t" "-f" "-n"))
the output comes out, but the status line still doesn't show up. (e.g.
|
by: xtremebass |
last post by:
Hi Bytes, in Linux , is it possible to redirect Mysql table output to a file in Linux.
i tried it, shows error , but output has displayed in linux prompt when no redirection of file has given(say select * from tablename) but when i am trying redirect output to file in Linux it shows error? can you tell me suggestion for this issue.
code i used :
<code>
#!bin/sh
password=xyzbac
mysql -u root -p$password -h 192.168.1.8 << y
use sys;
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |