Help with a simple SQL queries.

$10-30 AUD

Completed

Posted

over 1 year ago

$10-30 AUD

Paid on delivery

I need to add the new Users ID that was added to the database in a email. The code is already done, I just need someone to make the SQL that gets the last MAX userID form table USERS and adds + 1, and puts that in the line below $email_message .= "firstname: ".clean_string($_POST['firstname'])."\n"; $email_message .= "lastname: ".clean_string($_POST['lastname'])."\n"; $email_message .= "username: ".clean_string($_POST['username'])."\n"; $email_message .= "email: ".clean_string($_POST['email'])."\n"; $email_message .= "street1: ".clean_string($_POST['street1'])."\n"; $email_message .= "street2: ".clean_string($_POST['street2'])."\n"; $email_message .= "suburb: ".clean_string($_POST['suburb'])."\n"; $email_message .= "state: ".clean_string($_POST['state'])."\n"; $email_message .= "postcode: ".clean_string($_POST['postcode'])."\n"; $email_message .= "country: ".clean_string($_POST['country'])."\n"; +++=========================== NEED TO ADD THE BELOW ==== $email_message .= "userid: ".clean_string($_POST['userid'])."\n"; [ADD the new "userid" to email here] Eg Get MAX userID from table "userid" and add +1] +++=========================== Mention Clear in comments of your bid will be ignored, should be a quick job, I will provide php page

Project ID: 34347731

About the project

48 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

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:

@FarazAbbas

$0 AUD in 1 day

5.0

(494 reviews)

7.9

48 freelancers are bidding on average $24 AUD for this job

@imTuyen

Hi Chris. I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, Yii, NodeJS, Angular, Vue.js, HTML5, CSS3 and jQuery. I can do this project. Please hire me. I think, You will contentment with my skills. I can fix your site issue successfully I am looking forward to having further discussions with you and can start working immediately. Thank you

$30 AUD in 1 day

5.0

(192 reviews)

7.1

@wmkosc

I have been website developer for over 7 years and have much experience in this field. I read your requirement and really interested, I can start working immediately, I am sure I can add that userid fast and make it work perfectly for you, please contact me to start it soon, thank you

$15 AUD in 1 day

5.0

(153 reviews)

6.9

@creativeitechpvt

Hello, I have reviewed your requirements, and I believe that with my experience and skills, I can deliver to you as per your expectation. i have been working with USA base company, onwards i'm available full time for PHP full stack developer cum team lead due to recession indication in USA, my previous engagement ended recently. i m available for long term collaboration i have strong grip in PHP, Codeigniter, Laravel, WordPress,bootstrap, html5, css3, js, ajax, jquery and more than 11+ year of experiance in web site development and server support. I am also well versed in Front-end development. I will give 100% on your project. To discuss this in detail send me a message. Can we discuss this in detail? I am ready to start your project ASAP. We look forward to your positive reply. If you hire me, I can start working immediately. Thanks Naimish Makwana

$15 AUD in 1 day

5.0

(157 reviews)

7.0

@vinhtq0703

Hi I have 8+ years of experience as a programmer with PHP, Laravel, Wordpress, ReactJs, VueJS, ... I can build a complete website system with many functions perfectly. I have read your project description clearly and I am confident that I can give you the best results at an affordable cost. Hope you are interested in my offer of cooperation and we can discuss to understand the project. Thank you for giving me the opportunity to work with you. Have a nice day!

$30 AUD in 1 day

5.0

(56 reviews)

6.1

@navjootkaur

Hi! I read your project description and will be able to manage your task as per your essentials . I am highly experienced in software development profile with highly upgrade technical skills. I would like to work in a long term relation thankyou!

$12 AUD in 40 days

4.7

(163 reviews)

6.5

@denysdenysivanch

❤️ Hello. I have rich experience in SQL. Also I am very familiar with database manage. I can add the new Users ID that was added to the database in a email. I'm sure I can do this asap. Please contact me to discuss more, looking forward to work with you. Thanks!

$30 AUD in 1 day

5.0

(23 reviews)

5.5

@psharma3368

Hello sir I can add sql query in php page to get max user id from database table and add +1 then set in email messages. I need to discuss on max id because in your case there id possibility that 2 users can get same user id. Please text me so we can discuss and start work. Thanks

$30 AUD in 1 day

5.0

(51 reviews)

5.6

@nikil02an

Hi, I can write query for the same and get the recent email address, update the counter field value as per your requirement. Looking forward to hearing from you soon. Thank you.

$25 AUD in 1 day

5.0

(15 reviews)

5.5

@gustavofulanetto

Hi, From what I understand, you want the last register from the table "users" to be picked, want 1 to be summed to its value and then want the value of the sum to be passed to a variable and the variable value should be added to the "$email_message" variable, right? I can make the code you're looking for. I'd like you to send me the PHP script on the chat, for me to check it out. Thanks!

$20 AUD in 1 day

5.0

(98 reviews)

5.3

@NagarajTN

Hello Client i can do this work,i am ready to start work now,i can provide best quality work,please chat now

$15 AUD in 1 day

5.0

(22 reviews)

5.2

@eduardoherreral4

Hello! ⭐⭐⭐ I have lots of experience in SQL, database. ⭐⭐⭐ I can help you with your project at a high level! My skills and experience is a great match for your needs. I can start now. Hope to work with you. Thanks.

$20 AUD in 2 days

4.9

(30 reviews)

5.4

@hoaxuyentri

Hello! I hope you are doing well. I am an experienced database administrator using TSQL in long time (sql server, mysql, oracle, postgres, mariadb). You can refer my profile in link https://www.freelancer.com/u/hoaxuyentri I already read your project description and I am very interested in your project. I can help you to write sql query as your requirement. I can start right now and will provide you the top quality work for sure. Please contact me to discuss more about the detail. Regards,

$20 AUD in 1 day

5.0

(31 reviews)

4.7

@GanpatDesai

Hi there, I have read your project description and seems like a perfect job for me. I have been in this industry for 10 years and such jobs are my daily practice. So, I think that I have all the skills you’re looking for. For more on my skills, please check out my profile: https://www.freelancer.com/u/GanpatDesai Let me know if my profile looks interesting, and we can set up a time to discuss it. Best Regards, Ganpat Desai P.S.: The proposed cost is an estimate. I could give you an exact figure, and timeframe if we discuss.

$20 AUD in 7 days

5.0

(30 reviews)

4.3

@lmhunhthanh91

I have more than 8 years of experience working with PHP, Prestashop, CodeIgniter, Laravel, Yii2, MySQL, PostgreSQL, API, HTML, Javascript, Node Js, Vue Js Css, Git, C#, Selenium, Puppeteer, TLV, QR Code, BarCode, SQL Server, Devexpress, and integrating online payment gateways, Paypal, Payer, PerfectMoney, Stripe. I can start work right now

$30 AUD in 1 day

5.0

(12 reviews)

4.1

@ayesharifatmed

Hello There! This is Ayesha Siddiqua. Nice to meet with you. I am an M.B.B.S doctor. I have completed my graduation from North Bengal Medical College under Rajshahi University. A versatile and professional Web & Mobile App Developer, with a commitment to and experience of developing innovative and creative Website and Mobile App solutions. I have 10 years of experience developing Industry Standard Websites and Mobile Apps for Businesses, Organizations, and Individuals. I am Highly Experienced in: • WordPress • Drupal • Magento • Angular 1-9 • React • JavaScript • PHP • Laravel • Node.js • WooCommerce • Shopify • iOS App Development • Android App Development • React Native Development • AWS • Azure • MySQL • MongoDB If you’re interested in working with me, I’m just a quick message away! I’ll get back to you as quickly as I can. Thanks & looking forward to working with you. Best Regards Ayesha Siddique

$30 AUD in 2 days

5.0

(11 reviews)

3.7

@andreibrut7

Hello. I am a senior full stack developer. I have already read your requirement very carefully. I have rich experience with your project. I can start your project immediately, Let's discuss your project more in detail through chat Looking forward to hearing from you. Best Regards.

$20 AUD in 7 days

4.7

(10 reviews)

3.8

@bogdanvel

Hi I have experienced 4 years with only MySQL. I read your job description carefully and I think I can work on your job. I am ready to start work immediately. Please give me a quick contact after reading this cover letter. Thanks & Regards.

$30 AUD in 5 days

5.0

(2 reviews)

2.9

@onlineskills2023

=====Help with a simple SQL queries.===== I sincerely appreciate it. A versatile online and mobile app developer with experience creating new, original websites and mobile apps. I have ten years of expertise creating websites and mobile applications that adhere to industry standards for companies, groups, and individuals. I have a lot of experience with many different technologies, including WordPress, Drupal, Magento, Angular 1-9, React, JavaScript, PHP, Laravel, Node.js, WooCommerce, Shopify, iOS, Android, React Native, AWS, Azure, MySQL, and MongoDB. Please get in touch with me if you're interested in working with me. I will respond to you as soon as I can. I appreciate everything and am forward to work with you. Absolute best

$20 AUD in 7 days

5.0

(4 reviews)

2.5

@dungna1201

Hi, I can resolve your problems. Please contact to me. I will remote and fix it for you. Thank you

$20 AUD in 1 day

5.0

(1 review)

2.1

@ashishnishad

My name is ashish nishad. I have 5+ years of experience in php development. Currently i am a senior php developer in a company. But i want to work as a freelance developer so i come here. My skills : Core php, Mysql, Sql, Nodejs, Codeigniter, Laravel, Angular, Bootstrap, Html5, Jquery, CSS, Ajax, etc. Thanks for considering, Sincerely Ashish Nishad

$30 AUD in 1 day