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 ?>
Baby Disposable Diaper Bags with Dispenser, Waste Bags 6 Refill Rolls/90 Bags, Convenient and Quick Diaper Disposal, Unscented Leak & Odors Proof Diaper Trash Bags for Newborn Diapers (6 Roll + Case)
₹279.00 (as of June 16, 2025 17:55 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.)
Huggies Complete Comfort Wonder Pants | Pant Style Baby Diapers New Born / XS Size, 90 Count | India's Fastest Absorbing Diaper, Patented Dry Xpert Channel, Ideal for 0-5 Kgs
₹593.00 (as of June 16, 2025 17:55 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.)
Bumtum Baby Diaper Pants, XL Size, 54 Count, Double Layer Leakage Protection Infused With Aloe Vera, Cottony Soft High Absorb Technology (Pack of 1)
₹527.00 (as of June 16, 2025 17:55 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.)
PEARS Pure & Gentle Shower Gel, 400ml Refill Pouch, for Soft, Smooth and Moisturized Skin, with 98% Pure Glycerin & Natural Oils, Dermatologically Tested, 100% Soap Free
₹185.00 (as of June 16, 2025 17:55 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.)
Sebamed Baby Cleansing Bar|pH 5.5 |Newborn bathing|Soap Free|Tear Free|100 gm
₹300.00 (as of June 16, 2025 17:55 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.)
Pax Parrot Baby Powder Puff Box – Bear Design | 4 Pax Parrot Characters Stickers for Baby | Refillable Dispenser with Soft Applicator for Newborns & Infants | Compact & Travel-Friendly Container (Turquoise)
₹299.00 (as of June 16, 2025 17:55 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 Natural Baby Feeding Bottle | No.1 Brand Recommended by Moms Worldwide | Ideal for 0 months+| Natural Response Technology Mimics Breastfeeding | Uniquely Designed Nipple releases milk only when baby drinks | Pack of 1 | SCY900/01
₹495.00 (as of June 16, 2025 17:55 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.)
Rster Silicon Corner Protector for Sharp Edges, Table Corners Edge Protector, Baby Proofing Edge & Corner Guards
Now retrieving the price.
(as of June 16, 2025 17:55 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.)
Extra Large Foldable Play Mat,180 X 150 Cm Reversible Baby Play Mat, Waterproof Baby Mat for Floor, Foam Play Mat (GO Green Theme),Multi Color,1 Count
₹599.00 (as of June 16, 2025 17:55 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.)
Owme Unicorn Night Lights for Girls Bedroom,16 Colors Cute Night Light for Kids, Led Rechargeable Unicorn Lamp, Unicorns Gifts for Girls Night Lamp, Silicone Night Light Kids Cute - Multicolor
₹299.00 (as of June 16, 2025 17:55 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.)
Ambrane Unbreakable 60W / 3A Fast Charging 1.5m Braided Micro USB Cable for Smartphones, Tablets, Laptops & Other Micro USB Devices, 480Mbps Data Sync, Quick Charge 3.0 (RCM15, Black)
₹149.00 (as of June 17, 2025 06:42 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.)
HP v236w USB 2.0 64GB Pen Drive, Metal
₹399.00 (as of June 17, 2025 06:42 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
₹595.00 (as of June 17, 2025 06:42 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.)
Ambrane Unbreakable 3A Fast Charging 1.5m Braided Type C Cable for Smartphones, Tablets & other Type C devices, 480Mbps Data Sync, Quick Charge 3.0 (RCT15A, Black)
₹169.00 (as of June 17, 2025 06:42 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.)
