Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $database_server = 'localhost';
- $database_user = 'юзер';
- $database_password = 'пасс';
- $dbase = 'база';
- $dbh = mysql_connect($database_server, $database_user, $database_password) or die("MySql connect error.");
- mysql_select_db($dbase) or die("DB connect error.");
- function products(){
- $query = "SELECT
- `modx_site_content`.id as idd,
- `modx_site_content`.pagetitle as title,
- `modx_site_content`.alias as alias,
- `modx_site_content`.content as cont,
- (SELECT value FROM `modx_site_tmplvar_contentvalues` where contentid=idd and tmplvarid='72') as image
- FROM `modx_site_content`
- WHERE content like '%слово%' and parent='226'";
- $res = mysql_query($query);
- while($row = mysql_fetch_array($res)){
- echo $row['title'];
- }
- return '1';
- }
- echo products();
- ?>
Add Comment
Please, Sign In to add comment