Hola estoy intentando crear un libro de visitas, primero hice una base de datos de nombre guestbook cree la tabla con 4 modulos, nombre varchar 50 no null, correo varchar 50 no null, fecha int 10 no null y comentario int 11 auto increment
despues hice mi php...
con el siguiente código
<?php
$link = mysql_connect("localhost","oi000008'@'localhost"," ");
mysql_select_db("oi000008_guestbook",$link);
if($_POST['nombre']!="" && $_POST['comentario']!="")
{
$fecha = time();
$query = "INSERT INTO mensajes (nombre, correo, fecha, comentario) VALUES
('$_POST[nombre]','$_POST[correo]','$fecha','$_POST[comentario]')";
mysql_query ($query, $link) or die (mysql_error());
}
?><style type="text/css">
<!--
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
color: #CCCCCC;
}
body {
background-color: #666666;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
.Estilo1 { color: #009999;
font-size: 16px;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_nbGroup(event, grpName) { //v6.0
var i,img,nbArr,args=MM_nbGroup.arguments;
if (event == "init" && args.length > 2) {
if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new Array();
nbArr[nbArr.length] = img;
for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = args[i+1];
nbArr[nbArr.length] = img;
} }
} else if (event == "over") {
document.MM_nbOver = nbArr = new Array();
for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1] : img.MM_up);
nbArr[nbArr.length] = img;
}
} else if (event == "out" ) {
for (i=0; i < document.MM_nbOver.length; i++) {
img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn : img.MM_up; }
} else if (event == "down") {
nbArr = document[grpName];
if (nbArr)
for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up; img.MM_dn = 0; }
document[grpName] = nbArr = new Array();
for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) != null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
nbArr[nbArr.length] = img;
} }
}
//-->
</script>
<body onLoad="MM_preloadImages('menutodo_r2_c2_f3.gif',' menutodo_r2_c2_f2.gif','menutodo_r2_c2_f4.gif','me nutodo_r3_c4_f3.gif','menutodo_r3_c4_f2.gif','menu todo_r3_c4_f4.gif','menutodo_r3_c6_f3.gif','menuto do_r3_c6_f2.gif','menutodo_r3_c6_f4.gif','menutodo _r4_c8_f3.gif','menutodo_r4_c8_f2.gif','menutodo_r 4_c8_f4.gif','menutodo_r4_c10_f3.gif','menutodo_r4 _c10_f2.gif','menutodo_r4_c10_f4.gif','menuall_r2_ c2_f3.gif','menuall_r2_c2_f2.gif','menuall_r2_c2_f 4.gif','menuall_r3_c8_f3.gif','menuall_r3_c8_f2.gi f','menuall_r3_c8_f4.gif','menuall_r4_c4_f3.gif',' menuall_r4_c4_f2.gif','menuall_r4_c4_f4.gif','menu all_r4_c6_f3.gif','menuall_r4_c6_f2.gif','menuall_ r4_c6_f4.gif','menuall_r4_c10_f3.gif','menuall_r4_ c10_f2.gif','menuall_r4_c10_f4.gif')"><p> </p>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="854" height="53" align="middle">
<param name="movie" value="nataliadominguez.swf">
<param name="quality" value="high">
<embed src="nataliadominguez.swf" width="854" height="53" align="middle" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash"></embed>
</object></td>
</tr>
<tr>
<td><form method="POST" action="<?=$PHP_SELF?>">
<p align="center"><span class="Estilo1">Guestbook</span></p>
<p align="center">name /nombre:
<input type="text" name="nombre" size="20">
</p>
<p align="center">email / correo:
<input type="text" name="correo" size="20">
</p>
<p align="center"><br>
Commentes / Comentario:<br>
<textarea rows="17" name="comentario" cols="58"></textarea>
<br>
<input type="submit" value="Enviar" name="B1">
</p>
</form></td>
</tr>
<tr>
<td><table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<th scope="col"><p class="Estilo1"> </p>
<tr>
<th scope="col"><table border="0" cellpadding="0" cellspacing="0" width="800">
<!-- fwtable fwsrc="menutodo.png" fwbase="menutodo.gif" fwstyle="Dreamweaver" fwdocid = "1971961467" fwnested="0" -->
<tr>
<td><img src="spacer.gif" width="18" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="78" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="62" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="98" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="76" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="85" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="85" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="92" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="82" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="97" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="27" height="1" border="0" alt=""></td>
<td><img src="spacer.gif" width="1" height="1" border="0" alt=""></td>
</tr>
<tr>
<td colspan="11"><img name="menutodo_r1_c1" src="menutodo_r1_c1.gif" width="800" height="21" border="0" alt=""></td>
<td><img src="spacer.gif" width="1" height="21" border="0" alt=""></td>
</tr>
<tr>
<td rowspan="5"><img name="menutodo_r2_c1" src="menutodo_r2_c1.gif" width="18" height="28" border="0" alt=""></td>
<td rowspan="3"><a href="index2.htm" target="_self" onMouseOut="MM_nbGroup('out');" onMouseOver="MM_nbGroup('over','menutodo_r2_c2','m enutodo_r2_c2_f2.gif','menutodo_r2_c2_f4.gif',1);" onClick="MM_nbGroup('down','navbar1','menutodo_r2_ c2','menutodo_r2_c2_f3.gif',1);"><img name="menutodo_r2_c2" src="menutodo_r2_c2.gif" width="78" height="20" border="0" alt="inicio"></a></td>
<td colspan="9"><img name="menutodo_r2_c3" src="menutodo_r2_c3.gif" width="704" height="6" border="0" alt=""></td>
<td><img src="spacer.gif" width="1" height="6" border="0" alt=""></td>
</tr>