Find Jobs
Hire Freelancers

PDO or MySQLi, and PHP

$15-50 USD

已完成
已发布超过 7 年前

$15-50 USD

货到付款
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!
项目 ID: 11775090

关于此项目

20提案
远程项目
活跃8 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 want save HTML/is on your database is fine, but there's no problem if you want to do it. What you need to watch out is when you display that data in your HTML page. The context matter.
$45 USD 在1天之内
5.0 (50条评论)
5.1
5.1
20威客以平均价$62 USD来参与此工作竞价
用户头像
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 Web development. I never disappoint my clients and I’m able to lead your project to success and troubleshoot problems. I am LAMP & MEAN stack expert and have much knowledge in codeigniter Laravel cakePHP, symfony and CMS(joomla, wordpress). I am sure these will reflect in my past results. I’m very excited to assist you in making your blog successful please feel free to contact me directly to discuss this position further.
$53 USD 在10天之内
5.0 (763条评论)
9.1
9.1
用户头像
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 remove any JavaScript or HTML code before inserting to database. Please contact me for discussing more details. Regards, Amr
$50 USD 在1天之内
5.0 (119条评论)
7.7
7.7
用户头像
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 have 4+ years of experience in this field. I'm very energized to provide my solutions for your job. Please you can get in touch with me immediately to talk about this place further. I hope you'd give me this opportunity. Please once discussed in message board and I assure you the great deal. Have a Blessed Day! Regards, Bhavesh Nariya
$35 USD 在2天之内
5.0 (135条评论)
7.8
7.8
用户头像
Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......Lets start......
$25 USD 在10天之内
5.0 (424条评论)
7.3
7.3
用户头像
A proposal has not yet been provided
$111 USD 在3天之内
5.0 (65条评论)
5.7
5.7
用户头像
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天之内
5.0 (45条评论)
5.6
5.6
用户头像
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 to better readability. In either case, especially with user submitted data, I would recommend whitelisting allowed values for those that are fixed options and sanitizing any other values prior to any query to the DB. If you would like to get back to me with some further information, we can confirm if the project is a match for us and work out a relevant timeframe as well. Thank you
$88 USD 在3天之内
4.8 (13条评论)
5.6
5.6

关于客户

UNITED STATES的国旗
San Francisco, United States
5.0
263
付款方式已验证
会员自7月 22, 2002起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。