CODEWITHSUNDEEP
phpmysqlvb.netvisual-studio-2010httpwebrequest
xhammer
xhammer

Reputation: 145

vb.net add text to mysql database through php

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:

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

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

Any alternative to this ?

Upvotes: 0

Views: 276

Answers (2)

nik
nik

Reputation: 1479

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.

Upvotes: 0

Samy Vilar
Samy Vilar

Reputation: 11130

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.

Upvotes: 1

Related Questions