Skip to content

Instantly share code, notes, and snippets.

View mebrett's full-sized avatar

Megan R Brett mebrett

12 followers · 8 following
View GitHub Profile
@mebrett
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
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
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
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
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
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
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
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
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');