MySQL PHP Forms Test


Accessing MySQL on the Web Using PHP
0){
         $aname = $arr[1];
      }
   }

   ini_set('display_errors', 'On');
   error_reporting(E_ALL);

   $mysqli = new mysqli("sql.cs.oberlin.edu","alice","tiger","moma");
   
   if($mysqli->connect_errno){
      echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
   }

   $mysqli->set_charset('utf8mb4');

  // Form an SQL query  
  $res = $mysqli->query("SELECT DISTINCT cid,displayname FROM artists natural join produced group by cid,displayname having count(*)>10 and count(*)<30 ORDER BY displayname limit 50");
  if(!$res){
    echo "Error in query";
  }

  // Display a drop-down menu containing artist names
  print '';
  print 'Select an Artist from the Artists Table:  ';
  print '




query("SELECT objectid,title,workdate,medium,creditline,classification,department,dateacquired,url from artworks natural join produced where cid='" . $cid . "' order by objectid");
  if(!$res){
    echo "Error in query";
  }

  // Print the result as a table
  print 'Artworks by '.$aname.'';

  print ''; 

  // Print column headings
  $ncols = $res->field_count;

  print '';
  $column_names = $res->fetch_fields();
  for ($i = 1; $i <= $ncols; $i++) {
    $column_name = $res->fetch_field()->name;
    print "";
  }

  // Print the query results in a table
  while ($row = $res->fetch_row()) {
    print '';
    foreach ($row as $item) {
	$htmlitem = $item?htmlentities($item):' ';
	// if the item begins with http, display it as a hyperlink
	$pos = strpos($htmlitem,'http');
	if($pos === 0){
          print '';
	}
	else {
	  print '';
	}
    }
    print '';
  }
  print '" . $column_name . "
'.$htmlitem.' '.($item?htmlentities($item):' ').'';

}

?>
" . $column_name . "
'.$htmlitem.'	'.($item?htmlentities($item):' ').'