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 ?>
Nubokind Silicone Baby Teether Ring Set | BIS Certified Multi-Textured Soft Newborn Chew Toy | for 3, 6, 9, 12 Months + BPA Free Teether | Molar Relief Easy Grip | Safe Made in India | Pack of 2
₹609.00 (as of October 24, 2025 12:46 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.)
Amazon Brand - Supples Study Table for Kids | Suitable for 3-12 Years | Kids Study Table with Height Adjustable Table & Chair, Book Storage & Pen Holder | Pink | Candy Print
₹3,699.00 (as of October 24, 2025 12:46 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.)
R for Rabbit Comfy Shield Disposable Nursing Breast Pads 24-Hours Leak Protection 3D Shaped Honeycomb Design Strong Adhesive Tape Skin Friendly Material Breastfeeding pad (White, Pack of 36)
₹226.00 (as of October 24, 2025 12:46 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 Medium 74 Count (Pack of 1), 7-12 kgs, 10 hrs Leak Protection, Anti - Bacterial
₹528.00 (as of October 24, 2025 12:46 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.)
Mother Sparsh 99% Pure Water (Unscented) Baby Wipes with Lid I Natural Plant made cloth - Super thick Wet Wipes I 72 pcs/pack - Pack of 2 (Super Saver Pack)
₹369.00 (as of October 24, 2025 12:46 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.)
NOVEL Baby Wet Wipes/Pack With Lid (Pack of 6-80 Sheet)
₹269.00 (as of October 24, 2025 12:46 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.)
Jr. Sr. Baby Tape Diapers with Advanced Leak Protection | Soft & Comfortable | Pack of 1 | New Born - 72 Count
₹569.00 (as of October 24, 2025 12:46 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.)
Himalaya Powder For Baby, 700G
₹289.00 (as of October 24, 2025 12:46 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.)
Babypro Multicolour Kid's Play Mat for Floor Cushioning (Set of 1, 12mm) Interlocking Tiles, Soft, Durable, Eco-Friendly, Anti-Slip, Waterproof, Perfect for Playtime, Exercise, Yoga & Baby Protection on Hard Floors
₹289.00 (as of October 24, 2025 12:46 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.)
Tidy Sleep Baby Changing Mat – Waterproof, Foldable, Padded Diaper Changing Sheets for Newborns & Infants – Jurassic Dino Boy (65 cm x 45 cm)
₹269.00 (as of October 24, 2025 12:46 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 Konnect X USB to Type C Cable with 3A Output, Fast Charging & Data Transfer, Nylon Braided, Aluminium Alloy Shell, 1M Length compatible with Type C Smartphones(White)
₹125.00 (as of October 23, 2025 21:37 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.)
Apple USB-C to Lightning Cable (1m)
₹1,499.00 (as of October 23, 2025 21:37 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 200HB USB 3.0 4 Port hub with Hi Speed Data Transfer, Aluminum + ABS Body, 15cm Cable, Sleek Design and Plug Play Usage
₹199.00 (as of October 23, 2025 21:37 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 Mpad Mouse Mat 230X190X3mm Gaming Mouse Pad, Non-Slip Rubber Base, Waterproof Surface, Premium-Textured, Compatible with Laser and Optical Mice(Universe Black)
₹89.00 (as of October 23, 2025 21:37 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.)
