Return to Snippet

Revision: 35133
at November 4, 2010 01:52 by JonnySnip3r


Updated Code
public function create_archive()
	{
		// Loop through the database grabbing all the dates::
		// $sql = "SELECT DISTINCT blog_date FROM subarc_blog ORDER BY blog_date";
		$sql = "SELECT DISTINCT MONTHNAME(blog_date) as blog_month, YEAR(blog_date) as blog_year FROM subarc_blog ORDER BY blog_date";
		
		$stmt = $this->conn->prepare($sql);
		$stmt->execute();
		$stmt->bind_result($month,$year);
		
		$rows = array();
		
		while($row = $stmt->fetch())
		{
			$item = array(
				'blog_month' => $month,
				'blog_year' => $year
			);
			$rows[] = $item;
		}
		$stmt->close();
		return $rows;
	}

Revision: 35132
at November 3, 2010 04:00 by JonnySnip3r


Initial Code
public function create_archive()
	{
		// Loop through the database grabbing all the dates::
		$sql = "SELECT blog_date FROM subarc_blog";
		
		$stmt = $this->conn->prepare($sql);
		$stmt->execute();
		$stmt->bind_result($date);
		
		$rows = array();
		
		while($row = $stmt->fetch())
		{
			$date = explode("-",$date);
			$month = date("F",mktime(0,0,0,$date['1']));
			$year = $date[0];

			$item = array(
				'blog_month' => $month,
				'blog_year' => $year
			);
			$rows[] = $item;
		}
		$stmt->close();
		return $rows;
	}

Initial URL

                                

Initial Description
This has been updated, fully working now

Initial Title
Create Archive Function

Initial Tags

                                

Initial Language
PHP