1 / 6

Dynamic Website Management System in PHP

Enhance user experience with a dynamic website access system in PHP. Utilize server-side scripting for efficient loading. Improve personal home pages using PHP's hypertext preprocessor. Communicate SQL queries via ODBC for seamless interaction.

howard-walker
Download Presentation

Dynamic Website Management System in PHP

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Požiadavka URL Odpoveď HTML Klient Server CGI skripty PHP ASP Server Side JavaScript Dynamické HTML JavaScript Java-aplety Rasmus Lerdorf 1994 systém pre evidovanie prístupu k stránkam v Perle Prepísanie do jazyka C (zaťažovanie servra) Vylepšovanie (užívatelia) Personal Home Pages hypertextový preprocesor PHP

  2. Klient/prehliadač HTTP WWW server CGI SAPI Skript v PHP SQL dotazy komunikujúce pomocou rozhrania ODBC Klient/prehliadač HTTP Ovládač ODBC WWW server SQL dotazy komunikujúce pomocou natívneho protokolu CGI SAPI Ukladanie dát na disk je v rukách SQL servra SQL srver Skript v PHP SQL dotazy komunikujúce pomocou natívneho protokolu SQL dotazy komunikujúce pomocou natívneho protokolu Diskové zariadenie Front-end od výrobcu SQL servra Databázový administrátor

  3. Adabas D MySQL Sybase Informix Oracle Velocis MS SQL Server PostgreSQL mSQL Solid dBase MS Excel, MS Access (ODBC)

  4. . . . <BODY> <? $spojenie=ODBC_Connect("WEB", "sa", ""); if (!$spojenie): echo "Spojenie s DB sa nepodarilo !"; else: $sql=ODBC_Exec($spojenie, "Select Tema,Meno,Priezvisko,IDDiplomovka from Diplomovka,Student where Student.IDStudent=Diplomovka.IDStudent and Diplomovka.Rok='$Rok' and Tema LIKE '%$string%' order by Priezvisko"); ?> <HTML> . . .

  5. $spojenie=MySQL_Connect("localhost","root",""); if (!$spojenie): echo "Spojenie s DB sa nepodarilo !"; else: MySQL_Select_DB("WEB"); $sql=MySQL_Query("Select ucitel, student, diplomovka.. FROM ... WHERE ... AND zameranie='$typ' ORDER BY Ucitel.Priezvisko"); if (!$sql): echo "Doslo k chybe pri vytvarani SQLllll dotazu !"; else: while ($zaznam=MySQL_Fetch_Row($sql)): $idstudent =$zaznam[0]; $iddiplomovka =$zaznam[1]; endwhile; endif; endif; . . . $sql=MySQL_Query("Select count(IDKomisia) FROM komisie WHERE IDKomisia=$komisia"); if (!$sql): echo "Doslo k chybe pri vytvarani SQL dotazu !"; else: $count=mysql_result($sql,0,0);

More Related