Guest User

Untitled

a guest
Nov 26th, 2018
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. <?php
  2. $database_server = 'localhost';
  3. $database_user = 'юзер';
  4. $database_password = 'пасс';
  5. $dbase = 'база';
  6. $dbh = mysql_connect($database_server, $database_user, $database_password) or die("MySql connect error.");
  7. mysql_select_db($dbase) or die("DB connect error.");
  8. function products(){
  9. $query = "SELECT
  10. `modx_site_content`.id as idd,
  11. `modx_site_content`.pagetitle as title,
  12. `modx_site_content`.alias as alias,
  13. `modx_site_content`.content as cont,
  14. (SELECT value FROM `modx_site_tmplvar_contentvalues` where contentid=idd and tmplvarid='72') as image
  15. FROM `modx_site_content`
  16. WHERE content like '%слово%' and parent='226'";
  17. $res = mysql_query($query);
  18. while($row = mysql_fetch_array($res)){
  19. echo $row['title'];
  20. }
  21. return '1';
  22. }
  23. echo products();
  24. ?>
Add Comment
Please, Sign In to add comment