pdb, the Pure Data Base

List of all pd objects

 reverse order
 show libraries
 include PureData built-in
 make links to pdb

[ALL EXTERNALS WITH COMPLETE ENTIRES]

Pure Data Search

search for....

Library
External
Abstraction
All

by ...

Name
Description
Author
All (excluding Author)

Seachrstring ...


    

[RESET]
function get_ext($ext_name, $ext_desc) { // if ($ext_name !="") $query ="select * from External where External_Name like '%$ext_name%'"; if ($ext_desc !="") $query ="select * from External where External_Description like '%$ext_desc%'"; /* print "

"; print $query; print "
"; */ $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); // if ($ext_name !="") print "

Search for Externals by name like $ext_name returned $num_of_rows Externals.
 
"; if ($ext_desc !="") print "

Search for Externals by description like $ext_desc returned $num_of_rows Externals.
 
"; while ($row = mysql_fetch_row ($query_result_handle)) { $External_ID[$n]=$row[0]; $Author_ID[$n]=$row[1]; $External_Name[$n]=$row[2]; $External_Description[$n]=$row[3]; $URL_ID[$n]=$row[4]; $Library_ID[$n]=$row[5]; $HelpPatch[$n]=$row[6]; $Type[$n]=$row[7]; $n++; } // make an array of $Author_name[$Author_ID] end populate it by mysql while ($Author_ID[$m]) { $query ="select Author from Author where Author_ID = '$Author_ID[$m]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows Author Names.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Author_Name[$Author_ID[$m]]=$row[0]; } $m++; } // and now for the URLs while ($URL_ID[$z]) { $query ="select Download,Documentation from URL where URL_ID = '$URL_ID[$z]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows URLs.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Download[$URL_ID[$z]]=$row[0]; $Documentation[$URL_ID[$z]]=$row[1]; } $z++; } // Library while ($Library_ID[$y]) { $query ="select Library_Name from Library where Library_ID = '$Library_ID[$y]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows Libraries.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Library_Name[$Library_ID[$y]]=$row[0]; } $y++; } // print the whole thing echo ''; while ($External_ID[$p]) { echo ' '; $p++; } echo '
'; print " Name: ".$External_Name[$p]."
Author: ".$Author_Name[$Author_ID[$p]]."
Library: ".$Library_Name[$Library_ID[$p]]."
Description: ".$External_Description[$p]."
Download: ". $Download[$URL_ID[$p]]."
Documentation: ". $Documentation[$URL_ID[$p]].""; echo '
'; } // <----------------------get libs ----------------------> function get_lib($lib_name, $lib_desc) { if ($lib_name !="") $query ="select * from Library where Library_Name like '%$lib_name%'"; if ($lib_desc !="") $query ="select * from Library where Library_Description like '%$lib_desc%'"; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($lib_name !="") print "

Search for Libraries by name like $lib_name returned $num_of_rows Libraries.
 
"; if ($lib_desc !="") print "

Search for Libraries by description like $lib_desc returned $num_of_rows Libraries.
 
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Library_ID[$n]=$row[0]; $Author_ID[$n]=$row[1]; $Library_Name[$n]=$row[2]; $Library_Description[$n]=$row[3]; $URL_ID[$n]=$row[4]; $Platform[$n]=$row[5]; $Version[$n]=$row[6]; $n++; } // make an array of $Author_name[$Author_ID] end populate it by mysql while ($Author_ID[$m]) { $query ="select Author from Author where Author_ID = '$Author_ID[$m]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows Author Names.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Author_Name[$Author_ID[$m]]=$row[0]; } $m++; } // and now for the URLs while ($URL_ID[$z]) { $query ="select Download,Documentation from URL where URL_ID = '$URL_ID[$z]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows URLs.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Download[$URL_ID[$z]]=$row[0]; $Documentation[$URL_ID[$z]]=$row[1]; } $z++; } // print the whole lib echo ''; while ($Library_Name[$p]) { echo ''; $p++; } echo '
'; print " Name: ".$Library_Name[$p]."
Author: ".$Author_Name[$Author_ID[$p]]."
Description: ".$Library_Description[$p]."
Download: ". $Download[$URL_ID[$p]]."
Documentation: ". $Documentation[$URL_ID[$p]]."
"; echo '
'; } //<--------------------- get abs -----------------------------> function get_abs($abs_name, $abs_desc) { if ($abs_name !="") $query ="select * from Abstraction where Abstraction_Name like '%$abs_name%'"; if ($abs_desc !="") $query ="select * from Abstraction where Abstraction_Description like '%$abs_desc%'"; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($abs_name !="") print "

Search for Abstractions by name like $abs_name returned $num_of_rows Abstractions.
 
"; if ($abs_desc !="") print "

Search for Abstractionss by description like $abs_desc returned $num_of_rows Abstractions.
 
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Abstraction_ID[$n]=$row[0]; $Author_ID[$n]=$row[1]; $Abstraction_Name[$n]=$row[2]; $Abstraction_Description[$n]=$row[3]; $URL_ID[$n]=$row[4]; $Library_ID[$n]=$row[5]; $Help_Patch_URL[$n]=$row[6]; $n++; } // make an array of $Author_name[$Author_ID] end populate it by mysql while ($Author_ID[$m]) { $query ="select Author from Author where Author_ID = '$Author_ID[$m]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows Author Names.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Author_Name[$Author_ID[$m]]=$row[0]; } $m++; } // and now for the URLs while ($URL_ID[$z]) { $query ="select Download,Documentation from URL where URL_ID = '$URL_ID[$z]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows URLs.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Download[$URL_ID[$z]]=$row[0]; $Documentation[$URL_ID[$z]]=$row[1]; } $z++; } // Library while ($Library_ID[$y]) { $query ="select Library_Name from Library where Library_ID = '$Library_ID[$y]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows Libraries.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Library_Name[$Library_ID[$y]]=$row[0]; } $y++; } // print ze abs echo ''; while ($Abstraction_ID[$p]) { echo ' '; $p++; } echo '
'; print " Name: ".$Abstraction_Name[$p]."
Author: ".$Author_Name[$Author_ID[$p]]."
Library: ".$Library_Name[$Library_ID[$p]]."
Description: ".$Abstraction_Description[$p]."
Download: ". $Download[$URL_ID[$p]]."
Documentation: ". $Documentation[$URL_ID[$p]].""; echo '
'; } //<--------------------- get patches -----------------------------> function get_pat($pat_name, $pat_desc) { if ($pat_name !="") $query ="select * from Patch where Patch_Name like '%$pat_name%'"; if ($pat_desc !="") $query ="select * from Patch where Patch_Description like '%$pat_desc%'"; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($pat_name !="") print "

Search for Patches by name like $pat_name returned $num_of_rows Patches.
 
"; if ($pat_desc !="") print "

Search for Patches by description like $pat_desc returned $num_of_rows Patches.
 
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Patch_ID[$n]=$row[0]; $Author_ID[$n]=$row[1]; $Patch_Name[$n]=$row[2]; $Patch_Description[$n]=$row[3]; $URL_ID[$n]=$row[4]; $Library_ID[$n]=$row[5]; $n++; } // make an array of $Author_name[$Author_ID] end populate it by mysql while ($Author_ID[$m]) { $query ="select Author from Author where Author_ID = '$Author_ID[$m]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows Author Names.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Author_Name[$Author_ID[$m]]=$row[0]; } $m++; } // and now for the URLs while ($URL_ID[$z]) { $query ="select Download,Documentation from URL where URL_ID = '$URL_ID[$z]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows URLs.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Download[$URL_ID[$z]]=$row[0]; $Documentation[$URL_ID[$z]]=$row[1]; } $z++; } // Library while ($Library_ID[$y]) { $query ="select Library_Name from Library where Library_ID = '$Library_ID[$y]'"; //print $query; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); if ($num_of_rows != 1 ) print "

WARNING: got $num_an_of_rows Libraries.
"; while ($row = mysql_fetch_row ($query_result_handle)) { $Library_Name[$Library_ID[$y]]=$row[0]; } $y++; } // print the whole thing echo ''; while ($Patch_ID[$p]) { echo ' '; $p++; } echo '
'; print " Name: ".$Patch_Name[$p]."
Author: ".$Author_Name[$Author_ID[$p]]."
Library: ".$Library_Name[$Library_ID[$p]]."
Description: ".$Patch_Description[$p]."
Download: ". $Download[$URL_ID[$p]]."
Documentation: ". $Documentation[$URL_ID[$p]].""; echo '
'; } //<--------------------- get author -----------------------------> function get_aut($name) { $query ="select Author_ID,Author from Author where Author like '%$name%'"; $query_result_handle = mysql_db_query("pd", $query); $num_of_rows = mysql_num_rows($query_result_handle); print "

Search for Author by Name like $name returned $num_of_rows Authors.
 
"; // get her ID ... possibly there are more of them! while ($row = mysql_fetch_row ($query_result_handle)) { $Author_ID[$n] = $row[0]; $Author_Name[$n] = $row[1]; $n++; } // now look what she has done ... while ($Author_ID[$ai]) { $query="select Library_Name from Library where Author_ID = '$Author_ID[$ai]'"; $query_result_handle = mysql_db_query("pd", $query); while ($row = mysql_fetch_row ($query_result_handle)) { $Library_Name[$l][$Author_ID[$ai]]=$row[0]; $l++; } $query="select External_Name from External where Author_ID = '$Author_ID[$ai]'"; $query_result_handle = mysql_db_query("pd", $query); while ($row = mysql_fetch_row ($query_result_handle)) { $External_Name[$x][$Author_ID[$ai]]=$row[0]; $x++; } $query="select Abstraction_Name from Abstraction where Author_ID = '$Author_ID[$ai]'"; $query_result_handle = mysql_db_query("pd", $query); while ($row = mysql_fetch_row ($query_result_handle)) { $Abstraction_Name[$b][$Author_ID[$ai]]=$row[0]; $b++; } $query="select Patch_Name from Patch where Author_ID = '$Author_ID[$ai]'"; $query_result_handle = mysql_db_query("pd", $query); while ($row = mysql_fetch_row ($query_result_handle)) { $Patch_Name[$pt][$Author_ID[$ai]]=$row[0]; $pt++; } $ai++; } // print the whole author thing echo ''; while ($Author_ID[$p]) { echo ' '; $p++; } echo '
'; print " Author: ".$Author_Name[$p]; print"
Libraries:"; while ($Library_Name[$li][$Author_ID[$p]]){ print "". $Library_Name[$li][$Author_ID[$p]]." "; $li++; } print "
Externals: "; while ($External_Name[$xi][$Author_ID[$p]]){ print "". $External_Name[$xi][$Author_ID[$p]]." "; $xi++; } print"
Abstractions:"; while ($Abstraction_Name[$di][$Author_ID[$p]]){ print "". $Abstraction_Name[$di][$Author_ID[$p]]." "; $di++; } print "
Patches: "; while ($Patch_Name[$gi][$Author_ID[$p]]){ print "". $Patch_Name[$gi][$Author_ID[$p]]." "; $gi++; } echo '
'; } // <---------------------- check for results ------------------------> // parse the query if ($qry) { $db=mysql_connect("iemdb.iemnet","www","www"); if ($alb) { if($ext) { if ($qry == "complete") { get_ext("",""); } } if($lib || $all) get_lib($qry,""); if($ext || $all) get_ext($qry,""); if($abs || $all) get_abs($qry,""); if($pat || $all) get_pat($qry,""); if($lib || $all) get_lib("",$qry); if($ext || $all) get_ext("",$qry); if($abs || $all) get_abs("",$qry); if($pat || $all) get_pat("",$qry); } else if($nam) { if($lib || $all) get_lib($qry,""); if($ext || $all) get_ext($qry,""); if($abs || $all) get_abs($qry,""); if($pat || $all) get_pat($qry,""); } else if($des) { if($lib || $all) get_lib("",$qry); if($ext || $all) get_ext("",$qry); if($abs || $all) get_abs("",$qry); if($pat || $all) get_pat("",$qry); } if($aut) { get_aut($qry); } mysql_close($db); } else echo '

Notes:
You can put only one single word into the search string field. This word can be a substring of what you search, e.g. "ex" will give you both "zexy" and "ggext". Do not forget to check a category (Library, External, Abstraction). Multiple choices are allowed.

Author search: just check the "Author" box and fill in a searchstring. '; ?>

Found an error? Your entry is missing? please contact me, <math at iem.at>

Last Page Update: Mar 21, 2002, Last Database Update: Jun 15, 2002, Norbert Math