Form Help Needed.

JaseGW · December 5, 2012

Hi all.

I was wondering if someone could help me out on this basic form I have created.

The two pages are below and what I want to do is add this http://www.ama3.com/anytime/

But after trying all sorts, I cantt get it right, hence a field to enter it manually.......

insert.php

<?php
// Define your username and password
$username = "user";
$password = "password";
if ($_POST['txtUsername'] != $username || $_POST['txtPassword'] != $password) {
?>
<h1>Login</h1>
<form name="form" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<p><label for="txtUsername">Username:</label>
<br /><input type="text" title="Enter your Username" name="txtUsername" /></p>
<p><label for="txtpassword">Password:</label>
<br /><input type="password" title="Enter your password" name="txtPassword" /></p>
<p><input type="submit" name="Submit" value="Login" /></p>
</form>
<?php
}
else {
?>
<body>
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td><form name="form1" method="post" action="insert_ac.php">
<table width="100%" border="0" cellspacing="1" cellpadding="3">
<tr>
<td colspan="3"><strong>Send Message </strong></td>
</tr>
<tr>
<td width="71">To</td>
<td width="6">:</td>
<td width="301"><input name="MessageTo" type="varchar(80)" id="MessageTo"></td>
</tr>
<tr>
<td>Message</td>
<td>:</td>
<td><textarea name="MessageText" id="MessageText"></textarea></td>
</tr>
<tr>
<td>Time</td>
<td>:</td>
<td><input name="Scheduled" type="datetime" id="Scheduled" value="YYY-MM-DD HH:MM:00"></td>
</tr>
<tr>
<td colspan="3" align="center"><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</body>
<?php
}
?>

insert_ac.php

<?php
$host="localhost"; // Host name
$username="*****"; // Mysql username
$password="*****"; // Mysql password
$db_name="sms"; // Database name
$tbl_name="messageout"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Get values from form
$MessageTo=$_POST['MessageTo'];
$MessageText=$_POST['MessageText'];
$Scheduled=$_POST['Scheduled'];
// Insert data into mysql
$sql="INSERT INTO $tbl_name(MessageTo, MessageText, Scheduled)VALUES('$MessageTo', '$MessageText', '$Scheduled')";
$result=mysql_query($sql);
// if successfully insert data into database, displays message "Successful".
if($result){
echo "Successful";
echo "<BR>";
echo "<a href='insert.php'>Back to main page</a>";
}
else {
echo "ERROR";
}
?>
<?php
// close connection
mysql_close();
?>

NomadicJosh · December 5, 2012

Make sure to include all the javascript files you need. Then try this and see if it works:

<input name="Scheduled" type="datetime" id="Scheduled" />
<script>
$("#Scheduled").AnyTime_picker(
{ format: "%Y-%m-%d %H:%i:%s %E %#",
formatUtcOffset: "%: (%@)",
hideInput: true,
placement: "inline" } );
</script>

Edited December 5, 2012 by parkerj

Sign In

Form Help Needed.

Recommended Posts

JaseGW

Link to comment

Share on other sites

NomadicJosh

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information