Advertisement
Guest User

Untitled

a guest
Jun 3rd, 2017
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.17 KB | None | 0 0
  1. <?php
  2. $mysql_host = ;
  3. $mysql_user = ;
  4. $mysql_password = ;
  5. $mysql_db = ;
  6. $mit = $_GET["select"]; // SELECT $mit FROM
  7. $honnan = $_GET["from"]; // FROM $honnan WHERE
  8. $mi = $_GET["where"]; // WHERE $mi =
  9. $mivel = $_GET["value"]; // WHERE $mi = $mivel
  10. $link = mysql_connect($mysql_host, $mysql_user, $mysql_password);
  11. if (!$link) {
  12.     die("<font  size='5' color='red'>"."Hiba a mysql kapcsolatban:      ". "</font>".mysql_error());
  13. }
  14. if (!mysql_select_db($mysql_db)) {
  15.     die("<font  size='5' color='red'>"."Hiba az adatbázisnévben:      ". "</font>". mysql_error());
  16. }
  17. $result = mysql_query("SELECT ".$mit." FROM ".$honnan." WHERE ".$mi." = ".$mivel);
  18. if (!$result) {
  19.     die("<font  size='5' color='red'>"."Hiba a queryben:        ". "</font>".mysql_error());
  20. }
  21. $mysql_result = mysql_result($result, 0);
  22. $num_rows = mysql_num_rows($result);
  23. print("<b>A query [ </b>"."<font  size='3' color='green'>"."SELECT ".$mit." FROM ".$honnan." WHERE ".$mi." = ".$mivel."</font>"." <b>] eredménye:</b> [ "."<font  size='3' color='green'>".$mysql_result."</font>"." ]<BR>"."<b>Rows: [ </b>"."<font  size='3' color='green'>".$num_rows."</font> <b>]</b><br><br><br>");
  24.  
  25. mysql_close($link);
  26. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement