View previous topic :: View next topic |
Author |
Message |
unLog!c
Joined: 27 May 2004 Posts: 185 Location: Osijek
|
Posted: 17.04.2005 22:37 Post subject: MySQL query |
|
|
dakle ovako zanima me sljedeće:
imam jednu mysql tabelu i sada kako napravit da ja mogu obrisati neku određeni red u njoj?? |
_________________ Why dont you go out and play hide and go fuck your self like all other NORMAL kids? |
|
Back to top |
|
|
retro_one
Joined: 16 Sep 2003 Posts: 880 Location: DUBRAVA.
|
Posted: 17.04.2005 22:52 Post subject: |
|
|
delete from mysql_tablica where uvjet
npr: delete from users where user_id = 112; |
_________________ Just your average eccentric programmer. |
|
Back to top |
|
|
Ilija Studen
Joined: 17 Apr 2005 Posts: 27 Location: 127.0.0.1
|
Posted: 18.04.2005 02:09 Post subject: |
|
|
Jedna od dobrih navika koje sam stekao u zadnje vreme je zatvaranje imena tabela i polja izmedju `.
Code: | DELETE FROM `table` WHERE `id` = '12'; |
PS: Ne kažem da je gornji kod loš, samo da je ovo drugo dobra navika |
_________________ Blog: Web dizajn, web razvoj, programiranje, random |
|
Back to top |
|
|
unLog!c
Joined: 27 May 2004 Posts: 185 Location: Osijek
|
Posted: 18.04.2005 20:19 Post subject: |
|
|
Hmm, hvala
Nego još jedno pitanje, imam anketu i sada radim admin panel i zapeo sam na editiranju postoječe ankete dakle ovako:
Code: | $query='SELECT * FROM anketa_ime';
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$ime = $row[ime];
echo ('
<form name="form1" method="post" action="index.php?inc=edit_poll&act=salji">
<table width="350" border="0" cellspacing="0">
<tr>
<td height="21" colspan="2">Edit ankete: </td>
</tr>
<tr>
<td width="92" align="left" valign="top">Ime ankete:</td>
<td width="321"><input name="ime" type="text" class="input" id="naslov" value="'.$ime.'"></td>
</tr>
');
$iz='SELECT * FROM anketa_izbor';
$result=mysql_query($iz);
while($row = mysql_fetch_array($result)) {
$izbor = $row[izbor];
echo ('
<tr>
<td align="left" valign="top">Izbor:</td>
<td><input name="izbor" type="text" class="input" id="ikona" value="'.$izbor.'"></td>
</tr>');
}
echo('
<tr>
<td><input type="submit" class="input" name="Submit" value="Uredi"></td>
</tr>
</table>
</form>');
}
}
|
to mi ispisuje u txt boxove podatke i sad kad ja kliknem na submit button, kako napraviti da mi on svaki ispisani red ovdje ispiše u pravi red u tabeli, ja sam za sada napravio ovo:
Code: | $ime=$_POST['ime'];
$izbor=$_POST['izbor'];
mysql_query("UPDATE anketa_ime SET ime='$ime'",$veza) or die('nece promjeniti ime');
mysql_query("UPDATE anketa_izbor SET izbor='$izbor'",$veza) or die('nece promjeniti izbor'); |
Ali to mi ispiše u sve redove ono što je bilo u zadnjem txt boxu, tabela ima 'izbor' i 'rezultat', vjerojatno ste me skužili, zato vas molim za pomoć!!
I još nešto kako ograničim da mi se prikaže samo 20 znakova iz varijable?? |
_________________ Why dont you go out and play hide and go fuck your self like all other NORMAL kids? |
|
Back to top |
|
|
che.UP mi3.crew
Joined: 07 Sep 2003 Posts: 2320 Location: zagreb
|
Posted: 18.04.2005 21:10 Post subject: |
|
|
Quote: | Code: | mysql_query("UPDATE anketa_ime SET ime='$ime'",$veza) |
Ali to mi ispiše u sve redove ono što je bilo u zadnjem txt boxu, tabela ima 'izbor' i 'rezultat', vjerojatno ste me skužili, zato vas molim za pomoć!! |
tako je, zato sto si rekao da tako napravi.
kako ti izgleda tablica anketa_ime? za ovakve stvari potrebno je imati nekakav ID u bazi koji ce biti jedinstven za svaku anketu.
znaci ako mijenjas anketu sa id-em 2 query bi ti trebao izgledati
Code: | UPDATE anketa_ime SET ime='$ime' WHERE anketa_id = '1' |
ista stvar vrijedi i za odgovore...
Quote: | I još nešto kako ograničim da mi se prikaže samo 20 znakova iz varijable?? |
prouci funkciju substr |
_________________ UP | TypeTester | Accommodations App
Meni u Firefox-u ne radi AJAX |
|
Back to top |
|
|
unLog!c
Joined: 27 May 2004 Posts: 185 Location: Osijek
|
Posted: 18.04.2005 21:11 Post subject: |
|
|
Ok, thx, morat ću tabelu anketa_izbor malo izmjeniti jos posla |
_________________ Why dont you go out and play hide and go fuck your self like all other NORMAL kids? |
|
Back to top |
|
|
unLog!c
Joined: 27 May 2004 Posts: 185 Location: Osijek
|
Posted: 18.04.2005 22:10 Post subject: |
|
|
Hmmm, evo sredio sam tabelu, ali imam još jedan problem
Code: | $act = $_GET['act'];
if ($act != 'salji'){
$veza=mysql_connect($server, $db_user, $db_pass) or die ("Nemoze se spojit");
mysql_select_db($baza, $veza) or die('nece na bazu');
$query='SELECT * FROM anketa_ime';
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$ime = $row[ime];
echo ('
<form name="form1" method="post" action="index.php?inc=edit_poll&act=salji">
<table width="350" border="0" cellspacing="0">
<tr>
<td height="21" colspan="2">Edit ankete: </td>
</tr>
<tr>
<td width="92" align="left" valign="top">Ime ankete:</td>
<td width="321"><input name="ime" type="text" class="input" id="naslov" value="'.$ime.'"></td>
</tr>
');
$iz='SELECT * FROM anketa_izbor';
$result=mysql_query($iz);
while($row = mysql_fetch_array($result)) {
$ID = $row[ID];
$izbor = $row[izbor];
echo ('
<tr>
<td align="left" valign="top">Izbor:</td>
<td><input name="izbor" type="text" class="input" id="ikona" value="'.$izbor.'"></td>
</tr>');
}
echo('
<tr>
<td><input type="submit" class="input" name="Submit" value="Uredi"></td>
</tr>
</table>
</form>');
}
}
else {
$ime=$_POST['ime'];
$izbor=$_POST['izbor'];
mysql_query("UPDATE anketa_ime SET ime='$ime'",$veza) or die('nece promjeniti ime');
mysql_query("UPDATE anketa_izbor SET izbor='$izbor'",$veza) or die('nece promjeniti izbor');
} |
Ovo je cjeli Edit file (bez sessiona) i sada neznam kako da napravim da mi mjenja te mutave izbore ajde molim te daj mi ideje kako da to sredim.... |
_________________ Why dont you go out and play hide and go fuck your self like all other NORMAL kids? |
|
Back to top |
|
|
che.UP mi3.crew
Joined: 07 Sep 2003 Posts: 2320 Location: zagreb
|
Posted: 18.04.2005 22:17 Post subject: |
|
|
Code: | UPDATE anketa_izbor SET izbor='$izbor' WHERE ID = '$_POST[ID]' |
al moras nekako proslijedit ID vrijednost... najjednostavnije ti je za sad dodat u formu... Code: | <input type="hidden" name="ID" value="'.$ID.'" /> |
|
_________________ UP | TypeTester | Accommodations App
Meni u Firefox-u ne radi AJAX |
|
Back to top |
|
|
unLog!c
Joined: 27 May 2004 Posts: 185 Location: Osijek
|
Posted: 19.04.2005 10:26 Post subject: |
|
|
Ne, neradi sada promjeni samo zadnji |
_________________ Why dont you go out and play hide and go fuck your self like all other NORMAL kids? |
|
Back to top |
|
|
unLog!c
Joined: 27 May 2004 Posts: 185 Location: Osijek
|
Posted: 19.04.2005 11:28 Post subject: |
|
|
Evo riješio sam :
Code: | $act = $_GET['act'];
if ($act == 'anketa'){
$veza=mysql_connect($server, $db_user, $db_pass) or die ("Nemoze se spojit");
mysql_select_db($baza, $veza) or die('nece na bazu');
$query='SELECT * FROM anketa_ime';
$result=mysql_query($query);
while($row = mysql_fetch_array($result)) {
$ime = $row[ime];
echo ('
<form name="form1" method="post" action="index.php?inc=edit_poll&act=ime">
<table width="350" border="0" cellspacing="0">
<tr>
<td width="92" align="left" valign="top">Ime ankete:</td>
<td width="321"><input name="ime" type="text" class="input" id="naslov" value="'.$ime.'"></td>
<td><input type="submit" class="input" name="Submit" value="Uredi ime"></td>
</tr>
</table>
</form>');
}
}else if ($act == 'ime') {
$ime=$_POST['ime'];
mysql_query("UPDATE anketa_ime SET ime='$ime'",$veza) or die('nece promjeniti ime');
$ID_br = 0;
$ID_br = $ID_br + 1;
$iz2='SELECT * FROM anketa_izbor WHERE ID ='.$ID_br;
$result=mysql_query($iz2);
while($row = mysql_fetch_array($result)) {
$ID = $row[ID];
$izbor1 = $row[izbor];
echo ('
<form name="form1" method="post" action="index.php?inc=edit_poll&act=izbor">
<table width="350" border="0" cellspacing="0">
<tr>
<td align="left" valign="top">Izbor:</td>
<td><input name="izbor" type="text" class="input" id="ikona" value="'.$izbor1.'"></td>
<input type="hidden" class="input" name="ID" value="'.$ID.'">
<td><input type="submit" class="input" name="Submit" value="Uredi izbor"></td>
</tr>
</table>
</form>');
}
}else if ($act == 'izbor'){
$izbor=$_POST['izbor'];
$ID=$_POST['ID'];
mysql_query("UPDATE anketa_izbor SET izbor='$izbor' WHERE ID = '$ID'",$veza) or die('nece promjeniti izbor');
$ID = $ID + 1;
$iz3='SELECT * FROM anketa_izbor WHERE ID ='.$ID;
$result=mysql_query($iz3);
while($row = mysql_fetch_array($result)) {
$ID = $row[ID];
$izbor1 = $row[izbor];
echo ('
<form name="form1" method="post" action="index.php?inc=edit_poll&act=izbor">
<table width="350" border="0" cellspacing="0">
<tr>
<td align="left" valign="top">Izbor:</td>
<td><input name="izbor" type="text" class="input" id="ikona" value="'.$izbor1.'"></td>
<input type="hidden" class="input" name="ID" value="'.$ID.'">
<td><input type="submit" class="input" name="Submit" value="Izbor"></td>
</tr>
</table>
</form>');
}
} |
|
_________________ Why dont you go out and play hide and go fuck your self like all other NORMAL kids? |
|
Back to top |
|
|
|