Search results for query: *

...database server"); $dConn = mysql_select_db($dbDatabase, $sConn) or die("Couldn't connect to database $dbDatabase"); $result = mysql_query("SELECT * FROM staff WHERE staff_no = '" . $_POST['staffno'] ."'",$db); echo "<table border=1>\n"; echo "<tr><td>staff Number</td><td>name</tr>\n"...

Thanks that has cleared things up, However for admin purposes i need to insert the binary image straight into the MySQL db and not upload the file to a folder. Any sites of reference? is it possibleto do this via $_files method?

hi, is it possible to insert a file into my database table using the POST method in PHP. i have seen examples using the global attributes but i need to only use POST as i have an HTML form and a PHGP confirmation page which calls the previous page values to insert. I have tried...

hello, This is a half mysql and PHP question. I was wondering if you can use JOINS to insert into multiple tables rather than using mysql_query() to invoke multiple queries? If you can, could you point me to some examples?

hello, I have a form which i need to insert records into multiple tables. i am using $_POST to retrieve values from the previous page and have been using the following statement to insert into a single table $dbQuery = "INSERT INTO staff (staff_no, fname, lname, position_, sex, dob, salary)...

Thats great, thanks for all the input guys.

i changed the query too $dbQuery = "INSERT INTO staff2 (staff_no) VALUES "; $dbQuery .= "('$_POST['strstaff']')"; mysql_query($dbQuery) or die("Couldn't add file to database"); Im now getting the error message Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting...

Hi, I have the following script that inserts data into my SQL database. its a simple insert query to check if it works! but when i search my database, a new rowhasbeen added but it is blank. I have looked at my code but cant find anything, can you? <?php global $strstaff; // Database...

Yes, when using the SQL console i can see all the data and tables, but not in phpmyadmin? i could before

Why do i get this error when i query my database tables in MYPHPadmin? #1046 - No Database Selected I cannot view any of the data in the tables in myphpadmin only Mysql Console

hi, yes i noticed that sytax error which has been changed to $dbQuery = "INSERT INTO staff (staff_no, fname) VALUES"; $dbQuery = "('$staffno', '$fname')";

Yes, here is a great article on inserting blobs via PHP http://www.devarticles.com/c/a/MySQL/Blobbing-Data-With-PHP-and-MySQL/3/

hello everyone, I have a sime error but cant figure out the solution.The following PHP script inserts 2 values into mySQL database i created using the POST method. <?php global $staffno; global $fname; // Database connection variables $dbServer = "localhost"; $dbDatabase = "dreamhome"...

Hmmm, i ran : <?php phpinfo(); ?> and there is no mention of exif in the whole page, i also did search and find "exif" on the entire page but nothing is found.

Ok, Here is what i am running I have the following code to display an image in PHP <?php // get a file name $file='eclipse.jpg'; // check it is a jpeg file if(exif_imagetype($file) == IMAGETYPE_JPEG) { $exif = exif_read_data($file,"COMPUTED,IFD0", TRUE); print ("Picture taken...

Hi, i have been getting the following errors when i run some of my scrpits on my WAMP5. Fatal error: Call to undefined function blah blah blah line 17 What could it be, I had a look see to check if my EXIF and MBSTRINg was installed, and they seem to be as they are in the module extensions...

well i think a mediumblob should be enough.

Do you have any idea how i go about this? I read the lik but it makes no sense! you can tell that im used to the automated world of dreamweaver. Im taking a leap into the hand coding world.]

Hi, I would like to add a column so that images can be inserted and viewed from a mysql database. I have set up the table as follows: CREATE TABLE Staff (staff_no CHARACTER(5) PRIMARY KEY, fname CHARACTER VARYING(20), lname CHARACTER...

Hi, I have the following code to display an image in PHP <?php // get a file name $file='eclipse.jpg'; // check it is a jpeg file if(exif_imagetype($file) == IMAGETYPE_JPEG) { $exif = exif_read_data($file,"COMPUTED,IFD0", TRUE); print ("Picture taken {$exif['IFD0']['DateTime']} "...