[jagadish_c]

Hi all. I have started this week to learn the Drupal 7. It is very interesting. But I am not getting that how to connect to mysql database and to fetch from it. I searched for many tutorials related, but I found none of them useful. Can anybody help me with this?

[Sadin56]

There should be some type of config file that you must edit to enter the connection details for your database such as Wordpress does and phpbb

im not familiar with drupal but im guessing thats how its done?

[jagadish_c]

I want to know the exact file where the connection statements and sql query should written.

[Sadin56]

let me look into it real quick

This post has been edited by Sadin56: 14 February 2011 - 07:32 PM

[Sadin56]

jagadish_c, on 11 February 2011 - 09:49 PM, said:

I want to know the exact file where the connection statements and sql query should written.

The connection and SQL information does not need to be edited manually.

Download your version of Drupal from Drupal.org.

Then extract the downloaded files onto your server or upload them (depending if your hosting locally or online)

And if you goto the directory on your server where drupal was stored for the frist time an installation guide/setup page will appear follow all step in the guide then your site should be up and running

The connection details are entered during the setup via the installer hope that helped

[Valek]

Assuming you're talking about working with SQL within Drupal's framework for a module you're writing yourself, you should give this and this a look to get you started with module development. If you're talking about getting it to connect overall, then Sadin56 is correct. Drupal is designed that to add custom functionality, you would create a module as opposed to altering its base code yourself.

[Sadin56]

Valek, on 14 February 2011 - 08:53 PM, said:

Assuming you're talking about working with SQL within Drupal's framework for a module you're writing yourself, you should give this and this a look to get you started with module development. If you're talking about getting it to connect overall, then Sadin56 is correct. Drupal is designed that to add custom functionality, you would create a module as opposed to altering its base code yourself.

Thank you for posting this i hadnt even considered that

This post has been edited by Sadin56: 15 February 2011 - 07:01 AM

[jagadish_c]

Valek, on 14 February 2011 - 08:53 PM, said:

Assuming you're talking about working with SQL within Drupal's framework for a module you're writing yourself, you should give this and this a look to get you started with module development.

You have assumed right. As mentioned earlier that I am a beginner in Drupal and the links you gave are useful and going through it. Also learning about modules from the link you gave.

Sadin56, on 14 February 2011 - 08:00 PM, said:

jagadish_c, on 11 February 2011 - 09:49 PM, said:

I want to know the exact file where the connection statements and sql query should written.

The connection and SQL information does not need to be edited manually.

Download your version of Drupal from Drupal.org.

Then extract the downloaded files onto your server or upload them (depending if your hosting locally or online)

And if you goto the directory on your server where drupal was stored for the frist time an installation guide/setup page will appear follow all step in the guide then your site should be up and running

The connection details are entered during the setup via the installer hope that helped

Thanks for your quick reply Sadin.