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");
$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.');
14 freelancers are bidding on average $25 for this job
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
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.
Hi, Hello, Hope you are well and doing well!!! i am php expert having 5 year of [url removed, login to view] are eager to work with you. We are ready to start the project right away.