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:
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);
Il form:
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 pagina che esegue la query:
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 !"); ?>
La connessione:
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);?>