Wisemonkeys

Feed Notification Profile Manage Forms

Feed Notification Search Sign in

Top Users

Riya Singh

Aashna Shaikh

joel chettiar- 11

@joelchettiar-11

Featured Blogs

Data Structures

Raid

Cyber Forensics on IOT Devices

Burning Questions

What is Steganography and it's role in Cyber Forensic?

What is cryptography

What is darkweb & who was inventer of it ?

|

|

Points nomenclature

|

Terms of service

|

|

Prerna

user banner image

Prerna @prerna

Resume Blogs Questions

Prerna

@prernaMar 10, 2018

How to send a autogenerated email in php where email id's are fetched from php form

<div class="w3_mail_grids"> <form action="contactform.php" method="post"> <div class="col-md-6 w3_agile_mail_grid"> <input type="text" placeholder="Your Name" required="" name="name"> <input type="email" placeholder="Your Email" required="" name="email"> <input type="text" placeholder="Your Phone Number" required="" name="phone" maxlength="10"> </div> <div class="col-md-6 w3_agile_mail_grid"> <textarea placeholder="Your Message" required="" name="message"></textarea> <input type="submit" value="Submit" > </div> <div class="clearfix"> </div> </form> </div> </div>   This is my form I want an autogenerated mail which should be sended when user clicks on submit

2 Discussions

728 Reads

Prerna

@prernaMar 10, 2018

Multiple Entries are taking place in database table

?php include 'database.php'; $name = $_POST["name"]; $email =$_POST["email"]; $arrivaldate =$_POST["arrivaldate"]; $time =$_POST["time"]; $deptdate= $_POST["deptdate"]; $depttime=$_POST["depttime"]; $roomtype=$_POST["roomtype"]; $person=$_POST["person"]; $arrivaldate=date('Y-m-d',strtotime($arrivaldate)); //Converts date to 'yyyy-mm-dd' acceptable to mysql $time=date('H:i:s',strtotime($time)); // $deptdate=date('Y-m-d',strtotime($deptdate)); //Converts date to 'yyyy-mm-dd' acceptable to mysql $depttime=date('H:i:s',strtotime($depttime)); // $sql = "INSERT INTO `rooms`(`name`, `email`, `arrivaldate`, `time`, `deptdate`, `depttime`, `roomtype`, `person`) VALUES ('$name','$email','$arrivaldate','$time','$deptdate','$depttime','$roomtype','$person')"; mysqli_query($conn,$sql); //echo $sql; if ($conn->query($sql) === TRUE) { echo "YOUR REQUEST HAS BEEN PROCESSED SUCCESFULLY WE WILL GET IN TOUCH THROUGH EMAIL SHORTLY"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); ?>

3 Discussions

499 Reads

Prerna

@prernaJan 11, 2018

In sql table phone number is showing as blank

This is my code for inserting data from form into sql table but phone number is displayed as blank in tbale. <?php include 'database.php'; $name =$_POST["name"]; $email =$_POST["email"]; $phone =$_POST["phone"]; $message =$_POST["message"]; $sql = "INSERT INTO `contact`(`name`, `email`, `phone`, `message`) VALUES ('$name','$email','$phone','$message')"; mysqli_query($conn,$sql); // echo $sql; if ($conn->query($sql) === TRUE) { echo "New record created successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; } $conn->close(); ?>

1 Discussions

438 Reads

Prerna

@prernaDec 28, 2017

How to store datez and time from php form to sql in phpmyadmin

  -- -- Table structure for table `rooms` -- CREATE TABLE `rooms` ( `name` varchar(22) NOT NULL, `email` varchar(22) DEFAULT NULL, `arrivaldate` date NOT NULL, `time` time(6) NOT NULL, `deptdate` date NOT NULL, `depttime` time(6) NOT NULL, `roomtype` text NOT NULL, `person` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `rooms` -- INSERT INTO `rooms` (`name`, `email`, `arrivaldate`, `time`, `deptdate`, `depttime`, `roomtype`, `person`) VALUES ('prerna', '[email protected]', '0000-00-00', '12:00:00.000000', '0000-00-00', '01:00:00.000000', 'delux', 2), ('prerna', '[email protected]', '0000-00-00', '12:00:00.000000', '0000-00-00', '01:00:00.000000', 'delux', 2); COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

1 Discussions

603 Reads