vb.net add text to mysql database through php

Question

I am building an app where I need to allow a user to add a large text (a story) to his account in server.

This will be done like this:

application developed in vb.net for article formatting
pass the story to php page using request variables (because direct connection to MySql server can reveal my password in app exe)
php file will store data to database.

But right now I get: 414 error - url too big.

Any alternative to this ?

What's your problem with WCF?

Steve
– Steve

2012-06-11 07:02:43 +00:00
Commented Jun 11, 2012 at 7:02 — Steve
– Steve, Commented Jun 11, 2012 at 7:02
no idea about this. worth checking?

xhammer
– xhammer

2012-06-11 11:22:32 +00:00
Commented Jun 11, 2012 at 11:22 — xhammer
– xhammer, Commented Jun 11, 2012 at 11:22

Samy Vilar · Accepted Answer · 2012-06-11 05:18:11Z

1

try http post, modified your php.ini file to increase its max size, though if its just text I doubt you will be hitting its limit, unless the stories are really long.

answered Jun 11, 2012 at 5:18

Samy Vilar

11.2k2 gold badges42 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

xhammer Over a year ago

yup got that working : i was actually using request variables (get) on server and post in vb.net. LOL - Kinda new to PHP. Now i made a post variable form with post in vb.net too. So everything cleared now. Thanks

nik · Accepted Answer · 2012-06-11 06:30:06Z

0

If you have access to SQL server, create a stored procedure and a user limited to execute that stored procedure only. Then use that user account for uploading data.

Even better would be to introduce user accounts for each user and approve credentials in that stored procedure which would avoid anonymous spamming of your database.

answered Jun 11, 2012 at 6:30

nik

1,4791 gold badge12 silver badges17 bronze badges

Collectives™ on Stack Overflow

vb.net add text to mysql database through php

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related