Welcome Guest, Not a member yet? Register   Sign In
Need help for an rookie
#1
Heart 

Hello,

Sorry for my English.
With this function , I retrieves the number of identical record in the " from_user_id " the table "user- love" .

num_rows() displays the number of recording

I want to insert a new tabe "score" value " from_user_id " and the result given by " num_row " that two field  " from_user_id " and " nb_kiff

but I can not seem to find the right combination .
Is a charming young man can help me to complete this function ?

thank you in advance



Here is my Model
Code:
function count_add_kiff($add_kiff) {

$query = $this->db->select("from_user_id");
$query = $this->db->from("user_love");
$query = $this->db->like("from_user_id", $add_kiff);
$query = $this->db->get();
return $query->num_rows();


Here is my Controleur

Code:
$add_kiff = $this->news_model->count_add_kiff($this->session->userdata("user_id"));
                $data["ajout_kiff"] = $add_kiff;
Reply
#2

LaPouleLustucru thank you very much , it's perfect! you allowed me to make good progress .

I forgot to mention in my first post but I want to add a condition.

I hope that if the value of $user_id exists in " from_user_id " , the value of $nb_kiff will be updated in "nb_kiff" , otherwise insert .

I tried different methods but I can not write my code correctly .

If I try : if $ user_id > 0 , it does not. Can you help me to complete my code please .

Here's what I try to do :

PHP Code:
public function count_add_kiff($user_id
   
    $this
->db->where('from_user_id'$user_id);
 
   $this->db->from('user_love');
 
   
    
if ($user_id 0) {//*Vérify if exist
 
   
    $nb_kiff 
$this->db->count_all_results();  
    
    $data 
= array( 
 
       'from_user_id' => $user_id,
 
       'nb_kiff' => $nb_kiff
    
);
 
   $this->db->update('score'$data);
 
           
    return $nb_kiff
;
    }
    else
    {
        
$nb_kiff $this->db->count_all_results();
 
   
    $data 
= array( 
 
       'from_user_id' => $user_id,
 
       'nb_kiff' => $nb_kiff
    
);
 
   $this->db->insert('score'$data);
 
           
    return $nb_kiff
;



Thank you in advance

Violette
Reply
#3

ok .... but now I have a white page.

I think its just the " controllers " . Before I had this!

PHP Code:
$add_kiff $this->news_model->count_add_kiff($this->session->userdata("user_id"));
$data["ajout_kiff"] = $add_kiff


and my "View" , I have that!

Quote:
PHP Code:
<?php echo $ajout_kiff?>


How do I do now ? I am lost here!
Reply
#4

LaPouleLustucru you are fantastic ...

I thank you all heart ... it is ! Perfect !

Thank you for your valuable help ....

I close the subject.

Thank you again ! and thanks to this Forum
Reply




Theme © iAndrew 2016 - Forum software by © MyBB