database... please help me....

Goldenlamp

Can somebody look at php codes, and tall me what SQL table. I have to make.

It's a program that I have bayed for, and the company don't help whit the SQL table...


[code=php]<?
	require("database.inc.php");
	connectDatabase();
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Gem diktat</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>
<?
	$words=explode(";",$_POST['words']);
	foreach($words as $word) {
		mysql_query("INSERT INTO repository SET `word`='".$word."';");
		move_uploaded_file($_FILES[$word]['tmp_name'],"audio/".mysql_insert_id().".au");
	}
	$handle=fopen("text/".$_POST['title'].".txt","w+");
	fputs($handle,$_POST['content'],strlen($_POST['content']));
	fclose($handle);
?>
Diktatet er gemt!
</body>
</html>

this is another PHP sample.. also using to uploading and saving.....

<?
	require("database.inc.php");
	connectDatabase();
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>V&aelig;lg lyd til <?=$_POST['title']?></title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>

<body>
<? if(file_exists("text/".$_POST['title'].".txt")) {
?>
<h1>V&aelig;lg lyd</h1>
<h3 style="color:#CC3333">Pas p&aring;! Der findes allerede et diktat med denne titel.<br />
Hvis du er ved at lave et nyt diktat, burde du g&aring; <a href="javascript:history.back()">tilbage</a> og v&aelig;lge en anden titel.
G&oslash;r du ikke det, bliver diktatet med titelen &quot;<?=$_POST['title']?>&quot; erstattet med dette diktat her!</h3>
<?
}
?>
<form enctype="multipart/form-data" action="save_dict.php" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="500000" />
<table border="0">
<?
	$result=mysql_query("SELECT word FROM repository;");
	while($entry=mysql_fetch_array($result)) {
		$repository[]=$entry[0];
	}
	$word_start=0;
	$word_stop=0;
	$open=false;
	$words=array();
	$content=$_POST['content'];
	for($i=0;$i<strlen($content);$i++) {
		if(substr($content,$i,1)=="<" && !$open) {
			$word_start=$i+1;
			$open=true;
		}
		elseif(substr($content,$i,1)==">" && $open) {
			$word_stop=$i;
			$word=substr($content,$word_start,$word_stop-$word_start);
			if(!in_array($word,$repository)) {
				$words[]=$word;
				?>
				<tr>
					<td><?=$word?></td>
					<td><input type="file" name="<?=$word?>" /></td>
				</tr>
				<?
			}
			$open=false;
		}
	}
?>
</table>
<input type="hidden" name="words" value="<? echo implode(";",$words); ?>" />
<input type="hidden" name="content" value="<?=$_POST['content']?>" />
<input type="hidden" name="title" value="<?=$_POST['title']?>" />
<input type="submit" value="Upload &amp; gem" />
</form>
</body>
</html>

tomhath

All I see is one table with one column. Try this:

CREATE TABLE repository (word varchar(60));

Roger_Ramjet

tomhath wrote:
All I see is one table with one column. Try this:

CREATE TABLE repository (word varchar(60));

Nah Tom, there are at least 2 columns

    foreach($words as $word) {
        mysql_query("INSERT INTO repository SET `word`='".$word."';");
        move_uploaded_file($_FILES[$word]['tmp_name'],"audio/".mysql_insert_id().".au");
    }

So it needs an autoinc column as well.

It seems to be an indexing system for keywords to uploaded files with the file renamed to the autoinc id. It also seems that multiple copies of the file will be saved: one for each 'word' since that's in a loop. :eek:

Goldie, shame you paid for that script cos it looks like a load of crap to me, and they certainly should be supporting you on the database. How did you pay them? If you can cancel the payment or do a chargeback on your credit card then do so.

tomhath

Yup. Doesn't give any clue what the id column is named, I suppose try it with "id".