[Chugalug] Newbie question

Randy Yates lpcustom at gmail.com
Sun Aug 18 21:59:20 UTC 2013


That's not an array. You are fetching objects.


On Sun, Aug 18, 2013 at 5:51 PM, Tyler Mittan <flashbatmanquestion at gmail.com
> wrote:

> Thanks, Randy. I am just trying to get the hang of php and mysql. When I
> get a better handle on it, I will really challenge myself. Clearly, though,
> I don't have that great of a grip on it yet, but I am working on it! I made
> sure that E_ALL is set, and I made it display errors on the php.ini
>
> Do I need to create the actual array in one of the php files or will the
> fetchall function do that? Maybe that's why I am having such a hard time.
> If you need to see the code, it's pretty much the same, but I updated the
> last pastebin:
> http://pastebin.com/LUMDKejf
>
>
> On Sun, Aug 18, 2013 at 5:25 PM, Randy Yates <lpcustom at gmail.com> wrote:
>
>> If you are selected everything in the table, it should work. You can run
>> the fetchAll() without an argument and it will return an array. I'd have to
>> see your code to see why it's not working.
>>
>> You should also get in the habit of creating a user specifically for the
>> database, instead of using the root user. Throwing root at it is easy, but
>> force yourself to do the tedious stuff. Create a database user and grant it
>> privileges to just that database.
>>
>> Also check your php.ini and see what the error_reporting is set to. You
>> may want to set it to show more information so that you can debug your code
>> easier. If it's not already, set it to E_ALL
>>
>>
>> On Sun, Aug 18, 2013 at 5:18 PM, Tyler Mittan <
>> flashbatmanquestion at gmail.com> wrote:
>>
>>> I am trying to use a foreach loop, but it's not showing the entire
>>> database. Is this because I incorrectly used fetchall?
>>>  On Aug 18, 2013 4:47 PM, "Tyler Mittan" <flashbatmanquestion at gmail.com>
>>> wrote:
>>>
>>>> THANK YOU!
>>>> On Aug 18, 2013 4:43 PM, "Randy Yates" <lpcustom at gmail.com> wrote:
>>>>
>>>>> On the second problem, your connection string for PDO is incorrect.
>>>>> You are missing "dbname=" before the variable containing your database name.
>>>>>
>>>>>
>>>>> On Sun, Aug 18, 2013 at 4:21 PM, Tyler Mittan <
>>>>> flashbatmanquestion at gmail.com> wrote:
>>>>>
>>>>>> Finally got that problem fixed. Wanted to thank you guys for bearing
>>>>>> with me. The problem was just working on Android. I am not sure the
>>>>>> specific problem, but I moved over to OS X and that problem is gone. I do
>>>>>> have another issue I was wondering if somebody might be able to help. Two
>>>>>> actually:
>>>>>>
>>>>>> http://pastebin.com/cvssKyYj <--- no errors come up on this one,
>>>>>> really. The problem is that when I just try to add to the database, I am
>>>>>> getting the else statement. I guess it's just part of my coding.
>>>>>>
>>>>>> http://pastebin.com/Vw3rMBKs <-- gives me the error "*Fatal error*:
>>>>>> Call to a member function fetchAll() on a non-object in *
>>>>>> /Applications/MAMP/htdocs/inventorylist.php* on line *11" but I
>>>>>> though I was referring to everything I needed to be that was defined.
>>>>>> *
>>>>>>
>>>>>>
>>>>>> On Sat, Aug 17, 2013 at 3:32 PM, Dave Brockman <dave at brockmans.com>wrote:
>>>>>>
>>>>>>> -----BEGIN PGP SIGNED MESSAGE-----
>>>>>>> Hash: SHA1
>>>>>>>
>>>>>>> On 8/17/2013 1:45 PM, Tyler Mittan wrote:
>>>>>>> > Okay, I created it. What should I do with it now?
>>>>>>> >
>>>>>>>
>>>>>>> Execute it in a browser.  Peruse it.  These are your PHP
>>>>>>> environmental
>>>>>>> settings.  Which libraries are active, location of INI file, memory
>>>>>>> limits, all kinds of fun things.  I'm pretty sure it will answer at
>>>>>>> least one other question posted to you.
>>>>>>>
>>>>>>> Regards,
>>>>>>>
>>>>>>> dtb
>>>>>>> -----BEGIN PGP SIGNATURE-----
>>>>>>> Version: GnuPG v2.0.17 (MingW32)
>>>>>>> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
>>>>>>>
>>>>>>> iQEcBAEBAgAGBQJSD8+5AAoJEMP+wtEOVbcdfvUIAJRD7U6VyXR7nTkvNHhS8ZXs
>>>>>>> o1J/jWB9OXIqFlYXMxjXVODnt+MQTILpKtivf5k+XJNr3vWjYjlrFIXxLPAX9ZRv
>>>>>>> t73OO/EGZzQRK8I6kTjIAbZjWoc9PNBNVgzLPiZRqr5XKUoT1YiI1+sy6wk1pvPs
>>>>>>> 4PJXC9OgoyRDjqDjyNEgzr59VTmaNx3UwzzS0n6XMcNWtv1VnxoDdhg+0hApJJzs
>>>>>>> kosrnsKj22hzlVcguiF2zp19nclDwcVufK5LjFKZMrwGmoSB22hHPwOP3yLlJ4lX
>>>>>>> i2/J7KHhu+waKXgQzLd8xG44otspXynXxN8wtLWUkEfpiHCjYrvsb+PcxYZQcsg=
>>>>>>> =Qob9
>>>>>>> -----END PGP SIGNATURE-----
>>>>>>> _______________________________________________
>>>>>>> Chugalug mailing list
>>>>>>> Chugalug at chugalug.org
>>>>>>> http://chugalug.org/cgi-bin/mailman/listinfo/chugalug
>>>>>>>
>>>>>>
>>>>>>
>>>>>> _______________________________________________
>>>>>> Chugalug mailing list
>>>>>> Chugalug at chugalug.org
>>>>>> http://chugalug.org/cgi-bin/mailman/listinfo/chugalug
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Google reads my email!
>>>>>
>>>>> _______________________________________________
>>>>> Chugalug mailing list
>>>>> Chugalug at chugalug.org
>>>>> http://chugalug.org/cgi-bin/mailman/listinfo/chugalug
>>>>>
>>>>>
>>> _______________________________________________
>>> Chugalug mailing list
>>> Chugalug at chugalug.org
>>> http://chugalug.org/cgi-bin/mailman/listinfo/chugalug
>>>
>>>
>>
>>
>> --
>> Google reads my email!
>>
>> _______________________________________________
>> Chugalug mailing list
>> Chugalug at chugalug.org
>> http://chugalug.org/cgi-bin/mailman/listinfo/chugalug
>>
>>
>
> _______________________________________________
> Chugalug mailing list
> Chugalug at chugalug.org
> http://chugalug.org/cgi-bin/mailman/listinfo/chugalug
>
>


-- 
Google reads my email!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://chugalug.org/pipermail/chugalug/attachments/20130818/6bd22cb0/attachment.html>


More information about the Chugalug mailing list