Wisemonkeys

Feed Notification Profile Manage Forms

Feed Notification Search Sign in

Top Users

Swatis

Mayurpandey

Nitin Karalkar

@nitin_karalkar

Featured Blogs

Subnet Masking

How Cyber Forensics help prevent Crimes

Online Games

Burning Questions

Which IT company's nickname is ' The Big Blue ' ?

What is HTML ? Differentiate between HTML and HTML5?

explain basics of designing .

|

|

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

729 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

504 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

439 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