Search results for query: *

i have a form where a user can search the database STAFF, here they insert a staff number and press submit. the next page is using the $_Post to retrieve that value on the previous page and display the records. however its not working. Can you help? Any sites? Here is the code on my 2nd...

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']} "...