PHP :: HTML Inserted From MySQL Field

Randomised Numbers Inserted In MySql
I would like a script that takes a base number of 100 and randomises it into 18 numbers (range of 0-10) which all add up to the 100. Whole numbers please.

Examples:

4,7,9,2,1,6,5,8,10,1,7,3,8,7,2,7,4,9 == 100
7,3,8,7,2,7,4,9,1,10,8,5,6,1,2,9,7,4 == 100

I have no idea on how to create this, anyone have a script or ideas on the code?

The random numbers will fill in fields on a player charactor statistics. The player will have stats, which at the start of the game will be filled in by random numbers. The user will have the option to reroll and the stats will be filled in my different numbers. Once they are happy, they click OK and the numbers are inserted into a database in different fields.

1. The Base Number is the total of the 18 variables, meaning all 18 have to addup to 100.
2. The numbers can be reused as many times as needed.
3. Numbers that are left over have to be added to the variables to make the total equal 100.
4. 0 is not really necessary, so the variables have to be 1-10
5. The idea is the player will click a button which will populate the fields, if the player wants to 'reroll' he clicks the button again and the fields get populated with different numbers.

Mysql - DEFAULT '' Defined Yet NULL Inserted
My database was inserting NULL for empty strings so I changed the field
definition with this query:

ALTER TABLE `myTable` CHANGE `myUrl` `myUrl` VARCHAR( 255 ) NOT NULL
DEFAULT ''

No error was reported following the query and yet I still get NULLs on
insertions.

Can A Field Communicate To A Server And Return Information To Another Field Without Retrieving The Whole Html Code Again?
I´ve got a sql table which has 3 fields.
Their relation to each other is like this example.

| CARS | YEAR | PRICE |
ford 2000
ford 2001
ford 2003
volkswagen 1999
volkswagen 2000

I am developing an ASP web page that modifies a specific registry.
So, it loads the information to some fields, but the user will be able
to change only the "PRICE" field.
I have to create two selects, one for "CARS" and other for "YEAR".
But the "YEAR" field will only contain the correspondent years for each
car the user selects. Example: selecting "ford" in the "CARS" <select>
box, only the years "2000", "2001", "2003" would be automatically
loaded in the "YEAR" <selec> box.
How could i implement it?

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

Checking A Html Field
I have a bit of code that checks an input box for a certain word. This works fine when the word is the only work in it, but not when it contains more than just that word. I want it to work if that word is in it, even if other words are in it. Someone sent this and it didn't work Code:

What Is The Most Secure Way To Prevent Any Html In A Field?
I am busy with finding the most secure way to prevent any html in a field. This to prevent any use of document.cookie or any other bad things. I am using the following and i wonder if that's the most secure way? Or are there other ways wich are more effective?
PHP Code:

HTML Form Field Value And Php Array
I am creating a html form which has 5 html list menu and menu value get store in array after hitting submit button. The value stores in PHP array and then print on same page and then after re checking the value If i want modification then click the edit button and value re store in the same html form.

Here we are not using the database. If it is possible then please provide me the code and if there is any other solution to this problem them please guide me. for above problem please avoid the java script in php code.

Enabling User To Use HTML In A Textarea Field
We have a form in a php file and want to allow the user to use HTML directly in the textarea to format their input. What would be the code to put in for this feature?

Passing PHP Variable Into An Html Text Field
I am working on a flatfile configuration program and I need to read a single record csv file into php and pre-load the values into html text boxes. I have the file reading part working with 6 variables $field1 through $field6. When I am done, I then save the form back to the same file. This allows a configuration file to be updated from the web.

Passing HTML In Hidden Input Field
I just wanted to take a poll to see what the best way to pass a chunk of text containing HTML in a hidden input form element would be. I'm trying to pass the text from one page to another to another in a content management scenario, but the whole thing breaks down when HTML enters the picture. On the page where the value is pulled from the database into a textbox, I'm using:

<?
<textarea cols="45" rows="10" name="blurb">".$blurb."</textarea>
?>

On the next page, the user can review the code displayed as plain text using:

<?
echo(nl2br($blurb));
?>

There are no problems so far. But at the bottom of that page in the form that will pass the variables on to the script that will write the final changes to the database, everything falls apart when HTML comes into play.

<input type="Hidden" name="blurb" id="blurb" value="<? echo $blurb; ?>">

This line made everything fall apart when I put an anchor tag into the text. The closing > made it think the tag itself had closed, and the link text started printing to the screen.

So, what's the best way to handle situations like this. Would I use htmlentities() to get it to the database writing script and the use html_entity_decode() when actually passing the values into the db? Or is there a more sublime solution?

Last Inserted Id
Is there a method to retrive , say the autoincremented value of field of a record, as you insert the record into your mysql database.

Last Inserted Id, Not After Insert
all the examples used mysql_insert_id() right after the insert. but how do i select last inserted id. w/o adding any extra columns. i was thinking about remembering it in a text file or something. but is there a short way?

Record Being Inserted Twice?
I have written which is intended to insert a single record I find that instead it inserts the same record twice (there's no index field). I don't know what to make of it, this is the actual code:

Get The Autoincrement Value Of Newly Inserted Row
Is there a function to get the value of an autoincrement (or any field) back after inserting a new row ?

example
INSERT INTO tbl_name (col2,col3) VALUES(firstname, lastname);
col1 is an autoincrement.

How can you get the value of col1 of the new row back ?

Stoping Empty Values To Be Inserted
let say i have a form asking user to enter its expertise....i have given him three form fields to enter those...right now i have put the insert query for every form field and even if he enters in two of them .3 records are entered in the DB , one of course emtpy..how could i code so that only filled form fileds should be inserted.

Automatically Inserted Into A Table Cell
I have a php file which displays one line of text read from a database. I want this one line to be automatically inserted into a table cell in an html file so that when I update the database, it automatically updates the html (via the php)..

Session Id Being Inserted In The Wrong Place
I have a link that must have a GET variable with spaces in it. PHP keeps
inserting the session id right in the middle of my links. I've tried
replacing all spaces with %20...it still sticks it in the middle.

I didn't write this by the way...the links are coming from another site and
my server is inserting the session id into it.

Here is what I'm talking about:

http://mysite.com/page.php?sSQLPreBuiltWhere=L.PROPERTY_STATE_ID%20= %20'FL'%
20AND%20L.NODISPLAY_IDX%20IS%20NULL%20%20AND%20L.N ODISPLAY_OWNER%20IS%20NULL
%20%20AND%20L.VOW_ENABLED_LIST_FIRM_ONLY%20IS%20NU LL%20%20AND%20L.STATUS_COD
E%20=%20'A'%20AND%20L.IDX_ENABLED%20IS%20NOT%20NUL L%20%20AND%20%20L.MLS_ID%2
0IN%20('midfl','newsmyrna','tampa','daytona')%20AN D%20L.CITY_ID%20IN%20('Y21
688')%20AND%20L.PROPERTY_TYPE_CODE%20=%20'S'%20AND %20L.SALE_PRICE%20&sessid=
4bc1f9c2fcbc2f78503cfddf93bc8d5f>=%200%20AND%20L.SALE_PRICE%20<=%20999999999
99

You can see the sessid variable (toward the end) right in the middle of the
sSQLPreBuiltWhere variable. I can't turn off transid...the entire site
relies on it.

What is going on here?

What Invisible Char Can Be Inserted In A Text File?
How to and what invisible char can be inserted in a text file? I want to use such invisible char to be a seperater in the plain text file on Unix platform.

Form Data Inserted Into A Text File
I am wondering if it would be possible to create a form and using php have the form data inserted into a text file. The data would have to be inserted in a given way.

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.

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?

Determining Type Of MySQL Field.
I have a problem of migrating a database from one host to another.
I can't do a dump on the source server. The only access I have is thru
queries. So it looks like I'm going to have to query all the
tables and insert to the destination.

I'm trying to come up with a general solution to this problem which
uses queries to determine the structure of the source db, and create
the tables on the destination, which I've already done using the nice
"show create table" query syntax combined with the PHP
mysql_list_tables() function.

The problem comes with doing the inserts. It looks like I'm going to
have to do a "select * from table" thing and then loop thru the
recordset doing insert after insert.

Q: Do I have to do it that way? Is there a way I can insert all the
records from source to destination more efficiently?

Q: How can I determine the type of value in a field returned from
a query? PHP's is_string returns true on ALL fields regardless of type
used in the database itself. I need to know whether to wrap the values
in quotes or not before I insert them.

I'd like to be able to at least fetch a record and insert the record
without having to process it. I'd like to grab the whole table and
insert it, but haven't a clue how to do this.

Q: Is there some kind of select/fetch that I can do that will give me a
record ready to insert i.e. with commas and quotes?

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

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

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