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 ?>
Pampers Happy Sleep Pant Style Baby Diapers, Medium (M), 48 Count, 1 Pampers = 1 Night Sleep, with Anti Rash Shield, 7-12 Kg Diapers
₹475.00 (as of August 19, 2025 03:58 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.)
Mee Mee Caring Baby Wet Wipes with lid, 72 Pcs (Aloe Vera, Pack of 3)
₹199.00 (as of August 19, 2025 03:58 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 Glory Hands-Free Electric Breast Pump for Breastfeeding, Wearable, Portable, 4 Modes & 9 Suction Levels, Type-C Fast Charging, 24mm Breast Shield, Includes 19/21/27mm Soft Flange Inserts, White
Now retrieving the price.
(as of August 19, 2025 03:58 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.)
Premium Baby Diaper Pants / Potty Training Panties / Padded Underwear For 0 - 4 Years | Soft, Washable & Reusable Cotton Nappies for Boys & Girls | Leakproof, Absorbent & Breathable | 2/3/4 Pack (white printed, 1-2 years, 2, count)
₹449.00 (as of August 19, 2025 03:58 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.)
GLUN® Cute Print Baby bibs, Pack of 6 Different Colour, Waterproof, Adjustable & Washable Feeding Bibs for Infant Kids to Toddler 8-36 Months
₹159.00 (as of August 19, 2025 03:58 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.)
CHRUTRA Automatic Breast Pump Efficient Electric Milk Pump for Breastfeeding Mothers Comfortable, Portable, Quiet Suction Pump Ideal Postpartum Nursing Solution
₹1,299.00 (as of August 19, 2025 03:58 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 XXL Size, 48 Count | India's Fastest Absorbing Diaper, Patented Dry Xpert Channel, Ideal for 15 to 25 Kgs
₹746.00 (as of August 19, 2025 03:58 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.)
TEKCOOL Silicon Corner Protector for Sharp Edges, Table Corners Edge Protector, Baby Proofing Edge & Corner Guards(4 Pcs)
₹199.00 (as of August 19, 2025 03:58 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)
₹525.00 (as of August 19, 2025 03:58 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.)
StuffNest Baby Soft Hugging Neck Supporting Pillow for Head Shaping (0-12 Month), Sleeping, Gift for Babies (Sky-Blue)
₹329.00 (as of August 19, 2025 03:58 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.)
ZEBRONICS Blanc Slim Wireless Mouse with Rechargeable Battery, BT + 2.4GHz, 4 Buttons, 800/1200/1600 DPI, Silent Operation, Multicolor LED Lights
₹399.00 (as of August 18, 2025 12:18 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.)
Oakter Mini UPS for 12V WiFi Router Broadband Modem | Backup Upto 4 Hours | WiFi Router UPS Power Backup During Power Cuts | UPS Broadband Modem (12 Volt Backup Upto 4 HRS)
₹1,299.00 (as of August 18, 2025 12:18 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.)
TP-Link AC750 Wifi Range Extender | Up to 750Mbps | Dual Band WiFi Extender, Repeater, Wifi Signal Booster, Access Point| Easy Set-Up | Extends Wifi to Smart Home & Alexa Devices (RE200)
₹1,799.00 (as of August 18, 2025 12:18 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 Fast Charging 1.5M Braided Type C to Type C Cable for Smartphones, Tablets, Laptops & Other Type C Devices, PD Technology, 480Mbps Data Sync (RCTT15, Black)
₹179.00 (as of August 18, 2025 12:18 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.)
