Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/hxseven/htmlSQL.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'examples/demo_01.php')
-rwxr-xr-xexamples/demo_01.php46
1 files changed, 46 insertions, 0 deletions
diff --git a/examples/demo_01.php b/examples/demo_01.php
new file mode 100755
index 0000000..a168b82
--- /dev/null
+++ b/examples/demo_01.php
@@ -0,0 +1,46 @@
+<?php
+
+ /*
+ ** htmlSQL - Example 1
+ **
+ ** Shows a simple query
+ */
+
+ include_once("../snoopy.class.php");
+ include_once("../htmlsql.class.php");
+
+ $wsql = new htmlsql();
+
+ // connect to a URL
+ if (!$wsql->connect('url', 'http://codedump.jonasjohn.de/')){
+ print 'Error while connecting: ' . $wsql->error;
+ exit;
+ }
+
+ /* execute a query:
+
+ This query extracts all links with the classname = nav_item
+ */
+ if (!$wsql->query('SELECT * FROM a WHERE $class == "nav_item"')){
+ print "Query error: " . $wsql->error;
+ exit;
+ }
+
+ // show results:
+ foreach($wsql->fetch_array() as $row){
+
+ print_r($row);
+
+ /*
+ $row is an array and looks like this:
+ Array (
+ [href] => /feedback.htm
+ [class] => nav_item
+ [tagname] => a
+ [text] => Feedback
+ )
+ */
+
+ }
+
+?> \ No newline at end of file