Secure mysql insert and update script

Completado Publicado Jan 3, 2014 Pagado a la entrega
Completado Pagado a la entrega

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.');

MySQL PHP

Nº del proyecto: #5282397

Sobre el proyecto

13 propuestas Proyecto remoto Activo Jan 3, 2014

Adjudicado a:

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 en 1 día
(82 comentarios)
6.0

13 freelancers están ofertando un promedio de $25 por este trabajo

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 en 0 días
(200 comentarios)
7.1
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 en 1 día
(111 comentarios)
6.4
allroundexperts

A proposal has not yet been provided

$20 USD en 1 día
(186 comentarios)
6.2
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 en 1 día
(110 comentarios)
6.1
webtechdev

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

$15 USD en 1 día
(87 comentarios)
5.5
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 en 0 días
(40 comentarios)
5.1
rana37

A proposal has not yet been provided

$25 USD en 0 días
(24 comentarios)
4.8
grimmdude

A proposal has not yet been provided

$45 USD en 1 día
(3 comentarios)
2.0
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 en 1 día
(2 comentarios)
1.4
TomMcPadden

A proposal has not yet been provided

$25 USD en 1 día
(1 comentario)
0.0
nimeshanadkat

A proposal has not yet been provided

$25 USD en 1 día
(0 comentarios)
0.0