PDA

View Full Version : insert record


marc0627
02-13-2006, 07:00 AM
Thank alot to Creative Insanity and to all of those people who made the VTM it really help me a lot you the lord bless you with more knowledge.... thanks do you have a vtm regarding how to insert the data on my registry.php??? i have the form but i don't know what to do and how to do it just give and idea please :cry: thanks alot to all

davidj
02-13-2006, 11:09 AM
thanks do you have a vtm regarding how to insert the data on my registry.php???


what??

explain in more detail

marc0627
02-14-2006, 01:23 AM
i created a database for student and proffesor and then i want to input data on the database and i don't know how to do it i alredy have the form and data base but how can i inset them... here it is so what shall do???

HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Registry</title>
<style type="text/css">
<!--
body {
background-image: url(fire3.png);
}
.style1 {font-family: "Times New Roman", Times, serif;
font-weight: bold;
font-size: x-large;
}
.style2 {font-family: Georgia, "Times New Roman", Times, serif;
font-size: xx-large;
color: #990000;
}
.style3 { color: #990000;
font-weight: bold;
}
.style4 {color: #000000; font-weight: bold; }
-->
</style></head>

<body>

<p align="center"><span class="style2">Faculty Web Board</span></p>
<hr>
<p align="left">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="40" height="15">
<param name="BGCOLOR" value="">
<param name="movie" value="text3.swf">
<param name="quality" value="high">
<embed src="text3.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="40" height="15" ></embed>
</object>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="51" height="15">
<param name="movie" value="text4.swf">
<param name="quality" value="high">
<embed src="text4.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="51" height="15" ></embed>
</object>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="57" height="15">
<param name="BGCOLOR" value="">
<param name="movie" value="text9.swf">
<param name="quality" value="high">
<embed src="text9.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="57" height="15" ></embed>
</object>
</p>
<p align="center" class="style2">Welcome !!! </p>
<p align="center" class="style3"></p>
<form name="form2" method="post" action="">
<table width="100%" border="1" bordercolor="#FFFFFF">
<tr>
<td><span class="style3">To use this site, you need to specify some of your personal information including your email address and password to protect your account. Just fill up the form below: </span></td>
</tr>
</table>
</form>
<p align="center" class="style3"></p>
<form name="form1" method="post" action="">
<div align="center">
<table width="100%" border="0" bordercolor="#FFFFFF">
<tr>
<td width="32%"><div align="right">Student No. </div></td>
<td width="2%"></td>
<td width="66%"><div align="left">
<input name="idnum_usr" type="text" id="idnum_usr">
</div></td>
</tr>
<tr>
<td><div align="right">First Name</div></td>
<td></td>
<td><div align="left">
<input name="name_usr" type="text" id="name_usr">
</div></td>
</tr>
<tr>
<td><div align="right">Middle Name</div></td>
<td></td>
<td><div align="left">
<input name="middle_usr" type="text" id="middle_usr">
</div></td>
</tr>
<tr>
<td><div align="right">Last Name</div></td>
<td></td>
<td><div align="left">
<input name="lastname_usr" type="text" id="lastname_usr">
</div></td>
</tr>
<tr>
<td><div align="right">Gender</div></td>
<td>
</td>
<td><div align="left">
<select name="select" size="1">
<option value="F">Female</option>
<option value="M" selected>Male</option>
<option>Bading</option>
<option>Tomboy</option>
</select>
</div></td>
</tr>
<tr>
<td><div align="right">Email Address</div></td>
<td></td>
<td><div align="left">
<input name="email_usr" type="text" id="email_usr">
</div></td>
</tr>
<tr>
<td><div align="right">Password</div></td>
<td></td>
<td><div align="left">
<input name="password_usr" type="password" id="password_usr">
</div></td>
</tr>
</table>
<input type="reset" name="Reset" value="Reset">
<input type="submit" name="Submit" value="Submit">
<p align="center"></p>
<p align="center">
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="441" height="64">
<param name="movie" value="text11.swf">
<param name="quality" value="high">
<param name="BGCOLOR" value="#FFCC99">
<embed src="text11.swf" width="441" height="64" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" bgcolor="#FFCC99" ></embed>
</object>
</p>
</div>
</form>
</div>
</body>
</html>

marc0627
02-14-2006, 01:32 AM
how can i connect my database to my php???

davidj
02-14-2006, 09:02 AM
CI

didnt you do a VTM on this ?

Creative Insanity
02-14-2006, 05:03 PM
Yeah I did CJ.. a basic database.
Marc, watch this. (http://www.webthings.org/vtm/dwc/database/)

marc0627
02-14-2006, 11:35 PM
i already watched it and it help a lot thank you for that what i can't do right is when i finish with that i connected my login (which of course come from your VTM ) :P but when i created my registry i don't know what are the commands for my php to accept the data i inserted in the field.... do you have a vtm on how to accept the inputed data on the field to my data base??? it is connected to my log in and i can't log in successfully because of that... thanks hope to hear from you soon

davidj
02-15-2006, 08:47 AM
you need to follow the Dreamweaver tutorials on INSERT, UPDATE, DELETE recordsets

Creative Insanity
02-15-2006, 09:24 AM
Maybe a VTM is needed for this.
What you think DJ?

davidj
02-15-2006, 09:37 AM
go for it my ninja friend

marc0627
02-15-2006, 11:19 PM
i guess so i know it will help me alot for doing that CI and DJ thanks for the support.. hope to see that VTM thanks

Creative Insanity
02-15-2006, 11:49 PM
doing that soon marc.

marc0627
02-16-2006, 02:34 AM
thank you so much CI i am looking forward to that but for now i have only a day to work it out... can you atleast give me an idea coz i need it by tonigh i will highly appriciate that... is there anyway i can just insert manually just even add 1 record just for my login form??thanks

domedia
02-16-2006, 02:50 AM
thank you so much CI i am looking forward to that but for now i have only a day to work it out... can you atleast give me an idea coz i need it by tonigh i will highly appriciate that... is there anyway i can just insert manually just even add 1 record just for my login form??thanks
If you only have one day to figure it out, you should dive into the manual asap, it's all covered there as well. That way you're not relying on others on a (really) short deadline.

marc0627
02-16-2006, 03:03 AM
i am doing it right now i am reading and at the same time trying it... but there are some part where i get lost, that's why i ask for somehelp in vtm so that i can see what's going on and where did i get lost... i know that you guys have alot of exposure than me coz i only got the dreamweaver last 2 weeks ago....sorry to bother all of you but i am doing this web site to help someone who has a deadline so i hope you all undertand thanks

Creative Insanity
02-16-2006, 06:07 AM
It will be up in about 15 minutes. Just encoding it now.
It will show adding, editing and deleteing records

marc0627
02-16-2006, 06:51 AM
thank you so much ... looking forward to see it :) :) :)

Creative Insanity
02-16-2006, 07:36 AM
here ya go (http://www.webthings.org/vtm/dwc/aid/)

marc0627
02-16-2006, 07:51 AM
THANKSSSSSSS CI YOU ARE AN ANGEL THANKS ALOT :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol: :lol:

Creative Insanity
02-16-2006, 07:58 AM
Angel??me.. I think dj might have something to say about that. LOL