provare ad inserire dati nel database in fase d studio

**rocco.mod** · 27-11-2007, 14:33

ciao ragazzi volevo chiedervi un vostro parere , vi spiego mi sono messo a studiare il php tramite guide e quello che si trova in rete adesso ho provato a fare la connessione al databas e li mi va senza problemi poi mi sono messo ad inserire i dati due semplici dati tipo nome e cognome pero non riesco ad inserli nel database secondo voi cosa sbaglio?

Codice PHP:




$db_host='localhost';

$db_user ='root';

$db_pass ='maurizio';

$db_name ='pippo';





$connection =  mysql_connect($db_host,$db_user,$db_pass);

if(!$connection){

    die("errore nella connessione".mysql_error());

    

}$connection_db= mysql_select_db($db_name,$connection);

    if(!$connection_db){

        die('errore nella connessione al database'.mysql_error());

}    

###################################################################################    

###################################################################################

                   /*FORM */                                                     ##

echo "<form name='' action='x.php' metod ='POST' >";                             ##

echo"<table>                                                                  

<tr><td></td><td><input type ='text'name='name' id='name'><td></td><td></td></tr>

<tr><td></td><td><input type ='text'name='cognome' id='cognome'></td>

<td><input type='submit'name='' value ='prova'</td></tr></table>

</form>";                                                                        ##

###################################################################################

###################################################################################





$name = $_POST['name'];

$cognome = $_POST['cognome'];







if(get_magic_quotes_gpc());

{

$name= stripslashes($name);

$cognome = stripcslashes($cognome);

}

$name = mysql_real_escape_string($name);

$cognome = mysql_real_escape_string($cognome);







$sql_insert = "INSERT INTO prova (name,cognome) VALUES ('$name','$cognome')"; 



$result=mysql_query($sql_insert);

if(!$sql_insert){

    die ("errore nell inserimento dei dati".mysql_error());

}



mysql_close($connection);

il files l ho chiamato x.php nel form ho messo l action x.php comunque il database si popola con gli id ma non scrive niente
ciao attendo vostre notizie

**rocco.mod** · 27-11-2007, 14:46

scusate sono dinuovo io volevo farvi un altra domanda secondo voi e corretto creare il layut di un sito in php cosi?

IL W3C VALIDATOR MI DA UN CASINO DI ERRORI TUTTI GLI ECHO

Codice PHP:


<?php

include_once ("user/check1.php");

include_once ("includes/include.php");

include_once ("user/config.php");

$ip = $_SERVER['REMOTE_ADDR'];

$date = date('Y-m-d H:i:s');



?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

<html>

<head>

<title>Rcwebagency</title>

<script type="text/javascript" src="script-javascript/mainnavigation.js"></script>

<script type="text/javascript" src="script-javascript/flashobject.js"></script>

<SCRIPT TYPE="text/javascript" SRC="script-javascript/content.js"></SCRIPT>

<script src="script-javascript/AC_RunActiveContent.js" type="text/javascript"></script>

<script type="text/javascript">

_uacct = "UA-312115-1";

</script>

<script type="text/JavaScript" src="popup.js"> </script>

<script type="text/JavaScript">

<!--

document.oncontextmenu = nocontextmenu; 

document.onmousedown = norightclick; 

if (window.Event) 

  document.captureEvents(Event.MOUSEUP); 



function norightclick(e) 

{ if (window.Event) 

  { if (e.which == 2 || e.which == 3) 

    { return false; } 

  } 

  else 

  { if (event.button == 2 || event.button == 3) 

    { event.cancelBubble = true 

      event.returnValue = false; 

      return false; 

    } 

  } 

} 

function nocontextmenu() 

{ event.cancelBubble = true 

  event.returnValue = false; 

  return false; 

} 

//-->

</script>

<!--[if IE]>



        <script type="text/javascript">

        document.body.onselectstart=function(){

            return false

        }

        </script>

        <![endif]-->

<script type="text/javascript">

<!--

self.moveTo(0,0); 

self.resizeTo(screen.availWidth,screen.availHeight);

//-->

</script>

        

<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">

<meta name="generator" content="HAPedit 3.0">



<link href="stil-css/marikweb.css" rel="stylesheet" type="text/css">



</head>



<body>

<?php

echo"<div id =\"contenitore\">\n";/*apertura del LAYUT DOVE ANDRANNO TUTTI I CONTENUTI*/

 echo"<div id =\"navigazione\">\n";

  echo" <div id=\"flashcontent\">\n";

     echo"<div id=\"banner\">

              

            

</p>

            

Welcome to RcwebAgency .


              We have detected that you do not have the Flash 6 player installed.


              Please [url='http:/www.adobe.com/go/getflashplayer/']Click Here[/url]

              to download the Flash plugin.</p>

              

            <p  class='style1'>[url='http://www.adobe.com/go/getflashplayer'][img]immagini/player.gif[/img][/url] 

        </div>\n"; 

?>        

          <script type="text/javascript">/*FLASH BANNER*/

              // <![CDATA[

            var fo = new FlashObject("flash/banner.swf", "banner", "990", "230", "false", "");

            fo.addParam("quality", "high");

            fo.addParam("menu", "false");

            fo.write("banner");

                // ]]>

        </script>

<?php    

    echo"</div>  

    <div id='menu'>\n";

?>

<script type="text/javascript">   /*FLASH MENU*/

              // <![CDATA[

            var fo = new FlashObject("flash/menu.swf", "menu", "990", "120", "false", "");

            fo.addParam("quality", "high");

            fo.addParam("menu", "false");

            fo.write("menu");

                // ]]>

        </script>

<?php        

  echo"</div>" ;

echo" </div>"; 

echo"<div id='contenutoprimo'>\n";                     /*APERTURA CONTENUTO PRIMO*/

echo"<div id ='primoblocco'> </div>\n";               /*APERTURA PRIMO BLOCCO  CHE ANDRA IL LATO SINISTRO*/





echo"<div id ='secondoblocco'>\n";

#########################################################################

          /*  INIZIO WHOIS  */                                        ###

                                                                      ###

#########################################################################

echo"<div id='sfondowhois'>";/*QUI INIZIA LO  SFONDO DEL WHOIS */

echo"<div class='titolidue'>Verifica la disponibilità del Dominio!</div>\n
";



echo"<div id ='whois'>\n";/*APERTURA DEL FORM WHOIS*/

echo"<form name='whois' action='' method='post'border='0'>

<table  align ='center' ><tr>

<td>[b][url]www.[/url][/b]</td>

<td><input type='text' name='domain' id=''></td>

<td>

   <select name='tld' class='home_input' id='tld'>

              <option value='com'>.com</option>

              <option value='it' selected>.it</option>

              <option value='eu'>.eu</option>

              <option value='net'>.net</option>

              <option value='org'>.org</option>

              <option value='biz'>.biz</option>

              <option value='info'>.info</option>

              <option value='co.uk'>.co.uk</option>

              <option value='cc'>.cc</option>

              <option value='org.uk'>.org.uk</option>

              <option value='us'>.us</option>

              <option value='name'>.name</option>

              <option value='tv'>.tv</option>

    </select></td>

   <td><input type='submit' class ='button' name ='Verifica' value='Verifica'></td></tr></table>

 </form>";                                                    

echo "</div>";  /*CHIUSURA DEL FORM WHOIS*/

echo"
";

echo"</div>";/* QUI CHIUDE LO SFONDO  DEL WHOIS   */



#########################################################################

          /*  INIZIO MISSION  */                                      ###

                                                                      ###

#########################################################################



echo"<div class='titolidue'>Mission</div>";



echo "<div class ='texttmission'>





La Rcwebagency ® si occupa di servizi di comunicazione visiva, 


web design, grafica 3D, internet marketing,


realizzazione siti web, e-commerce, sviluppo portali internet e


grafica pubblicitaria coordinata in grado di migliorare 


l'interattività e le relazioni con il Cliente




</p>

</div>";

echo"</div>\n";    /*chiusura  secondo blocco*/









echo"<div id =terzoblocco>\n";   

 echo "<div class ='corniceareapriv'>";/*APERTURA del blocco che crea la cornice a Area clienti*/                                                                         /* APERTURA terzo blocco*/

echo" <div class='titolitre'>Area clienti</div>\n";                                                             

echo"<div class ='areapriv'>";      /* APERTURA ID AREA PRIVATA*/

echo"<form name='login' action='login.php' method='post'border='0'>

<table id='login'";

 echo"<tr >

 <td></td>

 <td>";

 if($autorizzato=="1"){

echo "Bentornato $nome_utente [size="1"]<a href=logout.php>[esci][/size]</a> ";

}

else

{

echo "ciao Ospite";

}

echo"</td></tr>

<tr ><td>[b]<label>Login:</label>[/b]</td><td><input type='text' name='login' id='imputlogin'></td></tr>

<tr><td>[b]<label>Password:</label>[/b]</td><td><input type='password' name='psw' id='imputlogin'></td></tr>

<tr><td ><input type='submit' name='Accedi' value='Accedi' class='button' ></td>

<td>";

if($autorizzato=="1"){

echo "[size="1"][url=""]Pannello utente[/url][/size][url=""][/url]";

}

else

{

echo "[size="1"][url=""]Registrati ora ![/url][/size][url=""][/url]";

}

echo "</td></tr>

</table>";

echo"</div>\n";                                                                                        

echo"</div>\n";  

echo"</div>\n";  /*chiusura Area clienti*/                                                                                 

   

echo"</div>\n";                                                                                          

echo"<div id ='footer'>\n";   

                                                                    

echo"<div>Copyright © 2006-2007 By :".POWERED_BY." - All rights reserved
P.IVA:</div>\n";

echo"</div\n>";



echo"</div>\n";     /*chiusura  del LAYUT DOVE ANDRANNO TUTTI I CONTENUTI*/

?>

**rocco.mod** · 27-11-2007, 23:11

ciao ragazzi non vi dimenticate di me

mi date una mano a capire

Discussione: provare ad inserire dati nel database in fase d studio

Strumenti discussione

Ricerca discussione

Visualizza

provare ad inserire dati nel database in fase d studio

Permessi di invio