title: MYSQL Different timezone in shared hosting
body: <p>i have a problem with mysql timezone.
  Mysql timezone is +0:00
  and i need to set the timezone to +7:00</p>
  
  <p>here is my code</p>
  
  <pre><code>function db_connect(){
          global $dbhost,$dbuser,$dbpassword,$dbname;
          $link_id = mysql_connect($dbhost,$dbuser,$dbpassword);
          mysql_select_db($dbname);
          if (!$link_id){
              $MYSQL_ERRNO = 0;
              $MYSQL_ERROR = "Connection failed to the host $dbhost";
              return 0;
          }
          else if(!mysql_select_db($dbname)){
              $MYSQL_ERRNO = mysql_errno();
              $MYSQL_ERROR = MYSQL_ERROR();
              return 0;
          }
          else{
              mysql_query("SET SESSION time_zone = '+7:00'");
              return $link_id;
          }
      }
  </code></pre>
  
  <p>i have set the timezone every connect to the database.
  But when i want to insert data, the timezone was go back to +0:00
  someone please help me.
  Thank you very much</p>