PHP :: Determining Type Of MySQL Field.

Determining Mime Type Of MySQL Blob?
Is there any PHP function that will allow me to determine the MIME type
of a blob stored in MySQL?

Specifically, if I'm storing an image as a blob in MySQL, is there any
PHP function that can determine whether it's a gif, jpeg, png, etc?

MySQL Field Type For Arrays
What type of field type are arrays stuffed into? VARCHAR ? TEXT?

Best MySQL Field Type For Unix Timestamp?
What do you recommend as the best type of field for a timestamp in a MySQL
database? I've considered varchar(10) or INT but I'm not sure what is the
best, most efficient, and most reliable field type.

Is There A Universal Field Type?
Is there a field that will accept any type of data? like varchar, blob, or any special combination, that will hold the data I insert into a table... exactly as it was entered (including quotes ' and "). .. and not let mysql parse through it?

Determine Field Type
When a form is submitted I can get the field names and the entered values with $_POST, but is there a way to determine what type of field? For instance, can I determine if a field was a textarea or an input field?

Read Mssql Field Type From Php
this question is 50% mssql and 50% php. To get field definitions and other
informations for table 'myTable', I use with sql server:

EXEC sp_help myTable

The problem with php is this command returns several result sets, and
informations about field types is not in the first one. If I query mssql
from php and fetch result, I only get informations about the first one, and
php completetly ignores the other one.

Is there a mean to read other result sets, or is there another sql command
that returns field definition?

Changing Form's Field Input Type
We have the form which uses checkboxes for several fields and the target
action points to outside webservice. Unfortunatelly they do not support
checkboxes. How to pass it as a radio buttons or pull down select box with
Yes/No options for example (which they support) using still checkboxes as an
input entry.

Help On A Multiple Keyword Search On A TEXT Field Type
Working on a php/mysql driven site which requires me to have a search facility based on multiple keywords. I read the tutorial "quick and dirty search engine". What i want to know is :

1. Is there any SQL query i could perform which could to almost the same thing ( i dont really need the accuracy ) ?

2. Any other methods of achieving it?

Check What Type (integer, String Etc) A Database Field Is
If i have a datebase field like so:

$username = $row['username']; //after SELECT and mysql_query etc.

how do i check what file type it is? i have tried using is_string to
check it but it returns all fields back as strings, even the ones i
know are integers. i would like something that would tell me the data
tyle (integer, varchar, text etc). are there any other ways or am i
doing this wrong?

Show Stored Value For Form Field Type=file
I have a file-uploading form to uploads a .jpg file and stores its name in a table in my db as co_bannerfile. I'm trying to now write an update form so the user can update their .jpg file. I've successfully written a query to retrieve the stored file's name.

How can I display the stored file's name so the user can see its name within the input TYPE="file" field and then decide to update it or not? The following doesn't display the stored file name. What do I have wrong? Code:

Save Date To Table Field Date Type
I have a calendar picker on a form that fills a text box with XX/XX/XXXX date format. If I run a insert statement the date field in the database shows 0000-00-00. If i change the field type to varchar the correct format displays.

What is the correct way to save a date to a mysql database? Furthermore to query on the date how about a select * from db_name where servicedate >= $startdate and servicedate >= $enddate I supose this will not work
Any pointers?

Select Both Field Name And Field Value- Mysql ?
What function to use to select both field name and field value from a mysql table ?

Mysql Row Type?
what do I have to set a mysql row to, too be rank them in order when the numbers in the database are Ɔ.00' format?

FILE Type For MySQL ?
Is there a FILE type in MySQL??? to store files as a column in a registry of certain table?

MYSQL BOOL TYPE
Im trying to make a setion in my table, true or false, but when i try to make it i get an error. this is what i do and the mistake they say i did. not totaly sure what it means, im using phpmyadmin: SQL query:

ALTER TABLE `user_info` CHANGE `active` `active` BOOL( 5 ) NOT NULL

MySQL said: Documentation #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 '(5) NOT NULL' at line 1

Mysql Data Type Int(10)
i understand that int is 4 bytes, but what does the (10) means?

MySQL Date Type Vs Varchar In Php..?
What are the real advantages and disadvantages behind using varchar length 15 and populating it with a date using date("m/d/Y") opposed to using a date type field.

When you store a date weather it be of Date or Varchar type the date is the same example:01/01/2002. The only difference I can see is how you search or retrieve data. With SELECT staements it seems to be a piece of cake either way. Just a cariousity question becuase I was told if you are going to search using dates you should make it a date field but I really do not see the difference. In some languages using a Date type field can actually come back to huant you later when you need to take the date out and leave it blank or NULL. (Like VB as a front end with access as a backend).

Dynamically Checking Mysql Row Type
Is it possible to check the types of columns in a mysql resultset so you
don't need to know the type of data returned beforehand?

I'd like to be able to do something like:

if($coltype == "datetime") {
// parse date
}else if ($coltype == "varchar") {
// parse string
}

Column Data-Type For Storing Serialized Array In MySQL?
I'm really not sure - I used BLOB in the past- but the arrays are only a few kilobytes. But VARHCAR only allows 255 characters at most and the arrays might contain many more characters than that.

Form Type=submit Vs Type=image
I'm wanting to create a form with quite a few SUBMIT buttons that use an image rather then the stock (plain grey) button. Everything works fine when I use this line:

print "<INPUT TYPE="submit" NAME="editaction" VALUE=$id>";

I know which SUBMIT button was pressed by checking the value of $editaction in the receiving page. Now if I replace that line with this one:

print "<INPUT TYPE="image" SRC="icon.gif" NAME="editaction" VALUE=$id>";

I no longer get a value in $editaction. I know about $editaction_x and $editaction_y. Is there no way get to the 'VALUE' (from the VALUE=$id part) as well? Am I missing something? Has the variable name been modified to somthing like $editaction_value?

TIA for any light you can shed.

PHP, MySQL And BIT Field
my MySQL table contains bit field

Registered BIT(1) NOT NULL DEFAULT 0

I read records using

$result = mysql_query('SELECT * FROM MyUsers');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$registered = $row['Registered'];

Command "echo $registered;" shows nothing or rectangles depending on the
value, it's ok. But I do not know how to use it in IF statements or so.
Whatever I try does not work. How can I work with such values in PHP?

Retrieving Field From Mysql With Php
I want to select as in the code, an email matching a username, and after I want to make a variable called $email_a to send to this user an email. What is the way to retrieve the email address from the database and insert it into the variable?

$query = "SELECT email from users WHERE username = '$username'";

mysql_select_db($db_name);

$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());

Get Max Value In MySQL Table Field
I have a 2-field table "pageref".

The fields are: "pagerefno" - which is index and primary key, and "url".

I need to find the max value in "pagerefno", so wrote the following code:

$query ="SELECT max(pagerefno) FROM pageref";
$result = mysql_query($query) or die ("Error in query: $query. " .
mysql_error());
$row = mysql_fetch_row($result);
echo row[0];

But this results in a blank screen. I'd be grateful for a steer, here.

How To Get A Field In The Last Row Of Mysql Table.
There is a certain field that I wish to get in the last row (it will always be in the last row, even if I add to the table) of my mysql table. How do I output this? I assumed that I would be using a LIMIT command and a DESCRIBE command, however I looked at mysql.com and couldn't find anything .

Adding +1 To Mysql Field
Is it possible to add +1 to a current value been stored in a int field in a mysql table.

Updating A Field In A MySQL Db
I am having trouble updating a background_id field (integer type) in a MySQL database. What I'm trying to do is use the associated background ID (in the background table) of the background that is selected by the user to assign its value to the background_id field in the member table. PHP code:

Mysql Month_and_year Field
how can i have a mysql field that has just the month and year in it, and so it can be ordered correctly?

What Is Better - One Field Or Eight - Mysql Bit Testing
I have to store up to eight boolean bits of information about an item
in my database.

e.g.

[ ] with restaurant
[ ] drive-through facility
[ ] yellow windows
[ ] wifi factilities
etc...

There are three ways of storing this information in my mysql database
A. add eight fields (tiny integer)
B. add one tiny integer and create a function in PHP that can translate
the number stored into a eight boolean values (the bits)
C. create a table which list
ItemID
Associated characteristics
In C, you will only list the characteristics that are true for the item
listed.

Option B is the most efficient in MySql, but would you recommend it
when creating a PHP website. The problem is that the user needs to
enter them with a nice webform, etc...

Using A Mysql Timestamp Field In PHP
I have a table where one of the fields is a timestamp. I would like to use this field in PHP, and separate the Year, Month and Day into separate variables. For some reason I'm always getting 1970, 01, 01.

Mysql Field List
We would like to be able to get the column list of a mysql Table from PHP code. I know from the mysql prompt we can get it, but we want to generate PHP code
that will retun an array of columns If there is a column descriptor containing
name, size, etc, that would be great. Something that I could loop thropugh an array in
PHP4 and get the names of all the columns in the table as well as perhaps
other column parameters as well. I believe that can be done in CGI, but want to use
PHP4.

Mysql Text Field
I have a DB with a column that is set as Text format. The data stored in the field will be stored in many lines. When I get the data from the DB I want it to display where the line breaks are I'm not sure how to write the script to do this. I have worked withe explode before but there is nothing come at the end of each line to do this with.

Determining Kbs
I want to limit people of uploading pictures larger then 256 kbs to my site.
Is it possible for php to recognize that 256 is 256 kbs and not 256 bytes, or is it necessary to write out the numbers in long ( 262144 )
?

Mysql Field ALTER To Decimal(10,2)
I have a sql statement generated by phpmyadmin where i changed the field value of a table from "float" to "decimal(10,2)". here it is:

ALTER TABLE `BMG` CHANGE `I_PLQ` `I_PLQ` DECIMAL( 10, 2 ) DEFAULT Ɔ'

but i need it to also round the existing values up. for example: 2.4875 to 2.49
but for some reason it rounded it to 2.48, and i don't know how to change the statement so it will round values up for existing values in the field. is this even possible? if not, how would you handle it?

MySQL Date Field Help Needed
I have a Date type in my MySQL table - I'm trying to do a query on all
rows within the last 30 days based on that Date field - I'm having
trouble figuring out how to form the query?

$php_SQL = "SELECT * FROM basics WHERE creation_date =
DATE_ADD(creation_date, INTERVAL -30 DAY)";

Field Number Limitation Into MySQL
Is there a restriction to the number of fields you can work with in a
PHP to MySQL connection? I'd used as many as 15 quite a few times and
now I have a form with 34 fields and can't seem to get the info
inserted into the table even though I'm not getting any connection
errors, etc. Since my method is identical, I'm wondering if there's
some 'rule' I am unaware of.

Can I Include PHP From A MySQL Field In My Page?
I want to be able to include PHP code from a MySQL field in my PHP pages, similar to using include("filename.php" ); so that the code will be run as if it were part of the page. In other words, I want to include() a string instead of a file but the include() function only accepts a file. Is there a way I can accomplish this?

Attempting To Add Time To A MySQL Field From PHP?
In my feeble attempt to keep track of login session timeouts I have the
following code in my login section of my program:

$sql = "UPDATE subscriber
SET _sessexp = 'DATE_ADD(NOW(),INTERVAL 15 MINUTES)'
WHERE _userid = '$_userid'
LIMIT 1";

and when run I see NO ERRORS. However, either the field in the DB doesn't
change OR this expression is generating a value of Ɔ' for the _sessexp
field.

I've tried using the ADDTIME function as an alternative but get the same
results. I'm kind of at a loss.

Any ideas as to why this is NOT behaving as I expect it to?

What I am attempting to do is to take the CURRENT TIME and add 15 minutes to
it and update a field in the database record. That simple!

Text Field As Date (MySQL)
I have a generic table used for many different generic
functions. the fields are mainly varchar's but one of these varchars
contains dates (in the format dd/mm/yyyy) for one reason or another.

My question is, can I perform a query on this table, using date
functions on this varchar field? I.e. search for the latest date?

HTML Inserted From MySQL Field
I am creating a website for a group and there is a linik to a meetings page. This page summarizes the agenda of the meeting. This would be entered into mySQL via a text area or something along those lines. Now, sometimes there may be a power point file they would like to include. What I want to do is create another text area, where the user can put in something like so:

<A HREF="meeting.ppt">BlueTooth Meeting</A>

and when I retrieve this from the database I want this html to be executed. Then that way all they have to do is simply place the *.ppt into the dir via ftp. Will this work?

Problem Getting MySQL Field Defaults
Im trying to get the default values for my table VARCHAR fields but even though i have them set as NOT NULL, DESCRIBE is showing the Default's as NULL. Even if i enter an empty string into phpMyAdmin it still returns NULL. PHP Code:

Inserting Php Code Into Mysql Field
Im trying to display a variable '$downloadimage' which is in my head.php file. I am trying to display this on my page by inserting this code into one of my mysql database fields: -Code: <? echo $downloadimage; ?>

When the page loads there is nothing there (i only have text in the variable at the moment), my html code shows the PHP echo code as text.

Php How To Treat Mysql Field Like A Date?
I have a query that looks like this: (I insert the date created with the php
date function)

$status = "Active";

//(I cannot use the mysql timestamp function for other reason).
$curdate = date("m/j/Y H:i");
$owner = "not assigned";

@ $db_connect = mysql_connect("localhost", "$db_username", "$db_password");
if (!$db_connect)
{
echo "Unable to connect to the database;
exit;
}
mysql_select_db("$db");
$query = "insert into tickets (user, status, loannum, problem, description,
multiples, ticketnumber, ip, office, submissiontime, ticketowner) values
('$user1', '$status', '$loannum', '$problem', '$description', '$multiples',
'$ticketnumber', '$ip', '$office', '$curdate', '$owner')";
$result = mysql_query($query);

I need to pull out the last fifty records from the database, so I use this
query:

$order = $order;
if ($order ==""){
$order = "user";
}

mysql_select_db("$db");
$query = "select * from tickets ORDER by $order";
$result = mysql_query($query);
$num = mysql_num_rows($result);

if I order the tickets by submission time, it orders the items, but not
correctly. It looks like php treating the submissiontime like integer:
example:

12/1/2003 16:51

12/1/2003 16:58

12/10/2003 12:29

12/10/2003 12:36

12/11/2003 07:10

12/2/2003 09:16

Php - Mysql Form Field Generator
does anyone know of a simple function/class that will take config
options: table name and the database connection stuff(or whatever)
It will then print out appropriate form fields to allow editing of a
row?

The reason being is that in the admin section of a website I am
building we are constantly adding columns to a table...It is used for
keeping config options of the site. We do not wanna update the form
each time we add a column.

MySql Question - Can I Add 90 Minutes To An INT Field
All the timestamps in my code are wrong by 90 minutes.

date INT(11),

I'd like to add 5400 to every date field in my database. Rather than do
this in PHP, I'm wondering if MySql has a command that would allow me
to do this directly.

Encrypt And Decrypt A Field Value From Mysql?
how to encrypt and decrypt a field value from mysql? i want to encrpt a password coming from my user before i would insert it to the database.. i used ENCRYPT on my sql statement..however when i checked the field..it was empty.

Inserting Apostrophes Into MySQL Field...
Trying to insert a height input into a MySQL table's field:

<select class='normal' name='height' size='1'>
<option value='5''>5'</option>
<option value='5'1"'>5'1"</option>
</select>

the height variable is then inserted into the database. Looking at the table afterwards with phpMyAdmin shows that it contains only: 4

I'm escaping the apostrophes and speech marks for obvious reasons, but I imagine there's a proper way of doing this. Of course, selecting the height field from the database and echoing it to the page also just shows: 4