Skip to main content
1
123polis123
Known Participant
March 7, 2009
Question

<cfquery> correct cfm-mysql/phpMyAdmin ? I use goDaddy.com hosting(php/cfml/mysql)

  • March 7, 2009
  • 5 replies
  • 1594 views
<cfquery datasource="cf123" password="1234CF123"
username="cfdbK" name="getData" >

SELECT * FROM CustomersTable

</cfquery>


is it correct if CustomersTable is a table in phpMyAdmin ? I am using www.goDaddy.com hosting (php/cfml/mysql), well ?
This topic has been closed for replies.

5 replies

E
EnergyFed
Inspiring
March 30, 2009
With GoDaddy.com they have PHP on all of their servers, and use phpMyAdmin. Just remember when setting up a mySQL database that you will need to add a coldfusion dns to the connection. This will add mysqlcf_ to your datasource name.

Of course with GoDaddy, they do not allow access to the CFAdmin. This is why it is important to add the CF Datasource when setting up a new mySQL database.

Then you will do all of your database work in phpMyAdmin.
1
123polis123Author
Known Participant
March 11, 2009
To UPDATE a database table record using an html form, how we populate form with this record’s DATA ?
S
Semaphorians
Participating Frequently
March 14, 2009
Hi, I hope the below solves your concern:

First select the record from table using <cfquery> like

<cfquery name='selectqry' datasource='your_data_source_name'>
SELECT *
FROm table_name
WHERE your_condition

</cfquery>

then populate form items with this record like

<cfoutput query="selectqry">
<form >
<input type="text" name="textbox" value="#selectqry.column_name#" />
.
.
.
.
.
<input type="submit" name="submit" value="submit" />
</form>
</cfoutput>

Hope this helps!
N
Newsgroup_User
Inspiring
March 8, 2009
> <cfquery > needs any other parameter ?

I see. The code you wrote is syntactically correct from a CF POV, yes.
I'd think twice before passing the user/pwd in the <cfquery> though. Just
set it in CFAdmin if poss.

The docs are always a good place to refer to for this sort of info:
http://livedocs.adobe.com/coldfusion/8/htmldocs/Tags_p-q_17.html#1102316


> phpMyAdmin may be used with PHP or CFML , Correct ?

It depends what you mean. phpMyAdmin is a DB client written in PHP. So
you need PHP running to be able to run it. PHP can cohabitate with CF, so
this is not a problem.

IMO phpMyAdmin is less relevant now that MySQL has its own admin tools,
which run natively.
http://dev.mysql.com/downloads/gui-tools/5.0.html

I'd only want to run a web-based DB admin tool in emergencies or if there's
no other option.

--
Adam
-
-__cfSearching__-
Inspiring
March 8, 2009
> I'd think twice before passing the user/pwd in the <cfquery> though

You might also want to change the password if the one you posted above is your real password for your database ...
1
123polis123Author
Known Participant
March 8, 2009
<cfquery > needs any other parameter ?

phpMyAdmin may be used with PHP or CFML , Correct ?
N
Newsgroup_User
Inspiring
March 7, 2009
> 
<cfquery datasource="cf123"
password="1234CF123" username="cfdbK" 

> name="getData" >

> SELECT * FROM CustomersTable

> </cfquery>

>
> is it correct if CustomersTable is a table in phpMyAdmin ? I am using
> www.goDaddy.com hosting (php/cfml/mysql), well ?

What is the question you're actually asking here?

--
Adam
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices