Posted on 16 Aug 2022, this text provides information on Bugs & Fixes related to General Tech. Please note that while accuracy is prioritized, the data presented might not be entirely correct or up-to-date. This information is offered for general knowledge and informational purposes only, and should not be considered as a substitute for professional advice.

Take Quiz To Earn Credits!

Turn Your Knowledge into Earnings.

Answers (3)

Post Answer

manpreet Best Answer 2 years ago

I am trying to insert data into a MySql database with the query below.

$sqlQuery = "insert into abc set a='$var1', b=STR_TO_DATE('$b', '%d/%m/%Y')"

I get this error

Incorrect datetime value: '' for function str_to_date()

How can I default both a and b to NULL when the variable values are missing.

0 views

0 shares

manpreet 2 years ago

Set default value of these columns in your database as NULL so when these values is missing then NULL with automatically saved as default.

0 views 0 shares

manpreet 2 years ago

Don't Give mysql to change date format. Do it by your PHP code.

$a = !empty($_POST['var1']) ? $_POST['var1'] : null;
$b = !empty($_POST['var2']) ? date('d/m/Y', strtotime($_POST['var2'])) : null;
$sqlQuery = "Insert into abc(a,b) values('$a','$b')";

0 views 0 shares

No matter what stage you're at in your education or career, TuteeHub will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

Explore Other Libraries

Blogs Tutorials Question Bank Feeds Careernews

Popular Categories

Php - Mysql default to NULL while inserting data

Take Quiz To Earn Credits!

Answers (3)

manpreet Best Answer 2 years ago

manpreet 2 years ago

manpreet 2 years ago

Which operating system you favour and why?

What are the most popular tech portals in India?

What are best technologies available today for education / aiding learning?

What professional training certifications are most marketable?

What are the course certificates or skills that engineers should have other than their academics?

What is the full form of NABARD ?

How to refresh app upon shaking the device?

What are the govt exams after BCA?

TYPO3 v8. Override function in Core class

Why do people in India give so much importance to Government jobs?

Which is the best red ball team in cricket right now?

zkskKsk

Qwerty 4

What are the key differences between AMOLED and LCD displays in smartphones?

What are the key challenges in Mobile App Development for Cross-Platform Solutions?

Explore Other Libraries

Tags

Important General Tech Links

Join Our Community Today