I do suspect you also have to open the database access first
$db = mysql_connect('YOUR_DB_ADDRESS','YOUR_DB_USER','YOUR_DB_PASS') or die("Database error");
mysql_select_db('YOUR_DB', $db);
--- On Fri, 3/19/10, Pete <cgrp@xxxxxxxxxxxx> wrote:
From: Pete <cgrp@xxxxxxxxxxxx>
Subject: Re: Video upload problem
To: php-objects@xxxxxxxxxxxxxxx
Date: Friday, March 19, 2010, 2:49 PM
In message <581504.60901. qm@web46211. mail.sp1. yahoo.com>, Gab Teo
<doneatlast1000@ yahoo.com> writes
>Anyone in the house please,
>
>Can someone spot out while the below video script is entry empty data on my
>database.
>
>
>This is the video input script
>
><?php
>if (isset($_POST[ Submit]))
>{
>include ("mydatabase. php");
>$name=mysql_ real_escape_ string($_ POST[name] );
>
> if (file_exists( "upload/" . $_FILES["file" ]["name"] ))
> {
> echo $_FILES["file" ]["name"] . " already exists. ";
> }
> else
> {
> move_uploaded_ file($_FILES[ "file"][" tmp_name" ],
> "upload/" .urlencode( $_FILES["file" ]["name"] ));
> $path="upload/ " . urlencode($_ FILES["file" ]["name"] );
>
> $insert=mysql_ query("insert into videos(username, name,path) Values(
>'$username' , '$name', '$path')");
I don't see where you set $username.
I would try
$qry="insert into videos(username, name,path) Values( $username', '$name',
'$path')";
echo $qry;
$insert=mysql_ query($qry) ;
That, and any mysql error message that you get, should show you how to
sort it out.
--
Pete Clark
Hot Costa - Local Spain
http://www.hotcosta .com
[Non-text portions of this message have been removed]
