PHP + MYSQL, Blad dodawania rekordow Opcje

[michu9010]

witam mam wielki problem z dodawaniem rekordow do bazy po prostu ich nie dodaje
plik form.php

[HTML] pobierz, plaintext 
<form action="admin.php?phones=add&dodaj=yes" method="post">
<table width="328" border="0" cellpadding="2" cellspacing="0">
  <tr>
    <td><div align="left">Model</div></td>
    <td><input name="model" type="text" size="26" /></td>
  </tr>
  <tr>
    <td><div align="left">EMAI</div></td>
    <td><input name="emai" type="text" size="26"  /></td>
  </tr>
  <tr>
    <td height="67"><div align="left">Opis</div></td>
    <td><textarea name="opis"></textarea></td>
  </tr>
  <tr>
    <td><div align="left">Imię, Nazwisko</div></td>
    <td><input name="kto" type="text" size="26" /></td>
  </tr>
    <tr>
    <td><div align="left">Numer Telefonu</div></td>
    <td><input name="nrtel" type="text" size="26" value="+48" /></td>
  </tr>
      <tr>
    <td><div align="left">Opreracja wykonana</div></td>
    <td><input type="radio" name="stan" value="Tak<img src=images/yes.jpg />" />Tak<img src="images/yes.jpg" />
        <input type="radio" name="stan" value="Nie<img src=images/no.jpg />" checked="checked" />Nie<img src="images/no.jpg" />
</td>
  </tr>
  <tr>
    <td><div align="left">Data</div></td>
    <td><input name="data" type="text" size="26" value="<?php echo date("d.m.Y"); ?>"  /></td>
  </tr>
  <tr>
    <td><div align="left">Numer</div></td>
    <td><input name="nr"  type="text" size="26" value="<?php for ($i=0; $i<1; $i++) echo rand(0, 99).' ';?>"/>    </td>
  </tr>
  <tr>
    <td><div align="left">
      <input type="submit" name="Dodaj" value="Dodaj" />
    </div></td>
    <td><input type="reset" value="Wyczyść pola" /></td>
  </tr>
</table>
 
</form>
[HTML] pobierz, plaintext 

yes.php

[PHP] pobierz, plaintext 
<?php 
    $model = trim($_POST['model']);
    $emai = trim($_POST['emai']);
    $opis = trim($_POST['opis']);
    $kto = trim($_POST['kto']);
    $data = trim($_POST['data']);
    $nr = trim($_POST['nr']);
    $nrtel = trim($_POST['nrtel']);
    $stan = trim($_POST['stan']);
 
 
 
 
if($model and $emai) {
 
 
include 'connect.php';
 
 
 
    $ins = @mysql_query("INSERT INTO phones SET model='$model', emai='$emai', opis='$opis', kto='$kto', data='$data', nr='$nr',nrtel='$nrtel', stan='$stan'");
 
    if($ins) echo "Telefon został dodany poprawnie do bazy";
    else echo "Błąd nie udało się dodać nowego telefonu do bazy";
 
    mysql_close($connection);
}
 echo '<meta http-equiv="Refresh" content="1; url=admin.php?phones=show" />';
 
 
 ?>
[PHP] pobierz, plaintext 

i baza

[SQL] pobierz, plaintext 
CREATE TABLE `phones` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `emai` varchar(40) NOT NULL DEFAULT '',
  `model` varchar(40) NOT NULL DEFAULT '',
  `opis` varchar(200) NOT NULL DEFAULT '',
  `kto` varchar(60) NOT NULL DEFAULT '',
  `data` varchar(10) NOT NULL DEFAULT '',
  `nr` varchar(254) NOT NULL DEFAULT '',
  `nrtel` varchar(12) NOT NULL DEFAULT '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
[SQL] pobierz, plaintext 

prosze o pomoc (IMG:style_emoticons/default/party.gif)

[blooregard]

~michu9010, zamień to:

[PHP] pobierz, plaintext 
$ins = mysql_query("INSERT INTO phones (model, emai, opis, kto, data, nr, nrtel, stan) VALUES ('$model', '$emai', $opis', '$kto', '$data', '$nr', '$nrtel', '$stan');
[PHP] pobierz, plaintext 

na:

[PHP] pobierz, plaintext 
$query = "INSERT INTO phones (model, emai, opis, kto, data, nr, nrtel, stan) VALUES ('$model', '$emai', $opis', '$kto', '$data', '$nr', '$nrtel', '$stan';
echo $query;
$ins = mysql_query($query);
[PHP] pobierz, plaintext 

i pokaż, co Ci wyświetliło po tej pogrubionej linijce.

Ekhem. Chyba insert wygląda inaczej.

Mylisz się i masz rację zarazem (IMG:style_emoticons/default/smile.gif)
Paradoks, co?

http://dev.mysql.com/doc/refman/5.1/en/insert.html

12.2.5.1. INSERT ... SELECT Syntax
12.2.5.2. INSERT DELAYED Syntax
12.2.5.3. INSERT ... ON DUPLICATE KEY UPDATE Syntax
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name,...)]
{VALUES | VALUE} ({expr | DEFAULT},...),(...),...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]

Or:
INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name
SET col_name={expr | DEFAULT}, ...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]

Or:
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name,...)]
SELECT ...
[ ON DUPLICATE KEY UPDATE
col_name=expr
[, col_name=expr] ... ]

INSERT inserts new rows into an existing table. The INSERT ... VALUES and INSERT ... SET forms of the statement insert rows based on explicitly specified values. The INSERT ... SELECT form inserts rows selected from another table or tables. INSERT ... SELECT is discussed further in Section 12.2.5.1, ?INSERT ... SELECT Syntax?.

Ten post edytował blooregard 24.12.2009, 16:10:13