Wisemonkeys

Feed Notification Profile Manage Forms

Feed Notification Search Sign in

Prerna

user banner image

Prerna @prerna

Resume Blogs Questions

Top Users

Rohini Patil

Rahul Maity

Tejal Jambhale

@tejaljambhale98

Featured Blogs

Smartsheet

Data Mining

Scala - a programming tool

Burning Questions

How many words should you write for a 5 mark question?

Difference between contract management and technical project management.?

What is the name of first computer network?

|

|

Points nomenclature

|

Terms of service

|

|

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', 'prerna430@gmail.com', '0000-00-00', '12:00:00.000000', '0000-00-00', '01:00:00.000000', 'delux', 2), ('prerna', 'prerna430@gmail.com', '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