Linode Forum
Linode Community Forums
 FAQFAQ    SearchSearch    MembersMembers      Register Register 
 LoginLogin [ Anonymous ] 
Post new topic  Reply to topic
Author Message
PostPosted: Sun Aug 17, 2014 2:14 pm 
Offline
Senior Newbie

Joined: Thu Aug 07, 2014 11:04 am
Posts: 8
So I has this form with a submit button, just regular stuff. But I have no clue how to directly send those forms from the web server directly to MySQL database.

Anyone got some tips?


Top
   
PostPosted: Mon Aug 18, 2014 7:31 am 
Offline
Senior Member

Joined: Mon Jan 02, 2012 12:45 pm
Posts: 365
crewsta,
We'll need to know a little more about what you're doing before we can venture a guess.
- What language are you using on the server end?
- Are you using an open source package such as Wordpress, Drupal, Joomla, etc?

If you have software to read the DB entries that you want to write, does it have support for getting the entries into the DB?


MSJ


Top
   
PostPosted: Mon Aug 18, 2014 7:44 am 
Offline

Joined: Wed Aug 13, 2014 9:36 am
Posts: 1
Location: Michigan
You cannot use an HTML form to submit information to a (MySQL) database without processing it through a server-sided scripting language such as PHP first.

Here is a very basic tutorial on using PHP to insert POST data from an HTML form into a MySQL database: http://www.w3schools.com/php/php_mysql_insert.asp

After you get the basics down you'll want do some research on how to prevent SQL injection attacks through forms like this.


Top
   
PostPosted: Mon Aug 18, 2014 2:22 pm 
Offline
Senior Newbie

Joined: Thu Aug 07, 2014 11:04 am
Posts: 8
To: Main Street James,
I'm using the Adobe Dreamweaver CS6 to write my website, I got my linode all set up
To Zach,
thanks for the link i will check it out


Top
   
PostPosted: Tue Aug 19, 2014 4:31 pm 
Offline
Senior Member

Joined: Mon Jan 02, 2012 12:45 pm
Posts: 365
crewsta,
DW is the tool you're using for your HTML. Do you have any server-side code for your website (besides your HTML)?

As Zach mentioned you need to post your data back to your server. It's usually like this:
Form -> POST -> Server Code -> Database

Your server code will depend on what you've installed on your VPS (such as PHP, Perl, Python, Ruby on Rails, etc) as well as any software packages or frameworks your site uses (if any).

BTW, getting the data into your DB is half the battle. How are you going to get it out?


Top
   
PostPosted: Wed Aug 20, 2014 12:35 pm 
Offline
Senior Newbie

Joined: Thu Aug 07, 2014 11:04 am
Posts: 8
Main Street James wrote:
crewsta,
DW is the tool you're using for your HTML. Do you have any server-side code for your website (besides your HTML)?

As Zach mentioned you need to post your data back to your server. It's usually like this:
Form -> POST -> Server Code -> Database

Your server code will depend on what you've installed on your VPS (such as PHP, Perl, Python, Ruby on Rails, etc) as well as any software packages or frameworks your site uses (if any).

BTW, getting the data into your DB is half the battle. How are you going to get it out?

I'm not getting the datas out, I have my algorithm to deal with the data, so it's not pure I/O. Just need to deal with the input part


Top
   
PostPosted: Wed Aug 20, 2014 12:40 pm 
Offline
Senior Member

Joined: Mon Jan 02, 2012 12:45 pm
Posts: 365
Quote:
I'm not getting the datas out, I have my algorithm to deal with the data, so it's not pure I/O. Just need to deal with the input part

OK, what are you using to get the data out because that will point us in the right direction regarding what code/language/etc you should use to get it in.


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic


Who is online

Users browsing this forum: mwchase and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
RSS

Powered by phpBB® Forum Software © phpBB Group