Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: VitoCorleone
  • Order by date
  1. VitoCorleone

    PHP search database and return results.

    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...
  2. VitoCorleone

    Inserting a BLOB into MYSQL using PHP $_POST???

    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?
  3. VitoCorleone

    Inserting a BLOB into MYSQL using PHP $_POST???

    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...
  4. VitoCorleone

    Can you use JOINS when inserting data?

    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?
  5. VitoCorleone

    Inserting records into MULIPLE tables!

    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)...
  6. VitoCorleone

    PHP is inserting blanks into MYSQL database!

    Thats great, thanks for all the input guys.
  7. VitoCorleone

    PHP is inserting blanks into MYSQL database!

    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...
  8. VitoCorleone

    PHP is inserting blanks into MYSQL database!

    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...
  9. VitoCorleone

    #1046 - No Database Selected in MySQL

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

    #1046 - No Database Selected in MySQL

    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
  11. VitoCorleone

    PHP, MYsql connection problem to database.

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

    Storing images, creating a image blob column?

    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/
  13. VitoCorleone

    PHP, MYsql connection problem to database.

    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"...
  14. VitoCorleone

    Fatal error: Call to undefined function, What is it!!!!!

    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.
  15. VitoCorleone

    Fatal error: Call to undefined function, What is it!!!!!

    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...
  16. VitoCorleone

    Fatal error: Call to undefined function, What is it!!!!!

    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...
  17. VitoCorleone

    Storing images, creating a image blob column?

    well i think a mediumblob should be enough.
  18. VitoCorleone

    Simple code, but image not displaying? i get this error...

    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.]
  19. VitoCorleone

    Storing images, creating a image blob column?

    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...
  20. VitoCorleone

    Simple code, but image not displaying? i get this error...

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

Part and Inventory Search

Back
Top