We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

please help!! adding comments to a blog

derrida
derrida asked
on
Medium Priority
149 Views
Last Modified: 2010-04-25
hi
i am new to php, and i try to build a blog with articles. all that is fine .
now i want to add the ability to write a cemment to an article.
i have problem to write that, and especially the sql code since i understand that it must connect to my users table, article table.
does anyone have a tutorial for that? or explain how to do that?
the problem is with the creation of the recordset and the sql query.

best regards

derrida
Comment
Watch Question

Jason C. LevineDon't talk to me.
CERTIFIED EXPERT

Commented:
Hi derrida,

You should take some time and explore the DevNet on Adobe's site.  There are some great resources there free for the taking:

http://www.adobe.com/devnet/dreamweaver/articles/php_blog1.html

Author

Commented:
hi
thanks for the answer.
actually i do use that tutorial but the use some extension from interakt. i need to do it on my own.
i want to learn the process of the php and sql.

so i will be very thankfull if you can explain it to me?

best regards

derrida
Jason C. LevineDon't talk to me.
CERTIFIED EXPERT

Commented:
I would need to know more about where exactly you are stuck.

Author

Commented:
hi Jason
i am stuck when i need to create the rsComments with the sql query.
they use the interakt extension, i need to do it alone.
but in teir files they have this qsl :
SELECT blg_comment_com.idart_com, blg_user_usr.username_usr, blg_comment_com.text_com, blg_comment_com.date_com, blg_comment_com.valid_com FROM (blg_comment_com INNER JOIN blg_user_usr ON blg_user_usr.id_usr=blg_comment_com.idusr_com) WHERE blg_comment_com.idart_com=".HTTP_GET_VARS["id_art"]." AND blg_comment_com.valid_com=1 "

so i entered this sql code to the sql section in the rsComments recordset and i get this type of error message:
mysql error: 1064
and they point out that the problem is with the last line:
WHERE blg_comment_com.idart_com=".HTTP_GET_VARS["id_art"]." AND blg_comment_com.valid_com=1 "
and actually i can read and understand most of the code, but not the HTTP part.

can you help me?

best regards

derrida

Author

Commented:
hi
this is the link to the stage i am stuck in.
http://www.adobe.com/devnet/dreamweaver/articles/php_blog4_08.html

ron
Don't talk to me.
CERTIFIED EXPERT
Commented:
I think it's just a typo...

HTTP_GET_VARS should either be $HTTP_GET_VARS or more simply $_GET

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
hi jason
thanks, it works. i had the feeling that the problem is there but i knew about $_GET but not about $HTTP_GET_VARS.

ron
Jason C. LevineDon't talk to me.
CERTIFIED EXPERT

Commented:
Hi ron,

Glad it was a simple fix.

$_GET and all of the "$_" arrays are the superglobals that were introduced in PHP 4.1 (I think it was 4.1).  However, it is possible to turn them off at the config level.  In that case, the older arrays of $HTTP_GET_VARS and $HTTP_POST_VARS are available.

Just make sure that you are using $_ or $HTTP_ consistently throughout your scripts if both work.  They are not equivalent.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.