Jump to content

gigagames

Members
  • Posts

    9
  • Joined

  • Last visited

Posts posted by gigagames

  1. Hello,

    if i look at my Website it sayes:

    Unable to connect to database [Access denied for user '...'@'localhost' (using password: YES)]

     

    if I try to login into my Database whit phpMyAdmin

    I got after the loging page to a "Serverfehler 500"

     

    Username: giga

    Server: johnny

  2. Is it right so :

     

    wget dk.heliohost.org/........php > /dev/null 2>&1 ?

     

     

    And im living in German (GMT +2) you server U.S. Pacific Time (GMT-7) = 9 Houres Different

     

    I want the Cronjob entering the page at 12and 24a clock (my time)

    i set it to :

    9,21 >; It enter the page (the secont time) at 6a clock (my time)

    So i set it to :

    9,12 > and it have enter the pag at 21 a clock (my time)

     

    And at Johnny the PhpyMyAdmin is buggy,

    if i enter ma username + Passwort it bringt me to a white site

    and nothing happends then i need to go 1 page back (to the loging again) and refresh then i get in

  3. $db = new mysqli('localhost', '....', '....', '....');
    $db->set_charset("UTF8")
    THEN I HAVE ADDED ONE OF THE "COMMANDS" FROM THE FIRST POST
    
    $stmt = $db->prepare(INSERT INTO ... (A,B,C) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE A = VALUES(A), C = VALUES(C), LastUpdate = NOW();
    $stmt->bind_param(iss, ......);
    $stmt->excecute();
    

    Then if i check in Mysql the Timestamp is convertet to a date, but its a wrong clock, becouse its still use the Time_zone from the server and not my thet i have set

  4. Hello,

    how can i change the Timezone from the Database (at PHP?)

    i try everything i foundet, nothing works -.-

    Here what i have tried:

    $db->options(MYSQLI_INIT_COMMAND, "SET time_zone = 'Europe/Berlin'");

    $db->options(MYSQLI_INIT_COMMAND, "SET time_zone = '+01:00'");

    $db->query("SET time_zone = 'Europe/Berlin'");

    $db->query("SET time_zone = '+01:00'");

    and whit session and global bevor time zone

     

     

    but its still using the server time why ?

×
×
  • Create New...