Completed

Secure mysql insert and update script

I need a secure insert and update script for a jobs database.

Below is how the script is now and I a secure script to insert data into the database especial the JobDesc as this is were people would place all kinds of characters in a jobs description ad and I do not want them to get error or.. "can not insert" errors.

Also I would to have this within an hour or so.

Please check my rating.. I pay immediately after testing the script.

$JobDesc = mysqli_real_escape_string( $_POST['JobDesc']);

$conn = mysql_connect("localhost", "username", "password");

mysql_select_db("mydatabase",$conn);

$sql = "INSERT INTO jobs (JobCity,JobState,PositionType,PositionTitle,Website,EmailContact,ClosingDate,DatePosted,Featured,Salary,SalaryType,JobType,ClosingType,member_id,JobDesc) VALUES ('$_POST[JobCity]', '$_POST[JobState]', '$_POST[PositionType]', '$_POST[PositionTitle]', '$_POST[Website]', '$_POST[EmailContact]', '$_POST[ClosingDate]', '$_POST[DatePosted]', '$_POST[Featured]', '$_POST[Salary]', '$_POST[SalaryType]', '$_POST[JobType]', '$_POST[ClosingType]', '$_POST[member_id]', '$_POST[JobDesc]')";

$sql_result = mysql_query($sql,$conn) or die ('Could PSEA not insert data');

echo('Job INSERTED successfully.');

Skills: MySQL, PHP

See more: php jobs salary, i want to place an job ad, database testing jobs, kinds of jobs, ad script update, mysql characters, mysql inserted, mysql update values, update insert sql, update values mysql, insert sql, mysql_connect, mysql insert update , php script echo, php rating script mysql, echo script php, secure script, echo script, php echo script, want database insert, mysql job description, website testing job description, insert data database mysql, php mysql salary, check username password mysql database php

About the Employer:
( 43 reviews ) Port Charlotte, United States

Project ID: #5282397

Awarded to:

tikumishra

I can do this right away and can give you the fixed script in 30 minutes for your tsting. Let me know, if you are interested. Ready to start now. Thanks

$25 USD in 1 day
(41 Reviews)
5.3

14 freelancers are bidding on average $25 for this job

majma01

I am expert php mysql developer, ready to do this job , this is very much easy job for me , i can do this in just ten mint. ready to start right now. Regard Ajmal

$24 USD in 0 days
(40 Reviews)
5.5
allroundexperts

A proposal has not yet been provided

$20 USD in 1 day
(100 Reviews)
5.5
AltiuseCreaton

Is it possible for you to make small chat discussion with about your project? Let me know please. Regards Sita

$35 USD in 3 days
(9 Reviews)
4.9
tolyadouble

Thank you for reviewing my bid. I have rich experience on this fields. You may read my feedback page and see the portfolio in my profile. Best regards. Ready to start work right now. Thanks.

$19 USD in 1 day
(32 Reviews)
4.8
rana37

A proposal has not yet been provided

$25 USD in 0 days
(21 Reviews)
4.6
tdteam

I'm php expert, I have team working on html, css, jquery, php, joomla, wordpress,..Please let we do it for you, thank you

$25 USD in 1 day
(29 Reviews)
4.6
Azaddien

Hello Sir, I am ready to make this project done in hours or less please check my profile to see that I have 5/5 rating and positive reviews thanks

$30 USD in 0 days
(20 Reviews)
4.4
webtechdev

Hi Ready to do the work Looking forward for long term working relationship. :) Thanks Hamza Khan

$15 USD in 1 day
(11 Reviews)
3.2
masswebtechnolog

Hi, Hello, Hope you are well and doing well!!! i am php expert having 5 year of [login to view URL] are eager to work with you. We are ready to start the project right away.

$18 USD in 1 day
(4 Reviews)
2.7
grimmdude

A proposal has not yet been provided

$45 USD in 1 day
(1 Review)
1.4
krutikjayswal

I can do this. I can do this. I can do this. I can do this. I can do this. I can do this. I can do this. I can do this. I can do this.

$25 USD in 1 day
(1 Review)
0.4
TomMcPadden

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0
nimeshanadkat

A proposal has not yet been provided

$25 USD in 1 day
(0 Reviews)
0.0