Recent content by RajaGautam

  1. R

    Check Constraint in MySQL

    Hi! everyone i have check constraint example like this: create table persons ( P_Id int not null, LastName varchar(255) not null, FirstName varchar(255), Address varchar(255), City varchar(255), CHECK (P_Id>0) ); The above example run successfully but it allow me to input P_Id to 0 which is...
  2. R

    Uploading Image to MySql database

    Thanks for all your reply & Finally i did.
  3. R

    Increasing Font Size

    Hi! I'm using PhpDesigner 8. How to increase font size while typing code? I didn't found either on menu option or by google search. Any idea?
  4. R

    Increasing Image Size

    Hey! guys how to edit my.ini file at ":\xampp\mysql\bin\" to upload image of bigger size supposed to be 10 MB. I recently make a change in my.ini file in max_allowed_packet to be 10 MB. But it doesn't change alot, a little bit has been changed. Now i can upload image upto 2048 KiB in MySQL & via...
  5. R

    Inserting Image into MYSQL Database

    Hi! I have a two basic extension file for Uploading and Inserting Image in MySQL. First I have a ADD.HTML File & Second INSERT.PHP, ADD.HTML provide form input box for image upload, it goes as below: ADD.HTML <html> <head><title>Form upload to DataBase</title> </head> <body> <form...
  6. R

    Unknown Table Status

    What is mean by "Unknown Table Status: TABLE_TYPE" in phpMyAdmin 3.5.2.2 :)
  7. R

    Using Wildcard in MYSQL

    Hi! I want to select persons with a last name that starts with "b" or "s" or "p" from the "Persons" table. Here goes SELECT Statement, SELECT * FROM Persons WHERE LastName LIKE '[bsp]%' But MySQL returned an empty result set. How to fix it? :cool:
  8. R

    Uploading Image to MySql database

    Hi! I fix single quotes with double quotes issue but even though it has an error saying: Fatal error: Call to undefined function addslahes() in C:\xampp\htdocs\php\storeinfo.php on line 16 Line 16: $aphoto = addslahes(file_get_contents($_FILES['aphoto']['tmp_name'])); Why there is undefined...
  9. R

    Using TOP Clause in MYSQL

    Hi! I want to use TOP Clause in MySQL but i'm unable to do it. The SQL Statement is as below: SELECT TOP * FROM Persons It display the error saying: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near...
  10. R

    Uploading Image to MySql database

    I have two php extension code one for form input & another for upload to MySql database management system. The form input code is as below: denoted by "main.php" <html> <title>Animal Information</title> <body> <form enctype="multipart/form-data" action="storeinfo.php" method="POST"> <table...
See more
Top Bottom