Hi All,
I am looking for the solution of following case.
I am trying to get the data from SQL DB in the form fields which i have created in the form. I am able to input through these fields but I also want to retrieve the data in the same form.
Please help me out as soon as possible. I attached the code for input form.
INPUT AND OUTPUT PAGE CODE (MAINPAGE.PHP) -
<html>
-
<head>
-
<!-- @@@@@@@@@@@@@@@@@@@@@@@@@ date Picker script @@@@@@@@@@@@@@@@@@@@@@@@@@@ -->
-
<style>
-
-
label{
-
-
width: 6em;
-
-
float: left;
-
-
text-align: right;
-
-
margin-right: 8em;
-
-
display: block
-
-
}
-
-
</style>
-
-
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-
<title>jsDatePick Javascript example</title>
-
-
<link rel="stylesheet" type="text/css" media="all" href="jsDatePick_ltr.min.css" />
-
<!--
-
OR if you want to use the calendar in a right-to-left website
-
just use the other CSS file instead and don't forget to switch g_jsDatePickDirectionality variable to "rtl"!
-
-
<link rel="stylesheet" type="text/css" media="all" href="jsDatePick_ltr.css" />
-
-->
-
<script type="text/javascript" src="jquery.1.4.2.js"></script>
-
<script type="text/javascript" src="jsDatePick.jquery.min.1.3.js"></script>
-
<!--
-
After you copied those 2 lines of code , make sure you take also the files into the same folder :-)
-
Next step will be to set the appropriate statement to "start-up" the calendar on the needed HTML element.
-
-
The first example of Javascript snippet is for the most basic use , as a popup calendar
-
for a text field input.
-
-->
-
<script type="text/javascript">
-
window.onload = function(){
-
new JsDatePick({
-
useMode:2,
-
target:"inputField",
-
dateFormat:"%Y-%m-%d"
-
/*selectedDate:{ This is an example of what the full configuration offers.
-
day:5, For full documentation about these settings please see the full version of the code.
-
month:9,
-
year:2006
-
},
-
yearsRange:[1978,2020],
-
limitToToday:false,
-
cellColorScheme:"beige",
-
dateFormat:"%m-%d-%Y",
-
imgPath:"img/",
-
weekStartDay:1*/
-
});
-
};
-
</script>
-
<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -->
-
<title>Org Details</title>
-
</head>
-
<body>
-
<form method="post" action="insert5.php">
-
-
<h1>Insert the Following Details</h1>
-
DATE: <input type="text" size="12" name="date" id="inputField" />
-
<form method="post" action="">
-
<table cellspacing="35">
-
<tr><td><font face="verdana,arial" size=-1><Span><strong>Utilization:</strong></Span><td>
-
<textarea rows="10" cols="50" name= "utilization">
-
-
</textarea>
-
</td></tr>
-
</table>
-
-
<table cellspacing="20">
-
<tr><td><font face="verdana,arial" size=-1><Span><strong>Weekly Status:</strong></Span><td>
-
<textarea rows="10" cols="50" name= "weekly_status">
-
-
</textarea>
-
</td></tr>
-
</table>
-
-
-
-
<table cellspacing="30">
-
<tr><td><font face="verdana,arial" size=-1><Span><strong>DESUCCESS:</strong></Span><td>
-
<textarea rows="10" cols="50" name= "desuccess">
-
-
</textarea>
-
</td></tr>
-
</table>
-
-
-
-
<table cellspacing="5">
-
<tr><td><font face="verdana,arial" size=-1><Span><strong>ACCOMPLISHMENT:</strong></Span><td>
-
<textarea rows="10" cols="50" name= "accomplishment">
-
-
</textarea>
-
</td></tr>
-
</table>
-
-
-
-
<table cellspacing="45">
-
<tr><td><font face="verdana,arial" size=-1><Span><strong>ONCALL:</strong></Span><td>
-
<textarea rows="10" cols="50" name= "oncall">
-
-
</textarea>
-
<br><br>
-
<input type="submit" name="Submit" value="Submit">
-
</form>
-
<?php
-
-
?>
-
</body>
-
</html>
-
INSERT.PHP -
-
<?php
-
$con = mysql_connect("localhost","root","Oracle");
-
if (!$con)
-
{
-
die('Could not connect: ' . mysql_error());
-
}
-
-
mysql_select_db("test", $con);
-
-
$sql="INSERT INTO empinfo (orgdate, utilization, weekly_status, DE_sucess, accomplishment, oncall)
-
VALUES
-
('$_POST[date]','$_POST[utilization]','$_POST[weekly_status]','$_POST[desuccess]','$_POST[accomplishment]','$_POST[oncall]')";
-
-
-
if (!mysql_query($sql,$con))
-
{
-
die('Error: ' . mysql_error());
-
}
-
echo "1 record added";
-
-
mysql_close($con)
-
?>
-
0  1455  Sign in to post your reply or Sign up for a free account.
Similar topics
by: Ashok |
last post by:
Hi,
is it possible to extract data from a web based java applet in order to
enter that data in mysql?
for example, something that would let me extract the data shown in applet on...
|
by: David Lao |
last post by:
Hi All,
I need a way to extract Data value from the Outlook form
when the new mails arrive. The data fields are provided.
Thanks.
David
|
by: nick |
last post by:
Hi all
can any one please tell me what is wrong in this code??
I'm new to deal with text files and extract data.
i'm trying to look for data in a text file (3~4 pages) some lines start
with a...
|
by: basyarie |
last post by:
Hello All,
I`d like to introduce myself.
I`m basyarie, now is student of university.
Nice to meet you all.
I`m beginner in this discussion community.
Just want to ask about VB6 for GPS...
|
by: missolsr |
last post by:
hi,
I am using jpcap to capture OLSR topology control (udp) packets.
Does anyone know how to extract data (the way ethereal does it) from the olsr packet?
There are methods to extract data...
|
by: bootzwiz |
last post by:
Hi,
I want to extract data between tags. For example i have following code
<span class="t_t_12_b_b">Cast</span><span class="t_t_12_b">: <a href="/test/">Mel Gibb</a></span>
I want to...
|
by: bibie |
last post by:
How to extract data from mssql and then convert it to mysql using VB6.0. How to connect the mssql..I know a little bit of VB6.0 but only create an interface using STANDARD EXE. Someone told me to...
|
by: Savita23 |
last post by:
I am trying to pass a query string from the main form to subform to display records in datasheet view.I tried using the following code in the form_load() event to populate the subform(Child0)
...
|
by: ElTipo |
last post by:
Hello People,
I made a data base with secure wizard to provide to users a PID and Passwords. I need to extract data from Crystal Reports 7 in this data base but Crystal Reports send me a message...
|
by: =?Utf-8?B?aWxy?= |
last post by:
Hi
This is probably fairly simple but I am newish at programming and was
wondering if someone can give me some advice on handling the following.
I have an array with a large number of elements...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
