|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Web page cannot be saved corectly
Hi I made a little script for showing some MySQL content but my IE wont save it like i should. It says Query failed on saved page. Here is some of the code
<?php require "vars.php"; require "common.php"; dbConnect(); if(!isset($start)) $start = 0; $query = "SELECT * FROM " . $dbPrefix . "_" . $komponente . " ORDER BY Proizvodjac, Model ASC LIMIT " . $start . ", 20"; $result = mysql_query($query) or die ("Query failed"); //let's get the number of rows in our result so we can use it in a for loop $numofrows = mysql_num_rows($result); ?> <?PHP echo "<TABLE class="small" WIDTH="700" BORDER="0" ALIGN="CENTER">n"; switch ($komponente) { case AV_risiveri: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>Centralna</TD><TD>Prednja</TD><TD>Zadnja</TD> <TD>Subwoofer</TD><TD>Surround</TD><TD>Ulaz</TD><TD>Tip</TD> <TD>Izlazi</TD><TD>DSP</TD></TR>n"; break; case CD_plejeri: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>Program</TD><TD>DAC</TD><TD>Digitalan izlaz</TD> <TD>Iskljuèivanje displeja</TD><TD>Daljinski upravljaè</TD> <TD>Slušalice</TD></TR>n"; break; case Dekovi: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>Fini Bias</TD><TD>Broj dekova</TD><TD>Broj glava</TD> <TD>Kalibracija</TD><TD>Dolby</TD><TD>Slušalice</TD></TR>n"; break; case DVD_plejeri: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>S-Video ulaz</TD><TD>Jog-Shuttle Dial</TD><TD>Koaksijalni izlaz</TD> <TD>DTS</TD><TD>Digitalni dekoder</TD> <TD>Scart</TD><TD>CD-R/RW Replay</TD><TD>RGB izlaz</TD><TD>Optièki izlaz</TD></TR>n"; break; case Pojacala: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>Gramofonski ulaz</TD><TD>Ulazi</TD><TD>Dek</TD><TD>Daljinski upravljaè</TD> <TD>Snaga</TD><TD>Tjuner</TD><TD>Kontrola tona</TD> <TD>Parova zvuènika</TD><TD>Slušalice</TD></TR>n"; break; case Rekorderi: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>A/D konvertor</TD><TD>D/A konvertor</TD><TD>Ulazi</TD><TD>Izlazi</TD> <TD>Format</TD><TD>Dimenzije</TD> <TD>Daljinski upravljaè</TD></TR>n"; break; case Sistemi: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>MiniDisk/CD-RW</TD><TD>CD</TD><TD>DVD</TD><TD>Dek</TD><TD>Velièina</TD> <TD>Snaga</TD> <TD>Tjuner</TD></TR>n"; break; case Tjuneri: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>Program</TD><TD>Frekventna podruèja</TD><TD>RDS</TD><TD>Daljinski upravljaè</TD> <TD>Autotuning</TD></TR>n"; break; case Zvucnici: echo "<TR bgcolor=" . $HeadColor . " class="smallwhite"><TD>Proizvoðaè</TD><TD>Model</TD> <TD>Cena</TD><TD>Biwire</TD><TD>Tip</TD><TD>Impedansa</TD><TD>Osetljivost (dB)</TD> <TD>Dimenzije</TD><TD>Snaga</TD></TR>n"; break; default: echo "Izaberi komponentu"; break; } for($i = 0; $i < $numofrows; $i++) { $row = mysql_fetch_array($result); //get a row from our result set if($i % 2) { //this means if there is a remainder echo "<TR bgcolor=" . $FirstColor . ">n"; } else { //if there isn't a remainder we will do the else echo "<TR bgcolor=" . $SecondColor . ">n"; } switch ($komponente) { case AV_risiveri: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['Centralna']."</TD><TD>". $row['Prednja']."</TD><TD>".$row['Zadnja']."</TD><TD>".$row['Subwoofer']."</TD><TD>". $row['Surround']."</TD><TD>".$row['Ulaz']."</TD><TD>". $row['Tip']."</TD><TD>".$row['Izlazi']."</TD><TD>". $row['DSP']."</TD>n"; break; case CD_plejeri: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['Program']."</TD><TD>". $row['DAC']."</TD><TD>".$row['Digitalan_izlaz']."</TD><TD>".$row['Iskljucivanje_displeja']."</TD><TD>".$row['Daljinski_upravljac']."</TD><TD>". $row['Slusalice']."</TD>n"; break; case Dekovi: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['Fini_bias']."</TD><TD>". $row['Broj_dekova']."</TD><TD>".$row['Broj_glava']."</TD><TD>".$row['Kalibracija']."</TD><TD>". $row['Dolby']."</TD><TD>". $row['Slusalice']."</TD>n"; break; case DVD_plejeri: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['S_Video']."</TD><TD>". $row['Jog']."</TD><TD>".$row['Koaksijalni_izlaz']."</TD><TD>".$row['DTS']."</TD><TD>". $row['Digitalni_dekoder']."</TD><TD>". $row['Scart']."</TD><TD>".$row['CDR_RW']."</TD><TD>".$row['RGB_Izlaz']."</TD><TD>". $row['Opticki_izlaz']."</TD>n"; break; case Pojacala: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['Gramofonski_ulaz']."</TD><TD>". $row['Ulazi']."</TD><TD>".$row['Dek']."</TD><TD>".$row['Daljinski_upravljac']."</TD><TD>". $row['Snaga']."</TD><TD>".$row['Tjuner']."</TD><TD>". $row['Kontrola_tona']."</TD><TD>". $row['Parova_zvucnika']."</TD><TD>". $row['Slusalice']."</TD>n"; break; case Rekorderi: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['AD_konvertor']."</TD><TD>". $row['DA_konvertor']."</TD><TD>".$row['Ulazi']."</TD><TD>".$row['Izlazi']."</TD><TD>". $row['Format']."</TD><TD>".$row['Dimenzije']."</TD><TD>". $row['Daljinski_upravljac']."</TD>n"; break; case Sistemi: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['MD_CDR']."</TD><TD>". $row['CD']."</TD><TD>".$row['DVD']."</TD><TD>".$row['Dek']."</TD><TD>".$row['Velicina']."</TD><TD>". $row['Snaga']."</TD><TD>". $row['Tjuner']."</TD>n"; break; case Tjuneri: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['Program']."</TD><TD>". $row['Frekventna']."</TD><TD>".$row['RDS']."</TD><TD>".$row['Daljinski_upravljac']."</TD><TD>". $row['Autotuning']."</TD>n"; break; case Zvucnici: echo "<TD>".$row['Proizvodjac']."</TD><TD>".$row['Model']."</TD><TD>". $row['Cena']."</TD><TD>".$row['Biwire']."</TD><TD>". $row['Tip']."</TD><TD>".$row['Impedansa']."</TD><TD>".$row['Osetljivost']."</TD><TD>". $row['Dimenzije']."</TD><TD>". $row['Snaga']."</TD>n"; break; } echo "</TR>n"; } echo "</TABLE>n"; $query = "SELECT count(*) as count FROM " . $dbPrefix . "_" . $komponente . ""; $result = mysql_query($query); $row = mysql_fetch_array($result); $numrows = $row['count']; echo "<TABLE WIDTH="700" BORDER="0"ALIGN="CENTER">n<TR>"; if($start > 0) { $newstart = $start - 20; echo "<TD class="small"><div align="left"><a href="" . $PHP_SELF . "?komponente=" . $komponente . "&start=$newstart"><<< Prethodna strana</a></div></TD>n"; } if($numrows > ($start + 20)) { $newstart = $start + 20; echo "<TD class="small"><div align="right"><a href="" . $PHP_SELF . "?komponente=" . $komponente . "&start=$newstart">Sledeæa strana >>></a></div></TD>n"; } include "dropdown.php"; ?> <input type="hidden" name="komponente" value="<?php echo $komponente; ?>"> <input type="hidden" name="start" value="<?php echo $start; ?>"> Does anybody knows why that happens. You can see script working on http://www.hifi.co.yu/komponente/index.php |
|
#2
|
|||
|
|||
|
RE: Web page cannot be saved corectly
/* pozdrav zemljak */
i am not shure what u mean, but it works for me. i used IE6 and Opera6 to downoload and save your page (at that link) and it all came up well. i opened it from disk to test it, and it was all there. if u want, i will test it with mozilla 1.0 (i just need to install it again ;) |
|
#3
|
|||
|
|||
|
RE: Web page cannot be saved corectly
You have something seriously wrong if you get that error. When you view the page in IE, all the PHP/MySQL will have been parsed, and you should be left with plain html/javascript/css - but no PHP/MySQL.
That is one of the functions of PHP - it is server-side, thus parsed by the server.... |
|
#4
|
|||
|
|||
|
RE: Web page cannot be saved corectly
This is the problem actualy
If you go tu http://www.hifi.co.yu/komponente/tabele.php?komponente=Zvucnici everything is OK but if you come to http://www.hifi.co.yu/komponente/tabele.php from some page when you save it is say query failed. How can I make this right??? Thanx /* pozdrav i tebi zemljace */ |
|
#5
|
|||
|
|||
|
RE: Web page cannot be saved corectly
u didin't say if this is the code of tabele.php or some other file.
i asume it is, and i think that error might be in one of the two files u include before mysql_query() function call. maybe u can post that code too (from vars.php and common.php). also, use mysql_error() function http://php.net/mysql_error to see what the acual error is! /* ;) */ |
![]() |
| Viewing: Codewalkers Forums > PHP Related > PHP Coding > Web page cannot be saved corectly |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|