Fatal error call to a member function fetch on a non object in

class shoutbox {

    private $db;

    function __construct($dbname, $username, $password, $host = "localhost" ) 
    { # db conections
        try {
            $this->db = new PDO("mysql:host=".$hostname.";dbname=".$dbname, $username, $password);
        }
        catch(PDOException $e)
        {
            echo $e->getMessage();
        }
    }

    function getShouts()
    {
        $sql_shouts = $this->db->query('SELECT shoutid, message, pmuserid, ipadress, time FROM shouts WHERE pmuserid == 0');

        return $sql_shouts->fetch(PDO::FETCH_OBJ);

    }

}

0

Добавляйтесь ко мне в друзья ВКонтакте: http://vk.com/myrusakov.
Если Вы хотите дать оценку мне и моей работе, то напишите её в моей группе: http://vk.com/rusakovmy.

Если Вы не хотите пропустить новые материалы на сайте,
то Вы можете подписаться на обновления: Подписаться на обновления

<?php
    include 'config/config.php';
    return array(
        "paths" => array(
            "migrations" => "%%PHINX_CONFIG_DIR%%/migrations"
        ),
        "environments" => array(
            "default_migration_table" => "phinxlog",
            "default_database" => "development",
            // $DBH - Database Handle, created in config.php for the correct environment
            "development" => array(
                "connection" => $DBH
            ),
            "staging" => array(
                "connection" => $DBH
            ),
            "production" => array(
                "connection" => $DBH
            )
        )
    );

<?php

use PhinxMigrationAbstractMigration;

class InitialMigration extends AbstractMigration
{
    /**
     * Change Method.
     *
     * More information on this method is available here:
     * http://docs.phinx.org/en/latest/migrations.html#the-change-method
     *
     * Uncomment this method if you would like to use it.
     *
     */
    public function change()
    {
        // create the demo table
        $table = $this->table('demo');
        $table->addColumn('created', 'datetime', array('default' => 'CURRENT_TIMESTAMP'))
              ->addColumn('name', 'string', array('limit' => 20))
              ->create();
    }


    /**
     * Migrate Up.
     */
    public function up()
    {

    }

    /**
     * Migrate Down.
     */
    public function down()
    {

    }
}

Phinx by Rob Morgan - https://phinx.org. version 0.4.0

using config file ./phinx.php
using config parser php
using migration path /vagrant/migrations
using environment development
PHP Fatal error:  Call to a member function fetch() on a non-object in /vagrant/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php on line 303

Fatal error: Call to a member function fetch() on a non-object in /vagrant/vendor/robmorgan/phinx/src/Phinx/Db/Adapter/PdoAdapter.php on line 303

SELECT * FROM body WHERE `nomer_dog` LIKE «%1-13-302%» OR `adres_ob` LIKE «%1-13-302%»Array ( [0] => Array ( [id] => 143 [nomer_p_p] => 124 [rieltor] => ????????? ?.?. [nomer_dog] => 1-13-302-004 [data_dog] => 05-08-2013 [adres_ob] => ????????????, 17?-24 [fio_prod] => ????? ????????? ????????, ?????? ?????? ??????? [fio_pokup] => ???????? ?????? ?????????? [cena_ob] => 3060000 [srok_dog] => 01-09-2013 [d_sog_o_chem] => [d_sog_blank] => [d_sog_data] => [av_fl_blank] => [av_fl_data] => [av_fl_summa] => [av_fl_srok] => [av_fl_pokup] => [av_vladis_blank] => [vid_avans] => [data_polu_avans] => [period_avans] => [summa_avans] => [av_vladis_pokup] => [data_kassa] => [go_avans] => [rielt_pokup] => [pdkp_data] => [pdkp_srok] => [pdkp_av_summa] => [pdkp_zk_summa] => [uved_srok] => [uved_ok] => [dkp_data] => 15-08-2013 [dkp_c_offic] => 3060000 [dkp_c_real] => 3060000 [srok_osv] => [data_pered] => 25-08-2013 [data_avr] => [numer_avr] => [data_komis] => [arhiv] => [ras_ok] => [jurist_off] => [komiss] => 60000 [prim] => [global_data] => 08.2013 [ofis] => dobroe [color] => #57BFFD [tim_dat] => 2013-08-11 03:07:21 [ins_avtor] => ??????? ?.?. [last_autor] => ) [1] => Array ( [id] => 132 [nomer_p_p] => 114 [rieltor] => ????????? ?.?. [nomer_dog] => 1-13-302-004 [data_dog] => 05-08-2013 [adres_ob] => ????????????, ?. 17-?, ??. 24 [fio_prod] => ?????? ?????? ??????? ????? ????????? ???????? [fio_pokup] => [cena_ob] => 3060000 [srok_dog] => 01-09-2013 [d_sog_o_chem] => [d_sog_blank] => [d_sog_data] => [av_fl_blank] => [av_fl_data] => [av_fl_summa] => [av_fl_srok] => [av_fl_pokup] => [av_vladis_blank] => ?146 [vid_avans] => ?? ???????????? ??? ???????? (?? ???????) [data_polu_avans] => 05-08-2013 [period_avans] => 01-09-2013 [summa_avans] => 50000 [av_vladis_pokup] => ???????? ?????? ?????????? [data_kassa] => [go_avans] => [rielt_pokup] => [pdkp_data] => [pdkp_srok] => [pdkp_av_summa] => [pdkp_zk_summa] => [uved_srok] => [uved_ok] => [dkp_data] => [dkp_c_offic] => [dkp_c_real] => [srok_osv] => [data_pered] => [data_avr] => [numer_avr] => [data_komis] => [arhiv] => [ras_ok] => [jurist_off] => [komiss] => 60000 [prim] => [global_data] => 08.2013 [ofis] => dobroe [color] => [tim_dat] => 2013-08-05 18:08:21 [ins_avtor] => ??????? ?.?. [last_autor] => ) )