Connect to Mysql using PHP
<?php
$con = mysqli_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysqli_error());
}
mysqli_select_db($con,"your_database_name");
?>
To display current date and time
<?php
$current_date_time = date('Y-m-d H:i:s'); //in mysql storing format
?>
Convert date format from ‘d-m-Y’ to ‘Y-m-d’
<?php
$dob = $_POST['dob']; //value get from the form
$covert_dob = date("Y-m-d",strtotime($dob));
?>
show a number to 2 decimal places
<?php $foo = "54.104"; echo number_format((float)$foo, 2, '.', ''); //output 54.10 $ful = "54"; echo number_format((float)$ful, 2, '.', ''); //output 54.00 ?>
LuvLap Moisturising Wet Wipes with Lid For Baby Skin, Enriched with Aloe Vera, Vitamin E & Chamomile Extract, pH Balanced, Dermatologically Safe, Paraben & Sulphate Free, 72 Wipes, pack of 3
₹207.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
TRAXITO 12 PCS Edge Protector for Furniture Table Corner Guards for Sharp Edges Silicon Corner Protector for Sharp Edges Gel Table Corner Protector and Soft PVC Transparent Corner Guard (12)
₹289.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Babykicks Multifunctional Toddler Learning Baby Walker with Musical Buttons Lights & Roll Ball
₹1,099.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Vn care Silicon Corner Protector for Sharp Edges, Table Corners Edge Protector for Kids, Bed Corners Edge Protector for Furniture, Baby Proofing Edge & Corner Guards (Transparent, Pack of 12)
₹298.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Teddyy Baby Easy Pant Diapers Large 62 Count (Pack of 1)
₹689.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
BeyBee Waterproof Quick Dry Sheet for Baby| Bed Pad Anti-Piling Fleece Extra Absorbent Washable Matress Protector| Baby Bed Protector Sheet for Toddler Children, Medium Size, 100x70cm, Violet
₹249.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
LuvLap Pant Style Baby Diapers, Large (L), 62 Count, For babies of Upto 9-14Kg with Aloe Vera Lotion for rash protection, with upto 12hr protection, Diapers
₹599.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Honey Bunny Baby Diaper Pants Super Soft Dry Plus 12 Hour protection M-144
Now retrieving the price.
(as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Philips Avent Nipple Shield | Shaped to Allow Skin Contact | Protect Sore Nipples | Medium(21mm) | 2 pcs | SCF153/03
₹545.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Pampers Active Baby New Born Diapers (72 Count)
₹1,045.00 (as of December 21, 2024 19:21 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
STRIFF World Map Extended Size (800 mm x 300 mm x 2 mm) Gaming Mouse Pad| Desk Mat | Stitched Edges| Non-Slip Rubber Base|Computer Laptop|Keyboard Mouse Pad for Office & Home (World Map)
₹209.00 (as of December 21, 2024 05:17 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Seagate Expansion 1TB External HDD - USB 3.0 for Windows and Mac with 3 yr Data Recovery Services, Portable Hard Drive (STKM1000400)
₹5,149.00 (as of December 21, 2024 05:17 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
Portronics Toad One Bluetooth Mouse with 2.4 GHz & BT 5.3 Dual Wireless, 6 Buttons, Rechargeable, RGB Lights, Connect 3 Devices, Ergonomic Design for Laptop, Smartphone, Tablet (Black)
₹599.00 (as of December 21, 2024 05:17 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
FUR JADEN Anti Theft Number Lock Backpack Bag with 15.6 Inch Laptop Compartment, USB Charging Port & Organizer Pocket for Men Women Boys Girls
₹649.00 (as of December 21, 2024 05:17 GMT +05:30 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)
