Find Jobs
Hire Freelancers

PHP, MySQL PDO, and AJAX Script Writer

$30-250 USD

Completed
Posted over 6 years ago

$30-250 USD

Paid on delivery
Hello! I seek to contract a freelancer that knows how to work with PHP, MySQL PDO, and AJAX. The freelancer will be tasked with writing different scripts to query, manipulate, and load data in a website. The freelancer should be able to write scripts such as: 1. Save all data in columns "name, score, address" to table WEEKLY_SCORE once every week. 2. Count the number of users with a score higher than 30. 3. Select all users registered in the last hour and return the result via AJAX. I will pay around $15 per script depending on the complexity. $200 in total guaranteed. Bids above $200 will not be accepted. The freelancer should understand the following code. Please do not apply if the below code does not make sense! Thank you! <?php class account extends db_connect { private $id = 0; public function __construct($dbo = NULL, $accountId = 0) { parent::__construct($dbo); $this->setId($accountId); } public function signin($email, $password) { $access_data = array('error' => true); $email = helper::clearText($email); $password = helper::clearText($password); $stmt = $this->db->prepare("SELECT salt FROM users WHERE email = (:email) LIMIT 1"); $stmt->bindParam(":email", $email, PDO::PARAM_STR); $stmt->execute(); if ($stmt->rowCount() > 0) { $row = $stmt->fetch(); $passw_hash = md5(md5($password).$row['salt']); $stmt2 = $this->db->prepare("SELECT id, state FROM users WHERE email = (:email) AND passw = (:password) LIMIT 1"); $stmt2->bindParam(":email", $email, PDO::PARAM_STR); $stmt2->bindParam(":password", $passw_hash, PDO::PARAM_STR); $stmt2->execute(); if ($stmt2->rowCount() > 0) { $row2 = $stmt2->fetch(); $access_data = array("error" => false, "error_code" => ERROR_SUCCESS, "accountId" => $row2['id']); } } return $access_data; ?>
Project ID: 15446066

About the project

22 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I am 12+ years experienced full-time PHP/Java freelancer previously worked for companies like HP, Manhattan Associates, Home Depot etc. I can able to understand the code posted by you. Few notes about the same, 1) This account class is a data access object based on its constructor and its super class. 2) By default, account ID is set to 0 by the constructor and will be changed by calling signin function if email, password validation logic succeeds. 3) The signin functions take email, password arguments. First, it will fetch MD5 key from users table by email then we will use this key to parse the password. With this email & password we will again query the users tables and get the account id. If a record exists we will set the global accountId with retrieved value. Please find my complete skillset, PHP, Laravel Framework, HTML5, CSS3, JavaScript, AngularJS, JQuery, Java, JEE, Spring Framework, Hibernate, JMS, JUnit, Mockito, Oracle, MySQL, SOAP/Restful Web Services, Maven, Docker I have designed and developed internal enterprise level PHP/MYSQL applications for companies like Concentrix Corporation, Inspiredge IT Solutions and Unique Performance. I have also developed/enhanced many PHP based websites (Few samples are [login to view URL], [login to view URL], [login to view URL]) Thank you in advance for your time and consideration. Feel free to contact me during any stage of your project. I am here to assist!
$200 USD in 3 days
5.0 (4 reviews)
3.2
3.2
22 freelancers are bidding on average $169 USD for this job
User Avatar
HI There, I can assist you with "PHP, MySQL PDO, and AJAX Script Writer", I have experience working with "similar Development". Let's have a quick chat to discuss it further. Relevant Skills and Experience I have been in this "PHP, MySQL PDO, and AJAX Script Development" field for a long time now, you can further check my sample work at: https://www.freelancer.com/u/extreamcode.html Proposed Milestones $200 USD - milestone
$200 USD in 11 days
5.0 (78 reviews)
7.5
7.5
User Avatar
Hi! I can write the script with efficient results and quickly. I'm expert Web developer. Contact me for quick and quality work Relevant Skills and Experience 4 years Proposed Milestones $155 USD - Script
$155 USD in 1 day
5.0 (41 reviews)
6.1
6.1
User Avatar
I have more than 4 years experience as core web developer, I will develop all required scripts according to your requirements, we can talk more over chat Relevant Skills and Experience PHP,MYSQL Proposed Milestones $177 USD - milestone payment Stay tuned, I'm still working on this proposal.
$177 USD in 3 days
5.0 (138 reviews)
6.1
6.1
User Avatar
Hello, I have understood the code you have written. It is used prepared statement query to fetch the data from database. I also write SQL query in prepared statement to increase security. Relevant Skills and Experience I am an expert in PHP, MYSQL, AJAX and having 8 years of experience. I can handle all type of requirement simple and complex. I am agreed on your price. Please send me message to discuss more. Proposed Milestones $155 USD - Full Project
$155 USD in 3 days
4.9 (47 reviews)
5.5
5.5
User Avatar
please ignore the bid amount we will discuss the price later in the chat after we have discussed the project thoroughly Relevant Skills and Experience: . Proposed Milestones: 190 - . Hi rayliverified! please inbox me to discuss the project
$190 USD in 2 days
5.0 (10 reviews)
5.0
5.0
User Avatar
I could understand the code you gave. I work with PDO connections in PHP and also AJAX. Relevant Skills and Experience PHP, MySQL, HTML, CSS, jQuery, Angular Proposed Milestones $200 USD - Project
$200 USD in 3 days
5.0 (6 reviews)
4.9
4.9
User Avatar
Hello, I saw code which is provided by u is in oops and pdo. I am  very interested in the project and we would like to apply for it .I am a  web ,android,ios developer with 8 years experience in PHP, MySQL, CSS3, HTML5 ,ios,android studio,deep knowledge WordPress, WP plugins, development issues and customization. In addition, I have a solid expertise in the 3rd party API as Facebook, Twitter, Google API, shopping engines, etc. I am able to take responsibility for your project immediately and have the enthusiasm and determination make sure you make a success of it
$200 USD in 10 days
5.0 (17 reviews)
4.6
4.6
User Avatar
Hello Sir, I will do this job for you. Don't worry about it leave it for me, Quality of work is my first Priority and 100% Client Satisfaction is my Guaranty. Thank You Relevant Skills and Experience I have expertise in PHP, PDO and AJAX Proposed Milestones $160 USD - I will do your scripts according to your requirements. Thank you
$111 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$198 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will directly give description so you can judge me by my understanding. You have created one class where you have set account id variable as private. Relevant Skills and Experience And as user signing constructor will create default account id and first check email exists if yes then check email and password are matching with record if yes then return account id otherwise error. Proposed Milestones $50 USD - PHP, MySQL PDO, and AJAX Milestone 1 $50 USD - PHP, MySQL PDO, and AJAX Milestone 2 $61 USD - PHP, MySQL PDO, and AJAX Milestone 3 I have done many projects in PHP Data Object(PDO) and I have 2+ years experience.Thanks.
$161 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Lawerence, United States
4.0
3
Payment method verified
Member since Oct 8, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.