Is there a usage the same as "cfhttp" in php?

danielson

There are functions called "cfhttp", "cfhttpparam" in coldfusion.
--"cfhttp" means to download the web page from the server
--"chttpparam" means to upload the parameter from the client to the server's web page in order to do some tasks,such as query
For example , I can set some parameters such as author ,bookname in the client end and upload these parameters to server, and the server can do query according to the parameters.
Afterwards, user can download the query result from the server.
Is there any method to do such behavior in php??
(Because I want to exchange code from coldfusion to php)
Thanks for answering~😉

MrAlaska

I have never used CF, but it is my understanding by viewing pro/con lists that database abstraction and ease of use is on the 'pro' side of CF. There is a pretty good chance you will need to write your own methods to obtain some of the functionality you wish.

Pardon my ignorance, but I do not understand the functions you describe.

What do you mean 'download the web page'? Do you mean sending a header command to force the client to save it instead of view it?

Regarding setting parameters on the client end and downloading the data, I am kinda shaky on that one too. Are you talking about a client side executable? How is the client downloading the data? What format is it arriving in? PHP most easily passes data from the client to the server via forms and the normal method of returning results is by displaying them, but anything is possible.

Sorry, I came in with more questions than answers 😃

danielson

In fact, I am not very sure the exact meaning of "cfhttp".
However, I have read from the book; it says the user end download the query result page from the sever, and show it on user's browser.
The point is "how can users upload these parameters edit by user and the server receive these parameter to make query".
and then user can see the query result page...
NOTE If I can connect to the MySQL directly and do query..I wouldn't use "cfhttp" this method.
Now, I can't know any tables of the MySql, so I need to connect to another query page, and upload the parameters to do query.
I hope you understanding my meaning. :p

MrAlaska

Hmm, it would appear CF actually builds and formats the web pages for you. In PHP, directly connecting the database is required and you then build your own pages to prompt for user input, for sending the parameters (via SQL statement), and for displaying them. It does not seem you will find any direct conversion, you will need to basically rebuild the application most likely. It might entail learning PHP from the ground up:

Php manual:
http://www.php.net/manual/en/
http://www.php.net/manual/en/tutorial.php

Beginning PHP tutorials:
http://hotwired.lycos.com/webmonkey/programming/php/
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html
http://www.zend.com/zend/tut/ (beginning - advanced)
http://www.newbienetwork.net/sections.php (PHP and MySql)
http://www.webmasterbase.com/subcats/53 (beginning - advanced)
http://www.thefreecountry.com/ (general programming tips, tutorials, and articles)
http://www.phpbuilder.net/columns/ (tutorials and articles)
http://php.resourceindex.com/Documentation/ (many tutorials and articles)
http://www.wdvl.com/Authoring/Languages/PHP/ (some articles/tutorials intermedieate and advanced)
http://www.onlamp.com/php/ (many articles/tutorials beginning - advanced)

Some SQL help:
http://www.sqlcourse.com
http://www.sqlzoo.net
http://www.devshed.com/Server_Side/MySQL/Intro/page1.html
http://www.devshed.com/Server_Side/PHP/DB_Basics/page1.html

MySql manual:
http://www.mysql.com/doc/en/index.html

danielson

Therefore, you mean that if I use php...
I must connect to MySQL directly??
Is there any other methods I can use "query" in MySQL?

MrAlaska

There is probably abstraction libraries available to give you more functionality (I have never looked into that) but native PHP code only provides for explicitly making your connection and query.

This is all the MySql methods available:
http://www.php.net/manual/en/ref.mysql.php

This is an example of querying a table and printing out the results:

<?php
    /* Connecting, selecting database */
    $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
        or die("Could not connect");
    print "Connected successfully";
    mysql_select_db("my_database") or die("Could not select database");

/* Performing SQL query */
$query = "SELECT * FROM my_table";
$result = mysql_query($query) or die("Query failed");

/* Printing results in HTML */
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    print "\t<tr>\n";
    foreach ($line as $col_value) {
        print "\t\t<td>$col_value</td>\n";
    }
    print "\t</tr>\n";
}
print "</table>\n";

/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($link);
?>

danielson

I know how to connect to MySQL directly in php...
but now I can't connect to the MySQL..because I have no idea about its table and database..
Therefore, I have to get the "query result" via a page which is connecting to the MySQL...
Thanks for your answer~~