probleme...

maryus · Mesajde **maryus** » Mie Ian 12, 2005 1:55 am

Salutare! Am o problema cu un camp de multiple choice, si anume nu reusesc sa-l "introduc" in baza de date. Mai mult decat atat, in baza de date gasesc in dreptul strazii, adresa web, iar in dreptul codului postal, codul unic de identificare...
plus erori de genul Undefined index: judetul in C:\Program Files\Apache Group\Apache2\htdocs\proiect\register_new.php on line 11 - care de altfel cred ca tin de campul cu multiple choice.

folosesc PHP 4.3.10, MySQL 3.23.54, Apache 2.0.51, phpMyAdmin 2.6.0-rc1

mai jos aveti codul

<?php
// include fisierele cu functii pentru aceasta aplicatie
require_once('bookmark_fns.php');

//creeaza variabile cu nume scurte
$email=$HTTP_POST_VARS['email'];
$utilizator=$HTTP_POST_VARS['utilizator'];
$parola=$HTTP_POST_VARS['parola'];
$parola2=$HTTP_POST_VARS['parola2'];
$numele_societatii=$HTTP_POST_VARS['numele_societatii'];
$judetul=$HTTP_POST_VARS['judetul'];
$localitatea=$HTTP_POST_VARS['localitatea'];
$strada=$HTTP_POST_VARS['strada'];
$codul_postal=$HTTP_POST_VARS['cod'];
$numar_de_inmatriculare_la_registrul_comertului=$HTTP_POST_VARS['numar_de_inmatriculare_la_registrul_comertului'];
$codul_unic_de_identificare=$HTTP_POST_VARS['codul_unic_de_identificare'];
$telefon=$HTTP_POST_VARS['telefon'];
$fax=$HTTP_POST_VARS['fax'];
$mobil=$HTTP_POST_VARS['mobil'];
$web=$HTTP_POST_VARS['web'];

// incepe sesiunea de care este posibil sa fie nevoie ulterior
// o porneste acum deoarece trebuie sa fie trimisa inaintea
// oricarui preambul
session_start();

// verifica formularul completat
if (!filled_out($HTTP_POST_VARS))
{
do_html_header('Problema');
echo 'Nu ati completat corect corect formularul - va rugam sa va intoarceti'
.' si sa incercati din nou.';
do_html_footer();
exit;
}

// adresa de mail nu este valida
if (!valid_email($email))
{
do_html_header('Problema');
echo 'Aceasta nu este o adresa de e-mail valida. Va rugam sa va intoarceti '
.'si sa incercati din nou.';
do_html_footer();
exit;
}

// parolele nu sunt identice
if ($parola != $parola2)
{
do_html_heading('Problema');
echo 'Parolele pe care le-ati introdus nu sunt identice. Va rugam sa va intoarceti '
.'si sa incercati din nou.';
do_html_footer();
exit;
}

// verifica daca lungimea parolei este corecta
// numele de utilizatori pot fi trunchiate, dar parolele vor fi
// refuzate daca sunt prea lungi.
if (strlen($parola)<6 || strlen($parola) >16)
{
do_html_header('Problema');
echo 'Parola dumneavoastra trebuie sa contina intre 6 si 16 caractere.'
.'Va rugam sa va intoarceti si sa incercati din nou.';
do_html_footer();
exit;
}
// incearca sa efectueze inregistrarea
$reg_result = register($utilizator, $email, $parola, $numele_societatii, $judetul, $localitatea,
$strada, $codul_postal, $numar_de_inmatriculare_la_registrul_comertului, $codul_unic_de_identificare,
$telefon, $fax, $mobil, $web);
if ($reg_result === true)
{
// inregistreaza variabila sesiune
$HTTP_SESSION_VARS['valid_utilizator'] = $utilizator;

// ofera o legatura la pagina membrilor
do_html_header('Inregistrare reusita');
echo 'Inregistrarea dumneavoastra a reusit. Accesati pagina membrilor '
.'pentru a introduce datele dumneavoastra!';
do_html_url('member.php', 'Catre pagina membrilor');
}
else
{
// in caz contrar ofera o legatura inapoi si ii comunica
// sa mai incerce inca o data
do_html_header('Problema');
echo $reg_result;
do_html_footer();
exit;
}

// sfarsitul paginii
do_html_footer();

codul HTML:

<table bgcolor=#e0ebf5>
<tr>
<td><b>Adresa email </b></td>
<td><input type=text name=email size=30 maxlength=100></td></tr>
<tr>
<td><b>Utilizator </b><br /><b>(maxim 16 caractere)</b></td>
<td valign=top><input type=text name=utilizator
size=16 maxlength=16></td></tr>
<tr>
<td><b>Parola </b><br /><b>(intre 6 si 16 caractere)</b></td>
<td valign=top><input type=password name=parola
size=16 maxlength=16></td></tr>
<tr>
<td><b>Confirma parola</b></td>
<td><input type=password name=parola2 size=16 maxlength=16></td></tr>

<tr>
<td><b>Numele societatii </b></td>
<td><input type=text name=numele_societatii size=30 maxlength=100></td></tr>

<tr>
<td width="50%"><b>Judetul </b></td>
<td width="41%"><select name=judetul>
<option> BUCURESTI
<option> BIHOR
<option> IALOMITA
<option> MEHEDINTI
<option> CLUJ
<option> TULCEA
<option> IASI
<option> ALBA
<option> ARAD
<option> ARGES
<option> BACAU
<option> BISTRITA-NASAUD
<option> BOTOSANI
<option> BRASOV
<option> BRAILA
<option> BUZAU
<option> CARAS-SEVERIN
<option> CONSTANTA
<option> CALARASI
<option> COVASNA
<option> DIMBOVITA
<option> DOLJ
<option> GALATI
<option> GORJ
<option> HARGHITA
<option> HUNEDOARA
<option> ILFOV
<option> MARAMURES
<option> MURES
<option> NEAMT
<option> OLT
<option> PRAHOVA
<option> SATU MARE
<option> SALAJ
<option> SIBIU
<option> SUCEAVA
<option> TELEORMAN
<option> TIMIS
<option> VASLUI
<option> VILCEA
<option> VRANCEA
<option> GIURGIU
</select></td></tr>

<tr>
<td><b>Localitatea </b></td>
<td><input type=text name=localitatea size=30 maxlength=255></td></tr>

<tr>
<td><b>Strada </b></td>
<td><input type=text name=strada size=30 maxlength=255></td></tr>

<tr>
<td><b>Codul postal </b></td>
<td><input type=text name=codul postal size=12 maxlength=10></td></tr>
<tr>
<td width="50%"><b>Numar de inmatriculare la Registrul Comertului </b></td>
<td width="8%"><SELECT name="D1" size="1" class="form2">
<OPTION value="J">J</OPTION>
<OPTION value="F">F</OPTION>
</SELECT><SELECT name="D2" size="1" class="form2">
<OPTION value="01">01</OPTION>
<OPTION value="02">02</OPTION>
<OPTION value="03">03</OPTION>
<OPTION value="04">04</OPTION>
<OPTION value="05">05</OPTION>
<OPTION value="06">06</OPTION>
<OPTION value="07">07</OPTION>
<OPTION value="08">08</OPTION>
<OPTION value="09">09</OPTION>
<OPTION value="10">10</OPTION>
<OPTION value="11">11</OPTION>
<OPTION value="12">12</OPTION>
<OPTION value="13">13</OPTION>
<OPTION value="14">14</OPTION>
<OPTION value="15">15</OPTION>
<OPTION value="16">16</OPTION>
<OPTION value="17">17</OPTION>
<OPTION value="18">18</OPTION>
<OPTION value="19">19</OPTION>
<OPTION value="20">20</OPTION>
<OPTION value="21">21</OPTION>
<OPTION value="22">22</OPTION>
<OPTION value="23">23</OPTION>
<OPTION value="24">24</OPTION>
<OPTION value="25">25</OPTION>
<OPTION value="26">26</OPTION>
<OPTION value="27">27</OPTION>
<OPTION value="28">28</OPTION>
<OPTION value="29">29</OPTION>
<OPTION value="30">30</OPTION>
<OPTION value="31">31</OPTION>
<OPTION value="32">32</OPTION>
<OPTION value="33">33</OPTION>
<OPTION value="34">34</OPTION>
<OPTION value="35">35</OPTION>
<OPTION value="36">36</OPTION>
<OPTION value="37">37</OPTION>
<OPTION value="38">38</OPTION>
<OPTION value="39">39</OPTION>
<OPTION value="40">40</OPTION>
<OPTION value="41">41</OPTION>
<OPTION value="42">42</OPTION>
<OPTION value="43">43</OPTION>
<OPTION value="50">50</OPTION>
<OPTION value="51">51</OPTION>
<OPTION value="52">52</OPTION>
</SELECT><INPUT name="T1" type="text" class="form2" size="8" maxlength="8"><SELECT name="D3" size="1" class="form2">
<OPTION value="1990">1990</OPTION>
<OPTION value="1991">1991</OPTION>
<OPTION value="1992">1992</OPTION>
<OPTION value="1993">1993</OPTION>
<OPTION value="1994">1994</OPTION>
<OPTION value="1995">1995</OPTION>
<OPTION value="1996">1996</OPTION>
<OPTION value="1997">1997</OPTION>
<OPTION value="1998">1998</OPTION>
<OPTION value="1999">1999</OPTION>
<OPTION value="2000">2000</OPTION>
<OPTION value="2001">2001</OPTION>
<OPTION value="2002">2002</OPTION>
<OPTION value="2003">2003</OPTION>
<OPTION value="2004">2004</OPTION>
</SELECT></td>

<tr>
<td width="26%"><b>Codul unic de identificare</b></td>
<td width="15%">
<input name="cod" type="text" class="form2" size="9" maxlength="10"></td>

<tr>
<td><b>Telefon </b></td>
<td><input type=text name=telefon size=12 maxlength=10></td></tr>

<tr>
<td><b>Fax </b></td>
<td><input type=text name=fax size=12 maxlength=10></td></tr>

<tr>
<td><b>Mobil </b></td>
<td><input type=text name=mobil size=12 maxlength=10></td></tr>

<tr>
<td><b>Web </b></td>
<td><input type=text name=web size=12 maxlength=10></td></tr>

<tr>
<td colspan=2 align=center>
<input type=submit value="Inregistreaza"></td></tr>
</table>

Apreciez orice sugestie. Multumesc

maryus · Mesajde **maryus** » Mie Ian 12, 2005 2:02 am

am uitat baza de date
-- phpMyAdmin SQL Dump
-- version 2.6.0-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 12, 2005 at 01:58 AM
-- Server version: 3.23.54
-- PHP Version: 4.3.10
--
-- Database: `proiect`
--
CREATE DATABASE `proiect`;
USE proiect;

-- --------------------------------------------------------

--
-- Table structure for table `utilizatori`
--

CREATE TABLE `utilizatori` (
`utilizator` varchar(16) NOT NULL default '',
`parola` varchar(16) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`numele societatii` varchar(15) NOT NULL default '',
`judetul` varchar(20) NOT NULL default '',
`localitatea` varchar(255) NOT NULL default '',
`strada` varchar(255) NOT NULL default '',
`codul postal` varchar(10) NOT NULL default '',
`numar de inmatriculare la registrul comertului` varchar(14) NOT NULL default '',
`codul unic de identificare` varchar(8) NOT NULL default '',
`telefon` varchar(10) NOT NULL default '',
`fax` varchar(10) NOT NULL default '',
`mobil` varchar(10) NOT NULL default '',
`web` varchar(255) NOT NULL default '',
PRIMARY KEY (`utilizator`),
UNIQUE KEY `utilizator` (`utilizator`)
) TYPE=MyISAM;

--
-- Dumping data for table `utilizatori`
--

arond · Mesajde **arond** » Mie Ian 12, 2005 3:55 am

Si eu am o problema: urasc posturile cu 3 pagini de cod ingramadit si care asteapta vreun fraier sa le depaneze (btw, e complet inutil ce ai postat aici pentru ca ai omis codul functiei register() - in care. la prima vedere, se intampla povestea - asta e chiar bataie de joc).

Orice sugestie e binevenita.

Multumesc.

kokosanu · Mesajde **kokosanu** » Mie Ian 12, 2005 10:50 am

iti lipseste tag-ul <form> in formularul tau, altceva nici nu ma gandesc sa caut

maryus · Mesajde **maryus** » Mie Ian 12, 2005 12:22 pm

Vreau sa va multumesc pt sugestii si pentru timpul acordat. Am inclus aici tot codul functiei. Am utilizat <form> si tot acelasi rezultat. Cat despre definirea functiei register, astept sugestii. Please.

function display_registration_form()
{
?>
<form method=post action="register_new.php">
<table bgcolor=#e0ebf5>
<tr>
<td><b>Adresa email </b></td>
<td><input type=text name=email size=30 maxlength=100></td></tr>
<tr>
<td><b>Utilizator </b><br /><b>(maxim 16 caractere)</b></td>
<td valign=top><input type=text name=utilizator
size=16 maxlength=16></td></tr>
<tr>
<td><b>Parola </b><br /><b>(intre 6 si 16 caractere)</b></td>
<td valign=top><input type=password name=parola
size=16 maxlength=16></td></tr>
<tr>
<td><b>Confirma parola</b></td>
<td><input type=password name=parola2 size=16 maxlength=16></td></tr>

<tr>
<td><b>Numele societatii </b></td>
<td><input type=text name=numele_societatii size=30 maxlength=100></td></tr>

<tr>
<td width="50%"><b>Judetul </b></td>
<td width="41%"><select name=judetul>
<option> BUCURESTI
<option> BIHOR
<option> IALOMITA
<option> MEHEDINTI
<option> CLUJ
<option> TULCEA
<option> IASI
<option> ALBA
<option> ARAD
<option> ARGES
<option> BACAU
<option> BISTRITA-NASAUD
<option> BOTOSANI
<option> BRASOV
<option> BRAILA
<option> BUZAU
<option> CARAS-SEVERIN
<option> CONSTANTA
<option> CALARASI
<option> COVASNA
<option> DIMBOVITA
<option> DOLJ
<option> GALATI
<option> GORJ
<option> HARGHITA
<option> HUNEDOARA
<option> ILFOV
<option> MARAMURES
<option> MURES
<option> NEAMT
<option> OLT
<option> PRAHOVA
<option> SATU MARE
<option> SALAJ
<option> SIBIU
<option> SUCEAVA
<option> TELEORMAN
<option> TIMIS
<option> VASLUI
<option> VILCEA
<option> VRANCEA
<option> GIURGIU
</select></td></tr>

<tr>
<td><b>Localitatea </b></td>
<td><input type=text name=localitatea size=30 maxlength=255></td></tr>

<tr>
<td><b>Strada </b></td>
<td><input type=text name=strada size=30 maxlength=255></td></tr>

<tr>
<td><b>Codul postal </b></td>
<td><input type=text name=codul postal size=12 maxlength=10></td></tr>
<tr>
<td width="50%"><b>Numar de inmatriculare la Registrul Comertului </b></td>
<td width="8%"><SELECT name="D1" size="1" class="form2">
<OPTION value="J">J</OPTION>
<OPTION value="F">F</OPTION>
</SELECT><SELECT name="D2" size="1" class="form2">
<OPTION value="01">01</OPTION>
<OPTION value="02">02</OPTION>
<OPTION value="03">03</OPTION>
<OPTION value="04">04</OPTION>
<OPTION value="05">05</OPTION>
<OPTION value="06">06</OPTION>
<OPTION value="07">07</OPTION>
<OPTION value="08">08</OPTION>
<OPTION value="09">09</OPTION>
<OPTION value="10">10</OPTION>
<OPTION value="11">11</OPTION>
<OPTION value="12">12</OPTION>
<OPTION value="13">13</OPTION>
<OPTION value="14">14</OPTION>
<OPTION value="15">15</OPTION>
<OPTION value="16">16</OPTION>
<OPTION value="17">17</OPTION>
<OPTION value="18">18</OPTION>
<OPTION value="19">19</OPTION>
<OPTION value="20">20</OPTION>
<OPTION value="21">21</OPTION>
<OPTION value="22">22</OPTION>
<OPTION value="23">23</OPTION>
<OPTION value="24">24</OPTION>
<OPTION value="25">25</OPTION>
<OPTION value="26">26</OPTION>
<OPTION value="27">27</OPTION>
<OPTION value="28">28</OPTION>
<OPTION value="29">29</OPTION>
<OPTION value="30">30</OPTION>
<OPTION value="31">31</OPTION>
<OPTION value="32">32</OPTION>
<OPTION value="33">33</OPTION>
<OPTION value="34">34</OPTION>
<OPTION value="35">35</OPTION>
<OPTION value="36">36</OPTION>
<OPTION value="37">37</OPTION>
<OPTION value="38">38</OPTION>
<OPTION value="39">39</OPTION>
<OPTION value="40">40</OPTION>
<OPTION value="41">41</OPTION>
<OPTION value="42">42</OPTION>
<OPTION value="43">43</OPTION>
<OPTION value="50">50</OPTION>
<OPTION value="51">51</OPTION>
<OPTION value="52">52</OPTION>
</SELECT><INPUT name="T1" type="text" class="form2" size="8" maxlength="8"><SELECT name="D3" size="1" class="form2">
<OPTION value="1990">1990</OPTION>
<OPTION value="1991">1991</OPTION>
<OPTION value="1992">1992</OPTION>
<OPTION value="1993">1993</OPTION>
<OPTION value="1994">1994</OPTION>
<OPTION value="1995">1995</OPTION>
<OPTION value="1996">1996</OPTION>
<OPTION value="1997">1997</OPTION>
<OPTION value="1998">1998</OPTION>
<OPTION value="1999">1999</OPTION>
<OPTION value="2000">2000</OPTION>
<OPTION value="2001">2001</OPTION>
<OPTION value="2002">2002</OPTION>
<OPTION value="2003">2003</OPTION>
<OPTION value="2004">2004</OPTION>
</SELECT></td>

<tr>
<td width="26%"><b>Codul unic de identificare</b></td>
<td width="15%">
<input name="cod" type="text" class="form2" size="9" maxlength="10"></td>

<tr>
<td><b>Telefon </b></td>
<td><input type=text name=telefon size=12 maxlength=10></td></tr>

<tr>
<td><b>Fax </b></td>
<td><input type=text name=fax size=12 maxlength=10></td></tr>

<tr>
<td><b>Mobil </b></td>
<td><input type=text name=mobil size=12 maxlength=10></td></tr>

<tr>
<td><b>Web </b></td>
<td><input type=text name=web size=12 maxlength=10></td></tr>

<tr>
<td colspan=2 align=center>
<input type=submit value="Inregistreaza"></td></tr>
</table></form>

arond · Mesajde **arond** » Mie Ian 12, 2005 1:29 pm

Lasa-ne, copile

Pui o intrebare cand nu stii ceva si intrebarea sa fie la obiect. Dar sa ceri sa-ti scrie cineva codul pentru o functie asta inseamna ca il pui la munca in folosul tau, cu alte cuvinte ceva de genul: s-a intalnit hotul cu prostul.

Iti scriu eu functia si iti scot scriptul la lumina... asta probabil ca o sa-mi ia 1-2 ore, deci 2 ore, la un tarif de 25euro/ora...inseamna 50euro. Esti dispus sa platesti ? A... banuiam eu ca nu... ehhh.. asta este.

Numa' bune.

Pirahna · Mesajde **Pirahna** » Mie Ian 12, 2005 9:08 pm

macar daca o scriai cu "[code]"

probleme...

probleme...

tot eu

Revin

Cine este conectat