Ciao a tutti,
Un codice pulito non vuol sapere di funzionare.
Qualcuno riesce a capire dove sbaglio ?
La tabella dove provo a inserire i dati:
Il form:codice:---- Table structure for table `tbl_details` -- CREATE TABLE IF NOT EXISTS `tbl_details` ( `uid` int(10) unsigned NOT NULL AUTO_INCREMENT, `userID` int(10) unsigned DEFAULT '0', `userFname` varchar(64) DEFAULT NULL, `userLname` varchar(64) DEFAULT NULL, `userEmail` varchar(128) DEFAULT NULL, `userYahoo` varchar(128) DEFAULT NULL, `userSkype` varchar(128) DEFAULT NULL, `userFb` varchar(128) DEFAULT NULL, `userDtnas` date DEFAULT NULL, `userAddress` varchar(255) DEFAULT NULL, `userPhone` varchar(128) DEFAULT NULL, `userDoc_type` tinyint(1) unsigned DEFAULT '1', `userDoc_nrserie` char(32) DEFAULT NULL, `userDoc_expire` date DEFAULT NULL, `userIban` varchar(128) DEFAULT NULL, `userProp` varchar(128) DEFAULT NULL, `userReff` varchar(128) DEFAULT NULL, `userLevel` tinyint(1) unsigned NOT NULL DEFAULT '1', `userstatus_id` tinyint(1) unsigned DEFAULT '0', PRIMARY KEY (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `tbl_details` -- INSERT INTO `tbl_details` (`uid`, `userID`, `userFname`, `userLname`, `userEmail`, `userYahoo`, `userSkype`, `userFb`, `userDtnas`, `userAddress`, `userPhone`, `userDoc_type`, `userDoc_nrserie`, `userDoc_expire`, `userIban`, `userProp`, `userReff`, `userLevel`, `userstatus_id`) VALUES (1, 1, 'Marvin', 'DeeDee', 'marvin@romirc.com', NULL, NULL, NULL, NULL, NULL, '+39328', NULL, NULL, NULL, NULL, NULL, NULL, 5, 1);
La pagina che esegue la query:codice:<FORM METHOD="post" ACTION="addpers.php"> <input type="hidden" name="userID" value="<?php echo $row['userID']; ?>"> <div class="form_row_half"> <input type="text" class="form_input" name="userFname" placeholder="Prenumele"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userLname" placeholder="Numele de familie"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userEmail" placeholder="Email"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userYahoo" placeholder="Yahoo ID"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userSkype" placeholder="Skype ID"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userFb" placeholder="www.facebook.com/"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userDtnas" placeholder="Data nașterii"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userAddress" placeholder="Adresa din buletin"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userPhone" placeholder="Număr de telefon"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userDoc_type" placeholder="Tipul de document"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userDoc_nrserie" placeholder="Seria documentului"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userDoc_expire" placeholder="Data expirării"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userIban" placeholder="IBAN pentru plată"/> </div> <div class="form_row_half"> <input type="text" class="form_input" name="userIban" placeholder="Proprietarul contului"/> </div> <input type="hidden" name="userReff" value="<?php echo $row['userID']; ?>"> <input type="hidden" name="userLevel" value="1"> <input type="hidden" name="userstatus_id" value="0"> <input type="submit" class="form_submit" value="Trimite" /> </FORM>
La connessione:Codice PHP:<?php include("mydb.php"); ?> <?php $query = "INSERT INTO tbl_details (userID, userFname, userLname, userEmail, userYahoo, userSkype, userFb, userDtnas, userAddress, userPhone, userDoc_type, userDoc_nrserie, userDoc_expire, userIban, userProp, userReff, userLevel, userstatus_id) VALUES ('{$_POST['userID']}', '{$_POST['userFname']}', '{$_POST['userLnamw']}', '{$_POST['userEmail']}', '{$_POST['userYahoo']}', '{$_POST['userSkype']}', '{$_POST['userFb']}', '{$_POST['userDtnas']}', '{$_POST['userAddress']}', '{$_POST['userPhone']}', '{$_POST['userDoc_type']}', '{$_POST['userDoc_nrserie']}', '{$_POST['userDoc_expire']}', '{$_POST['userIban']}', '{$_POST['userProp']}', '{$_POST['userReff']}', '{$_POST['userLevel']}', '{$_POST['userstatus_id']}')";
if (mysql_query ($query,$connessione)) echo ("Datele au fost salvate cu succes !<br /> <br />Pentru aprobare va trebui să adaugi și <a href='gallery.php?page=acte'>actele acestei persoane</a> <br /><br /><br />"); else echo ("Errore nell'inserimento !"); ?>
Codice PHP:<?php $host = "localhost"; $db_name = "admin_xxxx"; $username = "admin_xxxx"; $password = "nchxxxxx";// connessione tramite mysql_connect()$connessione = mysql_connect($host,$db_name,$username,$password);?>

Ottima scelta
Rispondi quotando