[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[GNUnet-SVN] r2299 - GNUnet-docs/WWW/test/tmp
From: |
grothoff |
Subject: |
[GNUnet-SVN] r2299 - GNUnet-docs/WWW/test/tmp |
Date: |
Wed, 30 Nov 2005 17:31:47 -0800 (PST) |
Author: grothoff
Date: 2005-11-30 17:31:34 -0800 (Wed, 30 Nov 2005)
New Revision: 2299
Added:
GNUnet-docs/WWW/test/tmp/ads.php
Log:
sync
Added: GNUnet-docs/WWW/test/tmp/ads.php
===================================================================
--- GNUnet-docs/WWW/test/tmp/ads.php 2005-11-30 08:24:26 UTC (rev 2298)
+++ GNUnet-docs/WWW/test/tmp/ads.php 2005-12-01 01:31:34 UTC (rev 2299)
@@ -0,0 +1,52 @@
+<?php
+header("Content-type: text/html; charset=utf-8");
+$connection = mysql_connect("localhost", "jobs", "jobs");
+if (!$connection)
+ die ("Failure connecting to localhost " . mysql_error());
+if ($connection) {
+ $db_selected = mysql_select_db("jobs", $connection);
+ if (!$db_selected)
+ die ('Error selecting db : ' . mysql_error());
+}
+echo "<html><body>\n";
+$query = "SELECT * FROM universities";
+$result = mysql_query($query, $connection);
+$skipped = 0;
+$num = 0;
+if ($result)
+ $num = mysql_num_rows($result);
+echo "Database has $num entries.<br>\n";
+echo "<table border=5>\n";
+for ($ii=0;$ii<$num;$ii++) {
+ $row = mysql_fetch_array($result);
+ $id = $row["id"];
+ $query2 = "SELECT * FROM applications WHERE id=$id";
+ $result2 = mysql_query($query2, $connection);
+ $num2 = 0;
+ if ($result2)
+ $num2 = mysql_num_rows($result2);
+ if ($num2 == 0) {
+ $query3 = "SELECT * FROM noads WHERE id=$id";
+ $result3 = mysql_query($query2, $connection);
+ $num3 = 0;
+ $reason = "";
+ if ($result3)
+ $num3 = mysql_num_rows($result3);
+ if ($num3 > 0) {
+ $row3 = mysql_fetch_array($result);
+ $reason = $row3["reason"];
+ }
+ printf("<tr><td>%s</td><td><a href=\"%s\">%s</a><td><td><a
href=\"%s\">%s</a></td></tr>\n",
+ $id,
+ $row["url"],
+ $row["name"],
+ $row["appUrl"],
+ $reason);
+ } else {
+ $skipped++;
+ }
+}
+echo "</table>\n";
+echo "Skipped $skipped entries.<br>";
+echo "</body></html>\n"
+?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [GNUnet-SVN] r2299 - GNUnet-docs/WWW/test/tmp,
grothoff <=