CodeIgniter Forums

Full Version: Bookmarks
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

Hi friends ,,

How to update number of bookmarks in our table..

anybody have idea ... plz help me

El Forum

hi, please tell me how to count the book marking

El Forum

Hi - Your request is a little ambiguous for me, but maybe this will help; this assumes your database field is called 'bookmarks':

@Sawariya: (btw, is that aishwarya rai?)
$sql = "UPDATE table_name SET bookmarks = ?";
$query = $this->db->query($sql, array($number)); //will update bookmarks with $number, set table_name to whatever name your table is

$sql = "SELECT COUNT(bookmarks) AS total FROM table_name"; // 'AS total' is an alias for the total number of bookmarks
$query = $this->db->get($sql);
$row = $query->row();
$total = $row->total;

In SQL statements, it's customary to UPPERCASE SQL syntax but it's not necessary.

El Forum

thanks friends...
this way i know.. i want to updates number of bookmarks after
bookmarked a particular link.. how can its possible... Anybody can help me to do..

thanks again. for your reply