PDO or MySQLi, and PHP

已完成 已发布的 7 年前 货到付款
已完成 货到付款

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

项目ID: #11775090

关于项目

21个方案 远程项目 活跃的7 年前

授予:

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 更多

$45 USD 在1天内
(50条评论)
5.1

有21名威客正在参与此工作的竞标,均价$61/小时

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 更多

$53 USD 在10天内
(763条评论)
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 更多

$50USD 在1天里
(117条评论)
7.6
aryan151

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

$25 USD 在10天内
(363条评论)
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 更多

$35 USD 在2天内
(93条评论)
6.6
rambanstola

A proposal has not yet been provided

$111 USD 在3天内
(65条评论)
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 在2天内
(45条评论)
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 更多

$88 USD 在3天内
(13条评论)
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 更多

$30 USD 在0天内
(12条评论)
4.4