PHP Coding
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Codewalkers ForumsPHP RelatedPHP Coding

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Codewalkers Forums Sponsor:
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  
Old September 1st, 2002, 09:39 PM
ljtruba ljtruba is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 3 ljtruba User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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

Reply With Quote
  #2  
Old September 2nd, 2002, 02:27 AM
zombie zombie is offline
Codewalkers Intermediate (1500 - 1999 posts)
 
Join Date: Apr 2007
Location: serbia
Posts: 1,876 zombie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
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 ;)

Reply With Quote
  #3  
Old September 2nd, 2002, 10:40 PM
Nimco Nimco is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 132 Nimco User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 2
Send a message via AIM to Nimco
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....

Reply With Quote
  #4  
Old September 5th, 2002, 10:06 PM
ljtruba ljtruba is offline
Codewalkers Newbie (0 - 499 posts)
 
Join Date: Apr 2007
Posts: 3 ljtruba User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
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 */

Reply With Quote
  #5  
Old September 7th, 2002, 02:11 AM
zombie zombie is offline
Codewalkers Intermediate (1500 - 1999 posts)
 
Join Date: Apr 2007
Location: serbia
Posts: 1,876 zombie User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 3
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!

/* ;) */

Reply With Quote
Reply

Viewing: Codewalkers ForumsPHP RelatedPHP Coding > Web page cannot be saved corectly


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway