gud day to all TSD.
if i run the code below which is HTML combine with php. my problem encoutered in php code. it will automatically save all blank textbox i declare in php to my database using mysql if i will run this page.
please correct my problem in my code.
thnx again... -
-
<? session_start(); ?>
-
-
<head>
-
<title>My Page</title>
-
<style type="text/css">
-
<!--
-
#Layer1 {
-
position:absolute;
-
left:200px;
-
top:10px;
-
width:816px;
-
height:540px;
-
z-index:1;
-
}
-
.style3 {font-family: Arial, Helvetica, sans-serif}
-
.style4 {font-family: Arial}
-
a:link {
-
text-decoration: none;
-
}
-
a:visited {
-
text-decoration: none;
-
}
-
a:hover {
-
text-decoration: none;
-
}
-
a:active {
-
text-decoration: none;
-
}
-
.style14 {color: #FF0000; font-family: Geneva, Arial, Helvetica, sans-serif; }
-
-->
-
</style>
-
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
-
</head>
-
-
<body>
-
-
<div id="Layer1">
-
<table width="808" height="538" border="0" cellpadding="0" cellspacing="0" bordercolor="#2A1F00">
-
<tr>
-
<td width="236" height="110"><img src="image/Nagano Header.jpg" width="236" height="110" alt="" /></td>
-
<td colspan="4"><img src="image/header.jpg" width="598" height="110" alt="" /></td>
-
</tr>
-
<tr>
-
<td height="22" colspan="5" bordercolor="#0000FF" bgcolor="#DAE2C7"><span class="style14">CREATE YOUR ID</span> </td>
-
</tr>
-
-
<form name="form1" method="post" action="register.php">
-
-
<tr>
-
<td height="42" bgcolor="#F7F7F7"><div align="right" class="style3">* First Name </div></td>
-
<td width="20" bgcolor="#F7F7F7"> </td>
-
<td width="159" bgcolor="#F7F7F7"><input name="txtfname" type="text" id="txtfname" /></td>
-
<td width="48" bgcolor="#F7F7F7"> </td>
-
<td width="364" bgcolor="#F7F7F7"><label></label></td>
-
</tr>
-
<tr>
-
<td height="25" bordercolor="#F7F3EF" bgcolor="#F7F7F7"><div align="right">* <span class="style4">Last Name</span> </div></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><input name="txtlname" type="text" id="txtlname" /></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><label></label></td>
-
</tr>
-
<tr>
-
<td height="36" bordercolor="#F7F3EF" bgcolor="#F7f7f7"><div align="right" class="style4">* Gender </div></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><select name="mnugender" id="mnugender">
-
<option value="0">[Select]</option>
-
<option value="1">Male</option>
-
<option value="2">Female</option>
-
</select></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><label></label></td>
-
</tr>
-
<tr>
-
<td height="34" bordercolor="#F7F3EF" bgcolor="#F7F7F7"><div align="right">* Log-in ID </div></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><label>
-
<input name="txtlogid" type="text" id="txtlogid">
-
</label></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
</tr>
-
<tr>
-
<td height="34" bordercolor="#F7F3EF" bgcolor="#F7F7F7"><div align="right" class="style4">* Password</div></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><input name="txtpassword" type="password" id="txtpassword" /></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
</tr>
-
-
<tr>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><div align="right" class="style4">* Re-type Password </div></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><input name="txtretypepass" type="password" id="txtretypepass" /></td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"> </td>
-
<td bordercolor="#F7F3EF" bgcolor="#F7F7F7"><label></label></td>
-
</tr>
-
<tr>
-
<td height="38" bgcolor="#F7F7F7"><div align="right"><span class="style4">Birth Date </span></div></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><select name="mnuMonth" id="mnuMonth">
-
<option value="0">[Select Month]</option>
-
<option value="1">January</option>
-
<option value="2">February</option>
-
<option value="3">March</option>
-
<option value="4">April</option>
-
<option value="5">May</option>
-
// OTHER OPTION VALUES 6-11 GOES HERE
-
<option value="12">December</option>
-
</select></td>
-
<td bgcolor="#F7F7F7"><label>
-
<select name="txtday" id="txtday">
-
<option value="1" selected>1</option>
-
<option value="2">2</option>
-
<option value="3">3</option>
-
// OTHER OPTION VALUES 3-30 GOES HERE
-
<option value="31">31</option>
-
</select>
-
</label></td>
-
<td bgcolor="#F7F7F7"><label>
-
<input name="txtyear" type="text" id="txtyear" value="yyyy" size="4">
-
</label></td>
-
</tr>
-
<tr>
-
<td height="39" bgcolor="#F7F7F7"><div align="right" class="style4">Zip/Postal code </div></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><input name="txtzip" type="text" id="txtzip" /></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"> </td>
-
</tr>
-
<tr>
-
<td height="27" bgcolor="#F7F7F7"><div align="right"><span class="style4">* Email Address</span></div></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><input name="txtemailadd" type="text" id="txtemailadd" /></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"> </td>
-
</tr>
-
-
<tr>
-
<td height="33" bgcolor="#F7F7F7"><div align="right" class="style4">User Access Level </div></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><label>
-
<select name="mnuAccess" id="mnuAccess">
-
<option value="0">[Select Level]</option>
-
<option value="1">Administrator</option>
-
<option value="2">Limited</option>
-
</select>
-
</label></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"> </td>
-
</tr>
-
<tr>
-
<td height="19" bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><label></label></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"> </td>
-
</tr>
-
<tr>
-
<td bgcolor="#F7F7F7"><a href="index.html" target="_parent"></a></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><input name="Submit" type="Submit" class="style4" id="Submit" value=" Submit " onClick="javascript:alert('Your form has been submitted')">
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"> </td>
-
</tr>
-
-
<tr>
-
<td height="24" colspan="5" bgcolor="#F7F7F7"><div align="left">
-
<blockquote>
-
<blockquote>
-
<blockquote>
-
<blockquote>
-
<blockquote>
-
<blockquote>
-
<p><a href="index.html" target="_parent"><strong>BACK TO HOME PAGE </strong></a></p>
-
</blockquote>
-
</blockquote>
-
</blockquote>
-
</blockquote>
-
</blockquote>
-
</blockquote>
-
</div></td>
-
</tr>
-
<tr>
-
<td bgcolor="#F7F7F7"><div align="right" class="style4"><a href="index.html" target="_parent"></a></div></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><a href="index.html" target="_parent"></a></td>
-
<td bgcolor="#F7F7F7"> </td>
-
<td bgcolor="#F7F7F7"><label></label></td>
-
</tr>
-
</table>
-
-
</div>
-
</body>
-
</html>
-
-
<?php
-
-
if (isset($_POST["Submit"]))
-
-
include'package/connect.inc.php';
-
mysql_select_db('database');
-
-
$user_sql = "INSERT INTO userpass(loginId,fname,lname,gender,password,repassword,bdate,zip,emailadd,accesslevel,regdate,reghours)
-
values('". $_POST["txtlogid"] ."','". $_POST["txtfname"] ."','". $_POST["txtlname"] ."',
-
'". $_POST["mnugender"] ."','". $_POST["txtpassword"] ."',
-
'". $_POST["txtretypepass"]."','". $_POST["mnuMonth"]."-". $_POST["txtday"]."-". $_POST["txtyear"]."',
-
'". $_POST["txtzip"]."',
-
'". $_POST["txtemailadd"]."','". $_POST["mnuAccess"]."',
-
'". date("F j, Y, g:i a")."','". date("H:i:s A")."')";
-
$result = mysql_query($user_sql);
-
-
}
-
?>
-
Sep 18 '07
13  2654 
Well you do have an if statement that controls nothing [PHP]if (isset($_POST["Submit"]))
include'package/connect.inc.php ';
mysql_select_db ('database');[/PHP]Looks like you are missing a brace after the if statement
ok in my code that is pair ( { } ) in if statement. but the same it will automatically save.
code green 1,726
Recognized Expert Top Contributor
ok in my code that is pair ( { } ) in if statement. but the same it will automatically save.
If the $_POST["Submit"] button has been clicked you will write to the database.
If you are writing to the database without clicking then your php code is wrong.
Can you show the true version (please leave out the HTML)
If the $_POST["Submit"] button has been clicked you will write to the database.
If you are writing to the database without clicking then your php code is wrong.
Can you show the true version (please leave out the HTML)
this is the php code:
<?php
if (isset($_POST["Submit"]))
{
include'package/connect.inc.php ';
mysql_select_db ('database');
$user_sql = "INSERT INTO userpass(loginI d,fname,lname,g ender,password, repassword,bdat e,zip,emailadd, accesslevel,reg date,reghours)
values('". $_POST["txtlogid"] ."','". $_POST["txtfname"] ."','". $_POST["txtlname"] ."',
'". $_POST["mnugender"] ."','". $_POST["txtpasswor d"] ."',
'". $_POST["txtretypep ass"]."','". $_POST["mnuMonth"]."-". $_POST["txtday"]."-". $_POST["txtyear"]."',
'". $_POST["txtzip"]."',
'". $_POST["txtemailad d"]."','". $_POST["mnuAccess"]."',
'". date("F j, Y, g:i a")."','". date("H:i:s A")."')";
$result = mysql_query($us er_sql);
}
?>
code green 1,726
Recognized Expert Top Contributor
ok sir. my problem is if i run those PHP code it will automatically save to mysql database. in the PHP at the buttom
If below is the correct opening of the php code
[PHP]if (isset($_POST["Submit"]))
{[/PHP]And this is the correct HTML for the submit button
[HTML]"><input name="Submit" type="Submit" [/HTML]
Then what we seem to be missing now is a closing form tag [HTML]</form>[/HTML]
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Chris Lobdell |
last post by:
Hey, everyone.
For the past two years, we have offered files for download through a
secure website. Users, after clicking on a link, are redirected to a
PHP page that passes the appropriate header information to the user
and inquires if that user wishes to download the file.
A sample of that code is below:
header('Content-Type: application/save');
header('Content-Disposition:attachment; filename="'.$file_path .'"');
|
by: Ido |
last post by:
Hello,
I am searching for an automatic forms creation tool that will help me
to save time in developin forms (preferrably with validation).
My forms get some data from a MySQL database and are supposed to save
all data back to the database.
Any recommendations!?
|
by: Mel |
last post by:
when downloading files from my site, when file types are known (i.e *.doc)
browsers open the file for viewing.
is there a way to disable that and just present the save as dialog (same as
for unknown types zip files etc.) ?
thanks
Mel
|
by: Federico |
last post by:
I want to create an automatic log system that writes to a ofstream
(the logfile) all the output sent to screen.
I tried to make a class COutput with the operator << overloaded for
the different kind of data types, but a problem arrived when I tried
to use io manipulators such as setprecision.
I have this in class COutput:
COutput& operator<<(ios& (*fnc)(ios&)) {
(*fnc)(cout); // For the screen
(*fnc)(logfile); // For the logfile (an...
|
by: ray |
last post by:
I have a client that doesn't want Access to automatically repair into a
backup file if it crashes (and it crashes only on very rare occasions).
My (sketchy) understanding is that this is a Windows function that
can't be stopped by using runtime switches, advanced options or other
hi-falutin' database properties.
Ami I correct that the automatic repair has nothing to do with Access
itself? Is there another way to stop it happening?
| | |
by: Mike Saunders |
last post by:
I have a basic web site where people can download my programs.
To make it easier for them is it possible that I could add some
javascript that would allow them to automatically install/run the
program for them maybe with appropriate options/warnings etc
Sme example code would be most appreciated
Many thanks
|
by: Jorge Peixoto de Morais Neto |
last post by:
I was reading the code of FFmpeg and it seems that they use malloc
just too much. The problems and dangers of malloc are widely known.
Malloc also has some overhead (although I don't know what is the
overhead of automatic variable sized arrays, I suspect it is smaller
than that of malloc), although I'm not too worried about it.
I was thinking that, with C99's variable length arrays, malloc
shouldn't be needed most of the time. But I'm...
|
by: subhashkumar |
last post by:
Running data Append to a table
Dear All,
I need a help from this forum, I was developing a small tools for stock market.
I get stuck when trying to save the running changes in a data field value from a form to a table.
Here I have two table and one form
1. LiveData - (Connected to external file which reflect the changes automaticaly)
|
by: Peter Hofmann |
last post by:
When I change the source code and save it I have currently always to press
explicitely F6 zu "compile" the code (and get new error list).
Isn't there an automatic build function which is called whenever I save new code ?
BTW: What is the difference between the two menues:
Build->Build solution
and
|
by: TechieGrl |
last post by:
I want to save a zip file daily. The file is named the same thing
each day so I would like to create a folder and name it with today's
date and then save the zip file into that folder.
I'm using this code and can't seem to figure out how to create the new
folder and save the file there.
Any help is appreciated!
$todays_date = date("Ymd");
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
