Wisemonkeys

Feed Notification Profile Manage Forms

Feed Notification Search Sign in

Prerna

user banner image

Prerna @prerna

Resume Blogs Questions

Top Users

Sankalp Ambekar

@sankalpambekar62

Vaibhav Gohil

Parth Dhanesha

@parthdhanesha80

Featured Blogs

The most common internet security threats

Protect yourself from System Hacking with these Simple Steps

KPMG (Klynveld Peat Marwick Goerdeler)

Burning Questions

Write a note on incident logging and categorisation

Which is the software that we can edit photo easily?

What is Round Robin(RR) Scheduling Algorithm

|

|

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