Make new users automatically follow a user in php

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Make new users automatically follow a user in php

    I am working on a php site with uses mysql as database, now my site is a social network like site where users follow each other, now if a user joins in he is following nobody so his stream remains empty so they leave the site quickly as well,i want users to be following my account account automatically when he joins in. Can you please tell me how to do it

    here are the two tables

    Code:
    Table structure for table `sn_users`
    
    
    CREATE TABLE IF NOT EXISTS `sn_users` (
    `id` int(11) NOT NULL,
    `username` varchar(225) NOT NULL,
    `email` varchar(225) NOT NULL,
    `password` varchar(225) NOT NULL,
    `name` varchar(225) DEFAULT NULL,
    `picture` varchar(100) NOT NULL,
    `cover` varchar(100) DEFAULT NULL,
    `job` varchar(225) DEFAULT NULL,
    `address` varchar(225) DEFAULT NULL,
    `date` int(11) NOT NULL,
    `reg_id` text,
    `active` int(11) NOT NULL DEFAULT '1'
    ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
    
    Table structure for table `sn_follows`
    
    
    CREATE TABLE IF NOT EXISTS `sn_follows` (
    `id` int(11) NOT NULL,
    `from` int(11) NOT NULL,
    `to` int(11) NOT NULL,
    `date` int(11) NOT NULL
    ) ENGINE=MyISAM AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;
    and the php code is

    Code:
    public function userRegister($array)
    {
    $username = $this->__GB->__DB->escape_string($array['username']);
    $email = $this->__GB->__DB->escape_string($array['email']);
    $password = md5($array['password']);
    if (strlen(trim($username)) <= 4) {
    $response = array(
    'done' => false,
    'message' => 'Username too short'
    );
    $this->__GB->prepareMessage($response);
    } else if (filter_var($email, FILTER_VALIDATE_EMAIL) === false) {
    $response = array(
    'done' => false,
    'message' => 'Invalid E-mail'
    );
    $this->__GB->prepareMessage($response);
    } else if (strlen(trim($array['password'])) <= 5) {
    $response = array(
    'done' => false,
    'message' => 'Password too short'
    );
    $this->__GB->prepareMessage($response);
    } else if ($this->UserExist($username)) {
    $response = array(
    'done' => false,
    'message' => 'Username already exists'
    );
    $this->__GB->prepareMessage($response);
    } else {
    if (isset($_FILES['image'])) {
    $imageID = $this->__GB->uploadImage($_FILES['image']);
    } else {
    $imageID = null;
    }
    $array = array(
    'username' => $username,
    'password' => $password,
    'email' => $email,
    'date' => time(),
    'picture' => $imageID
    );
    if ($this->__GB->GetConfig('emailactivation', 'users') == 1) {
    $array['active'] = 0;
    }
    $insert = $this->__GB->__DB->insert('users', $array);
    if ($insert) {
    if ($this->__GB->GetConfig('emailactivation', 'users') == 1) {
    $this->sendEmailActivation($this->__GB->__DB->lastID(), $email);
    }
    $response = array(
    'done' => true,
    'message' => 'Your account has been created'
    );
    $this->__GB->prepareMessage($response);
    } else {
    $response = array(
    'done' => false,
    'message' => 'Oops Something Went Wrong'
    );
    $this->__GB->prepareMessage($response);
    }
    }
    
    
    }
    Last edited by subzero; 13.10.15, 03:47.

  • #2
    Please remember to use forum codes [ code ] and to close [ /code ] but no space. it would be clean and clear ;)

    You can add a sql line with his/her username in sign up ... Like

    Code:
     
     $array = array( 'id' => Your_ID, 'username' => Your_Name );
    into
    sn_follows
    Last edited by subzero; 13.10.15, 03:54.

    Comment


    • #3
      can you please show me how to do it on my code?

      Comment


      • #4
        Just add your ID as default value in SQL table...

        Comment

        Working...
        X