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 ?>
Philips Avent Ultra Air Soother - 2 x Light, Breathable Baby Soothers for Babies Aged 0‑6 Months, BPA-Free with Steriliser Carry Case (Model SCF085/58) by Fratelli
₹559.00 (as of April 29, 2024 00: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.)
Mee Mee Caring Baby Wet Wipes with lid, 72 Pcs (Aloe Vera, Pack of 3)
₹225.00 (as of April 29, 2024 00: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.)
Gnanishwa Humidifiers For Bedroom Colorful Cool Mini Humidifiers with LED Night Light USB 300ml Mist Humidifiers for Car Office Room, 26db Quiet Ultra Humidifiers, Portable Diffuser (300ML) (White)
₹349.00 (as of April 29, 2024 00: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.)
Babycov Neem Wood Teethers for Babies | Natural and Organic | Wooden Baby Teether | Helps in Teething | Set of 2 | for 3+ Months Babies. (Teether Stick + Ring)
₹199.00 (as of April 29, 2024 00: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.)
Bumtum Baby Chota Bheem Gentle Soft Moisturizing Wet Wipes With Lid | Aloe Vera & Chamomile Extracts | Paraben & Sulfate Free (Pack of 6, 72 Pcs. Per Pack)
₹279.00 (as of April 29, 2024 00: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.)
Bumtum Baby Gentle 99% Pure Water Soft Moisturizing Wet Wipes With Lid | Aloe Vera & Chamomile Extracts | Paraben & Sulfate Free (Pack of 6, 72 Pcs. Per Pack)
₹279.00 (as of April 29, 2024 00: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.)
Supples Baby Wet Wipes with Aloe Vera and Vitamin E - 72 Wipes/Pack, (Pack of 3)
₹185.00 (as of April 29, 2024 00: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.)
R for Rabbit Medium m Size Premium Feather Diaper for Baby 7 to 12 kgs (48 Pack Offer)
₹897.00 (as of April 29, 2024 00: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.)
Little's Soft Cleansing Baby Wipes Lid, 80 Wipes (Pack of 3)
₹423.00 (as of April 29, 2024 00: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 Premium Care Pants Style Baby Diapers, X-Large (XL) Size, 72 Count, All-in-1 Diapers with 360 Cottony Softness, 12-17kg Diapers
₹1,699.00 (as of April 29, 2024 00: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.)
One94Store Portable Compact USB Mini Hand Fan With Powerful Brushless Motor, 3 Speeds, 1200mAh Rechargeable Battery (Up to 4Hrs), Ideal for Office, Kitchen, Outdoor, Makeup & Travel Use (Blue, X1)
₹599.00 (as of April 28, 2024 16:04 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, Silver
₹439.00 (as of April 28, 2024 16:04 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.)
Logitech B170 Wireless Mouse, 2.4 GHz with USB Nano Receiver, Optical Tracking, 12-Months Battery Life, Ambidextrous, PC/Mac/Laptop - Black
₹595.00 (as of April 28, 2024 16:04 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 April 28, 2024 16:04 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.)
