PDO or MySQLi, and PHP

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

I need some help with MySQLi or PDO (database queries from PHP).

Although familiar with basic MySQL, I need an expert to help make sure that this particular form/database is very secure (secure from MySQL injection, XSS, etc). I assume this will mean using PDO or MySQLi.

The database will be queried by website visitors using a PHP form.

So I'll need the PHP code for both Inserting/submitting to, and Selecting/displaying data from, the database.

If there are any security concerns with the database structure, then I'll also need the SQL query to create the database/table.

The database fields will be as follows:

1) unique id - auto incrementing)

2) varchar(150) - email address only

3) varchar(70) - letters only

4) a 4 digit integer

5) timestamp

6) text

*Neither the text nor varchar fields should allow any html or javascript.

**And again, the main thing is that I want this database/php to be secure from MySQL injection, XSS, etc.

With your bid, please let me know if you'll be using MySQLi or PDO.

Also please let me know your expected turnaround time.

Thanks for reading!

MySQL PHP

Project ID: #11775090

About the project

21 proposals Remote project Active 7 years ago

Awarded to:

Leggendario

Hello. If you want protect yourself from SQL injection, you need to use prepared statement. You can do that with both mysqli and pdo, and I can use all of them. About xss attack, it's all about context. If you don't wa More

$45 USD in 1 day
(50 Reviews)
5.1

21 freelancers are bidding on average $61 for this job

Yknox

Dear Employer,I am Software engineer in China. I’m interested in the project you recently posted. I'm a certificated freelancer with over 500 good reviews from clients. I have experienced knowledge in every part of More

$53 USD in 10 days
(763 Reviews)
9.2
amrshawky35

Hello there, I will help you making the PHP code that will deal also with database using prepared SQL statements in PDO that is secured from SQL injection. Also the PHP code would contain some functions that will r More

$50 USD in 1 day
(117 Reviews)
7.6
aryan151

Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......

$25 USD in 10 days
(363 Reviews)
7.1
bhaveshjnariya

Dear Hiring Manager, Greetings of the Day! I have excellent experience in Website Designing/Development. I believe my abilities would be perfect for your venture. I am professional website developer/designer. I More

$35 USD in 2 days
(93 Reviews)
6.6
rambanstola

A proposal has not yet been provided

$111 USD in 3 days
(65 Reviews)
5.8
suraj2

Hi, I have got 10 years of php/mysql experience. 1) I will be using mysqli 2) Expected time : 2days Thanks, Suraj

$50 USD in 2 days
(45 Reviews)
5.6
ausprofreelancer

Hello, I have extensive experience with PHP and MySQL and mitigating potential SQL injection attack vectors. Depending on how your PHP scripts and queries are set up now, I would most likely prefer to use MySQLi due t More

$88 USD in 3 days
(13 Reviews)
5.5
codingduo

Hi, I can finish this project for a minimal bid within next few hours, starting the project right away. Please feel free to have a discussion before having a decision. Thank You. NB: I'll be using MySQLi warm More

$30 USD in 0 days
(12 Reviews)
4.4