Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- /* Переменные для соединения с базой данных */
- $hostname = "localhost";
- $username = "karina";
- $password = "yMaALLE9";
- $dbName = "karinavseverybody";
- /* Таблица MySQL, в которой хранятся данные */
- $userstable = "clients";
- /* создать соединение */
- mysql_connect($hostname,$username,$password) OR DIE("Не могу создать соединение ");
- mysql_set_charset("UTF8");
- /* выбрать базу данных. Если произойдет ошибка - вывести ее */
- mysql_select_db($dbName) or die(mysql_error());
- if($_GET['action'] == "RandomMessage"){
- $resGood = mysql_query("SELECT * FROM messages WHERE is_bad = 0 ORDER BY RAND() LIMIT 1");
- $resBad = mysql_query("SELECT * FROM messages WHERE is_bad = 1 ORDER BY RAND() LIMIT 1");
- $good = mysql_fetch_array($resGood);
- $bad = mysql_fetch_array($resBad);
- $result = array();
- $resAuthorGood = mysql_query("SELECT * FROM authors WHERE id = ".$good['author_id']);
- $resAuthorBad = mysql_query("SELECT * FROM authors WHERE id = ".$bad['author_id']);
- $authorGood = mysql_fetch_array($resAuthorGood);
- $authorBad = mysql_fetch_array($resAuthorBad);
- $result['GoodMessage'] = $good;
- $result['GoodMessage']['author_data'] = $authorGood;
- $result['BadMessage'] = $bad;
- $result['BadMessage']['author_data'] = $authorBad;
- echo json_encode($result, JSON_UNESCAPED_UNICODE);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement