Treehouse | Community | Using a Prepared Statement

⚡ CYBER NOVEMBER SALE ⚡ 50% off any plan for 6 months, exclusive to new subscribers.

Join the Treehouse affiliate program and earn 25% recurring commission!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Esmee Fulcher
923 Points
Stuck on using prepare statement task 1

Posted December 5, 2023 11:17am by Esmee Fulcher

Esmee Fulcher
923 Points
1 Answer
Steve Morrisby
400 Points
What suggest form. I don't recall covering that, did I miss something?

Posted June 17, 2023 9:06pm by Steve Morrisby

Steve Morrisby
400 Points
1 Answer
Matt Nickolls
9,895 Points
Does the while loop pull two separate strings from the row and fullname fields or an array?

Posted April 3, 2021 9:47am by Matt Nickolls

Matt Nickolls
9,895 Points
1 Answer
Matt Nickolls
9,895 Points
How does this code ' $item[$row["role"]][] = $row["fullname"]' know how to allocate 'fullName' to the correct key

Posted April 3, 2021 9:42am by Matt Nickolls

Matt Nickolls
9,895 Points
1 Answer
Samir Poonawala
29,951 Points
The codes not working =.=

Posted March 17, 2021 2:23pm by Samir Poonawala

Samir Poonawala
29,951 Points
1 Answer
Matt Nickolls
9,895 Points
Would using Join rather than left outer join to add the books table result in the same dataset?

Posted March 8, 2021 7:35pm by Matt Nickolls

Matt Nickolls
9,895 Points
1 Answer
Matt Nickolls
9,895 Points
Not sure about the distinction between Join and outer join

Posted January 14, 2021 11:58am by Matt Nickolls

Matt Nickolls
9,895 Points
2 Answers
Thomas Hewitt
17,691 Points
Why link the SQL basics course when it has zero information on the clearly more advanced SQL concepts used here????

Posted May 22, 2020 11:44am by Thomas Hewitt

Thomas Hewitt
17,691 Points
1 Answer
Matt Schulze
6,311 Points
Bummer: Make sure the function is returning an array of members.

Posted May 15, 2020 2:40am by Matt Schulze

Matt Schulze
6,311 Points
1 Answer
Nicholas Dunn
9,814 Points
Assistance with last challenge in Integrating php with databases - Adding Genres to item array

Posted May 14, 2020 1:06am by Nicholas Dunn

Nicholas Dunn
9,814 Points
1 Answer
Matt Schulze
6,311 Points
In "Integrating PHP with Databases", quiz=JOINing Tables, I get the 'bummer-there is something wrong with your SQL.

Posted May 6, 2020 7:42pm by Matt Schulze

Matt Schulze
6,311 Points
1 Answer
Riki Tiilikainen
4,042 Points
Undefined index: media_id

Posted May 2, 2020 9:33pm by Riki Tiilikainen

Riki Tiilikainen
4,042 Points
0 Answers
Riki Tiilikainen
4,042 Points
Can’t get the single_item_array to work

Posted April 30, 2020 6:19am by Riki Tiilikainen

Riki Tiilikainen
4,042 Points
2 Answers
ROBERT RUBY II
10,586 Points
Syntax Error? SQL

Posted December 28, 2019 8:14pm by ROBERT RUBY II

ROBERT RUBY II
10,586 Points
1 Answer
Erin DeSpain
6,763 Points
Bad SQL or Bad Question?

Posted October 8, 2019 7:25pm by Erin DeSpain

Erin DeSpain
6,763 Points
2 Answers
Unsubscribed User
8,428 Points
Using While Loop - Error says must use while loop

Posted September 30, 2019 8:40pm by Unsubscribed User

Unsubscribed User
8,428 Points
1 Answer
Unsubscribed User
8,428 Points
I don't understand the question or JOINS

Posted September 30, 2019 6:13pm by Unsubscribed User

Unsubscribed User
8,428 Points
1 Answer
Jacob Wick
8,912 Points
doubly stumped lol

Posted July 28, 2019 9:59pm by Jacob Wick

Jacob Wick
8,912 Points
1 Answer
Jacob Wick
8,912 Points
What's wrong with my WHERE clause here?

Posted July 28, 2019 9:52pm by Jacob Wick

Jacob Wick
8,912 Points
1 Answer
Raymond Moore
Full Stack JavaScript Techdegree Student 11,174 Points
Joining Table HELP!

Posted May 22, 2019 7:09pm by Raymond Moore

Raymond Moore
Full Stack JavaScript Techdegree Student 11,174 Points
3 Answers
Michael Cook
Full Stack JavaScript Techdegree Graduate 28,975 Points
Anyone else having trouble following/grasping these videos?

Posted March 14, 2019 1:29am by Michael Cook

Michael Cook
Full Stack JavaScript Techdegree Graduate 28,975 Points
2 Answers
Siraj Khan
3,451 Points
I couldn't get my head around anything the instructor saying over here.!

Posted December 31, 2018 10:26am by Siraj Khan

Siraj Khan
3,451 Points
2 Answers
Sean Flanagan
33,237 Points
Unable to retrieve results

Posted December 13, 2018 6:31pm by Sean Flanagan

Sean Flanagan
33,237 Points
4 Answers
Mario Zampollo
11,292 Points
I should use a while loop, but I AM using it already...

Posted November 9, 2018 12:24pm by Mario Zampollo

Mario Zampollo
11,292 Points
2 Answers
Phiona Basemera
2,400 Points
The library database contains a Media table with the columns media_id, title, img, format, year and category. It also co

Posted November 6, 2018 6:35pm by Phiona Basemera

Phiona Basemera
2,400 Points
2 Answers
Robbie Thomas
31,093 Points
Functions.php on video and workspace don't match.

Posted October 6, 2018 2:49pm by Robbie Thomas

Robbie Thomas
31,093 Points
1 Answer
jlampstack
23,932 Points
Instructor doesn't highlight that is being explained

Posted September 21, 2018 4:30pm by jlampstack

jlampstack
23,932 Points
0 Answers
jlampstack
23,932 Points
SQL Injection Not Working?

Posted September 17, 2018 12:46pm by jlampstack

jlampstack
23,932 Points
1 Answer
jlampstack
23,932 Points
Would it be better to use LEFT OUTER JOIN to join Genres table?

Posted September 15, 2018 9:44pm by jlampstack

jlampstack
23,932 Points
0 Answers
Dennis Amiel Domingo
17,813 Points
Why do we need to return $item when we have that in the details.php as a redirect?

Posted September 4, 2018 10:14am by Dennis Amiel Domingo

Dennis Amiel Domingo
17,813 Points
1 Answer

Prev Page 1 of 5 Next

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.