• Как сделать такой запрос к Mysql?

    Don_Donald
    @Don_Donald
    Дмитрий: потому что эти родители любят больше дочь чем сына :)
  • Как в openserver добавить mysql другой версии?

    Don_Donald
    @Don_Donald Автор вопроса
    Николай: так это отдельный сервер что ли?) мне нужно чтобы она 5.7 была в openservere)
  • Как в openserver добавить mysql другой версии?

    Don_Donald
    @Don_Donald Автор вопроса
    Николай: Установить C:\openserver\modules\database\MySQL-5.7?
  • Как в openserver добавить mysql другой версии?

    Don_Donald
    @Don_Donald Автор вопроса
    Николай: Да винда 7, эту MySQL 5.7.10 скачал просто сайта и установил в папку
    C:\openserver\modules\database\MySQL-5.7, папку data создал ее не было, этот лог и есть от нее!
    А MySQL 5.7.11 скачал с оффа там она была в zip, ту удалил и скопировал туда же, и все равно таже ошибка.
    Когда я туда закидываю там .ini называется my-defualt.ini если его не сделать в my то пишет что такого нет, и папки data тоже нет вот что в скаченном ini
    # For advice on how to change settings please see
    # dev.mysql.com/doc/refman/5.7/en/server-configurati...
    # *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
    # *** default location during install, and will be replaced if you
    # *** upgrade to a newer version of MySQL.

    [mysqld]

    # Remove leading # and set to the amount of RAM for the most important data
    # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
    # innodb_buffer_pool_size = 128M

    # Remove leading # to turn on a very important data integrity option: logging
    # changes to the binary log between backups.
    # log_bin

    # These are commonly set, remove the # and set as required.
    # basedir = .....
    # datadir = .....
    # port = .....
    # server_id = .....

    # Remove leading # to set options mainly useful for reporting servers.
    # The server defaults are faster for transactions and fast SELECTs.
    # Adjust sizes as needed, experiment to find the optimal values.
    # join_buffer_size = 128M
    # sort_buffer_size = 2M
    # read_rnd_buffer_size = 2M

    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    skip-grant-tables
  • Как в openserver добавить mysql другой версии?

    Don_Donald
    @Don_Donald Автор вопроса
    Николай: 2016-03-15T18:53:57.007787Z 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
    2016-03-15T18:53:57.008787Z 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    2016-03-15T18:53:57.186798Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160315 23:53:57
    2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure
    2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure
    2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure
    2016-03-15T18:53:57.215799Z 0 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure
    2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
    2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure
    2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure
    2016-03-15T18:53:57.265802Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
    2016-03-15T18:53:57.323806Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
    2016-03-15T18:53:57.323806Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure
    2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure
    2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure
    2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure
    2016-03-15T18:53:57.324806Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
    2016-03-15T18:53:57.325806Z 0 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure
    2016-03-15T18:53:57.325806Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
    2016-03-15T18:53:57.373808Z 0 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure
    2016-03-15T18:53:57.373808Z 0 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure
    2016-03-15T18:53:57.373808Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
    2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure
    2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure
    2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
    2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure
    2016-03-15T18:53:57.374808Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
    2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
    2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
    2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure
    2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
    2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
    2016-03-15T18:53:57.375808Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
    2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
    2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
    2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
    2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
    2016-03-15T18:53:57.376809Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
    2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
    2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
    2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
    2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
    2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
    2016-03-15T18:53:57.377809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
    2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
    2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
    2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
    2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
    2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
    2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
    2016-03-15T18:53:57.378809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
    2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
    2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
    2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
    2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
    2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
    2016-03-15T18:53:57.379809Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
    2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
    2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
    2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
    2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
    2016-03-15T18:53:57.380809Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
    2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
    2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
    2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
    2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
    2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
    2016-03-15T18:53:57.381809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
    2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
    2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
    2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
    2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
    2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
    2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
    2016-03-15T18:53:57.382809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
    2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
    2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
    2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
    2016-03-15T18:53:57.383809Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
    2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
    2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
    2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
    2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
    2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
    2016-03-15T18:53:57.384809Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
    2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
    2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
    2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
    2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
    2016-03-15T18:53:57.404810Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
    2016-03-15T18:53:57.405810Z 0 [Note] c:\openserver\modules\database\MySQL-5.7\bin\mysqld.exe: ready for connections.
    Version: '5.7.10' socket: '' port: 3306 MySQL Community Server (GPL)
  • Как в openserver добавить mysql другой версии?

    Don_Donald
    @Don_Donald Автор вопроса
    Николай: вот такой лог сейчас, извините но не чего не могу понять из за чего там ошибки.
  • Статистика recaptcha?

    Don_Donald
    @Don_Donald Автор вопроса
    понял, спасибо а я думал может что то не правильно сделал!
  • Как сделать кроссбраузерно?

    Don_Donald
    @Don_Donald
    dom1n1k: Полностью с вами согласен!
  • Как в openserver добавить mysql другой версии?

    Don_Donald
    @Don_Donald Автор вопроса
    Создал, эта ошибка исчезла но появилось еще больше, отредактировал вопрос.
  • Можно ли установить 2 фильтра в одну переменную?

    Don_Donald
    @Don_Donald Автор вопроса
    Спасибо, а подскажите этот символ '|' означает разделитель или типа и?
  • Почему не срабатывает hover эффект в данной конструкции?

    Don_Donald
    @Don_Donald
    Martyer: так зачем вам два блока с ховерами, вы 2 картинку сделайте дисплей нон, а при наведении на 1 картинку дисплей блок у второй
  • Экранирование символов?

    Don_Donald
    @Don_Donald Автор вопроса
    krypt3r: Спасибо!
  • Как из одной формы передать post-данные на две страницы одновременно?

    Don_Donald
    @Don_Donald
    Я новичок в PHP!
    если insert'ом записать данные о пользователе в БД, сделать проверку если данные отправлены то header'ом перенаправлять на страницу платежной системы.
  • Экранирование символов?

    Don_Donald
    @Don_Donald Автор вопроса
    krypt3r: Подскажите вот так будет правильно?
    $sql->execute([htmlspecialchars($_POST['text'], ENT_QUOTES)]);
  • Экранирование символов?

    Don_Donald
    @Don_Donald Автор вопроса
    Игорь: ок, спасибо
  • Экранирование символов?

    Don_Donald
    @Don_Donald Автор вопроса
    символ это я просто пример привел
  • Экранирование символов?

    Don_Donald
    @Don_Donald Автор вопроса
    вот про это я и спрашиваю что будет ли безопасно так или все равно $_POST нужно экранировать?