Megan R Brett mebrett

Digital humanist. I craft end-user documentation, run workshops, and create resources for learning new DH skills.

mebrett / editdocs

Created September 29, 2012 22:48

Display documents and edit/add new for Maury DB

	<?php
	//server info
	$server = 'server';
	$user = 'user';
	$pass = 'pass';
	$db = 'data';

	// connect to the database
	$mysqli = new mysqli($server, $user, $pass, $db);

mebrett / editdoc1

Created September 26, 2012 20:47

Trying to update records

	<html>
	<?php
	include "connect-db.php";

	//create form function
	function renderForm($id='', $dateF='', $dateD='', $collection='', $repos='', $repos_loc='')
	{ ?>
	<form action="" method="post">
	<?php if ($id != '') { ?>
	<input type="hidden" name="docID" value="<?php echo $id; ?>" />

mebrett / Maury add place form

Created September 26, 2012 13:17

code for adding new place to Maury database

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html>
	<head>
	<title>HTML form for insert users</title>
	</head>
	<body>
	<h2>Add Place to Maury Database</h2>

	<form action="insert_place.php" method="post">
	Place Name*: <input type="text" name="name" /><br />

mebrett / Maury add new person form

Created September 26, 2012 13:15

code for adding new person to Maury database

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html>
	<head>
	<title>Form to Insert Persons, Maury1a</title>
	</head>
	<body>
	<h2>Create New Person Record</h2>
	<p>This form creates a new person record for the database Maury1a. Please include as much information as possible.</p>
	<form action="insert4.php" method="post">
	First Name: <input type="text" name="firstname" /><br />

mebrett / Maury Add New Doc

Created September 26, 2012 13:15

code for form for adding new documents to Maury database

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html>
	<head>
	<title>Maury Database: Add Document</title>
	</head>
	<body>

	<h2>Add new documents to Maury database</h2>

	<form method="post" action="insert_doc.php">

mebrett / AppleOrange

Created September 25, 2012 22:14

sender works, written doesn't. Why?

	//create join link between sender and document
	$senders=($_POST['senders']);
	print_r ($senders);

	foreach($senders as $sender) {
	if ($sender >='1') {
	$addSender = "INSERT INTO sender (sender_doc_id, sender_pers_id) VALUES ('".$newDocid."', '".$sender."')";
	mysql_query($addSender) or die('Error '. mysql_error());
	echo "<br />Sender(s) successfully linked to document." ;
	}

mebrett / form_doc

Created September 23, 2012 21:33

Input form for documents

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html>
	<head>
	<title>Maury Database: Add Document</title>
	</head>
	<body>

	<h2>Add new documents to Maury database</h2>

	<form method="post" action="insert_doc.php">

mebrett / form

Created September 20, 2012 12:37

Adding people to database table

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html>
	<head>
	<title>Form to Insert Persons, Maury1a</title>
	</head>
	<body>
	<h2>Create New Person Record</h2>
	<p>This form creates a new person record for the database Maury1a. Please include as much information as possible.</p>
	<form action="insert.php" method="post">
	First Name: <input type="text" name="firstname" /><br />

mebrett / person_insert

Created September 19, 2012 01:49

Form to insert new person data into the database maury1

	<?php
	//connect to database
	$con = mysql_connect('localhost', 'root', 'root');

	//check connection
	if (!$con) {
	die('Could not connect');}
	/else{echo 'Success';}/

	mysql_select_db('maury1');