Как вывести assoc массив в mysqli?

Question

[Tema Ovchinnikov]

function get_post_old($param_name_article)
	{
		global $connect;

		$stmt = mysqli_prepare($connect, "SELECT post_id, post_title FROM post WHERE post_link = ?");

		mysqli_stmt_bind_param($stmt, "s", $param_name_article);

		mysqli_execute($stmt);

		mysqli_stmt_bind_result($stmt, $post_id, $post_title);

		if(!$stmt)
		{
			echo 'Ошибка запроса!';
			exit();
		}

		while($post_old = mysqli_stmt_fetch($stmt))
		{
			$post_old['manth'] = mb_substr($post_old['post_date'], 5, 2);
			$post_old['manth'] = manth($post_old['manth']);
			$post_old['years'] = mb_substr($post_old['post_date'], 0, 4);
			$post_old['day'] = ltrim(mb_substr($post_old['post_date'], 8, 2), '0');
			$res_post_old[] = $post_old;
			
		}

		mysqli_stmt_close($stmt);

		return $res_post_old;
	}

Comments

[ThunderCat]

и? В чем проблема?

[Tema Ovchinnikov]

ThunderCat: я щас только написал свой плохо пахнущий. Сомневаюсь что это лучшее решение( Жаль что mysqli_stmt_fetch_assoc нету(

function get_post_old($param_name_article)
	{
		global $connect;

		$post_old = mysqli_prepare($connect, "SELECT post_id, post_title, post_description, post_keywords, post_author, post_date, post_image, post_content, post_link FROM post WHERE post_link = ? LIMIT 1");

		@mysqli_stmt_bind_param($post_old, "s", $param_name_article);

		if(!$post_old)
		{
			echo 'Ошибка таблицы!';
			//запись в логи
			exit();
		}

		if(!@mysqli_execute($post_old))
		{
			echo 'Ошибка запроса!';
			//запись в логи
			exit();
		}

		mysqli_stmt_bind_result($post_old, $post_id, $post_title, $post_description, $post_keywords, $post_author, $post_date, $post_image, $post_content, $post_link);

		while(mysqli_stmt_fetch($post_old))
		{

			$name_post_old = array
			(
				'post_id' => $post_id, 
				'post_title' => $post_title, 
				'post_description' => $post_description, 
				'post_keywords' => $post_keywords, 
				'post_author' => $post_author, 
				'post_date' => $post_date, 
				'post_image' => $post_image, 
				'post_content' => $post_content, 
				'post_link' => $post_link
			);

			$name_post_old['manth'] = mb_substr($name_post_old['post_date'], 5, 2);
			$name_post_old['manth'] = manth($name_post_old['manth']);
			$name_post_old['years'] = mb_substr($name_post_old['post_date'], 0, 4);
			$name_post_old['day'] = ltrim(mb_substr($name_post_old['post_date'], 8, 2), '0');

			$res_post_old[] = $name_post_old;
			
		}

		mysqli_stmt_close($post_old);

		return $res_post_old;
	}

[ThunderCat]

тут рабочий вариант, но я бы просто юзал пдо.

[Tema Ovchinnikov]

ThunderCat: я pdo конечно буду юзать спасибо огромное. Просто ради интереса написан cms на процедурном по шаблону mvc с mysql перешёл недавно) mysql -> mysqli -> pdo скоро доберусь до pdo)