PHP :: Can I Include PHP From A MySQL Field In My Page?

How To Include A Page
I want my site to have a template so I'll use this format:
http://www.site.com/index.php?page=bio
I want that to mean that it will just include the bio.php page into the middle of index.php, which will be like a template. I hope you guys can understand this. This is my question. Is there a way to only let people see bio.php if it's included in index.php and NOT let people just go directly to http://www.site.com/bio.php?

PHP/SQL Pass Value To Field On Linked Page
I have setup an sql table containing project data (job no, description, date and auto-number id) which displays in rows on my main page. Next to each project is a link which a user can click to submit their details to show interest in that particular project. When they click this link they are taken to another page with a contact form, but I need to automatically show the job no of the project they selected in this form. I have successfully got the job no for the 1st record in the table into the field but need to make it dynamic.

Mandatory Email Field On A Contact Page
I've used Smarty to make a PHP-powered Contact page on a web site. At the moment it works fine and displays fine, but I'd like to redirect the user to an error page if they forget to include their return email address. Here's the complete code from the PHP page: Code:

Include Page Into A Variable
I'm trying to automatically generate an email that includes information from a few different pages on my site. I'm creating a variable $message to contain the email output.

I would like to set the variable with html and then include a webpage inside the variable then echo the variable $message. i.e.

$message = "
<html>
<body>
Stuff in here but somehow include('cal_events.php')
</body>
</html>";

mail("someone@somewhere.com", "Subject", "$message","header info"); Can I get the informaion from an included page into the $message variable?

Include Php Page With Variable
I don't know if this is possible but I want to include a page with a variable. Like:

<?php include('somepage.php?variable=whatever');?>

How ever this gives me error (cannot be opened)Is this possible?

Using An Include Header Pushes My Page.
When I try to use the "include" to add in a header file, php put my header flush left and the all the html flush right. The footer seems to work fine but for some reason I cant get the header to work right any ideas? ....

Finding What Page Wanted To Include
guys say if I include("anyfile.php") into a file. Is it possible for me to
access the calling page from anyfile.php.

Can I do something like this for instance::

if callingpage == "newauthor.php"
then mysql(INSERT into author.....)
else
mysql(INSERT into content...)

Page <title> From Include Variable?
I have something like this:

<title><?php print($pagetitle); ?></title>
<body>
<?php include("folders/my_include.php"); ?>
</body>
</html>

and my_include.php contains the value to the variable ($pagetitle). How do I
get the value before the code for the <title> is written. This is just a
basic example I used to try and put across my question, my site has a whole
bunch of includes dynamically generated from user input. I'd just like to
get the <title> to change according to a variable in the includes......but
Im stuck?

I should say also that all my includes have includes themselves, they
include a html template. So placing <?php include("folders/my_include.php");
?> before the title tag won't look very good :)

Clearing The Input Text Field After Submiting The Form To A New Page
I have a page with a form with an input text field ... and when a user types his/hers ID ... and submits the form - his/hers page opens in a NEW window .... but the value (ID) that was written in the original window remains.

I want to make sure that the form input field on the original page becomes "invisible" - by refreshing/reloading the original page or just by clearing the input form after submission.

For now I have put in a meta refresh tag in the head of the html file ... but that is not the solution ... becouse I only need a one time refresh/reload of the page ... and this is to happen right after the input text value is being submitted.

Open Popup Window When Page Is Loaded If A Field Is Populated
Would it be possible to open a popup window on loading the instruction page but only when the critical information section of the page contains text?

The popup window could either contain the contents of the critical information section or just a visual warning that such information exists on the main page.

I have a pretty good knowledge of VBA but sadly my knowledge of php and javascript is very limited.

Search Results Showing An Include Page
I have a page index.php which includes different templates based on a passed URL variable through the include() function. My problem is that I have the files saved as temp.inc.php files. Search engines are returning the include page as a result and then the user is directed to a new window with just the include page displayed. Any ideas on how to get around this?

Page-refresh Problem When Using Include(file.txt)
Suppose you have webpage called fileA.html which contains a line to include("fileB.txt"). When you load the page, the server inserts the contents of B into A and everything is good.

Next, you modify fileB and re-load the page. The browser looks at the file it is told to re-load, i.e. fileA.html, and since fileA.html has not been modified the browser uses a cached version of the page that does not include the new fileB mods. Hence, the newly modified page does not appear to a user to have been updated.

Is there any way to get around this, i.e. to force a full re-load each time a page is accessed? I know this isn't really a php question as it's more a browser than a programming issue, but I warned you about that up-front, don't say you didn't know what was coming.

Dynamic Include Page Post Data
I have a index file which carry content as included page. Its take parameters like this (index.php?page=katlist). So I am trying to send data from form inside page as (index.php?page=katlist&searchterm=blabla) but I dindt success.....

Send Email Include Page With Dynamic Data
I want Users to fill in from. data go's to MySQl send email to user and myself containing "form tekst.

Adding Php Code Or To Include A Page With Php Code Into A .tpl Page
how would i do this, i am intergrating a phpbb forum system into my site!

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.

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?

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

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

Show All Fields After A Certain Field In Mysql
Is there a way to show all fields in a table after a certain field, lets call it "position". If so please provide the code.

Onclck Update Mysql Field?
i have a script (below) when a user clicks on a link i want it to update a field in a database +1 so that i can see how many times it is clicked. but i cant get it to update the field what am i doing wrong? Code:

How Do I Select The Last Field Of A Mysql Table ?
how do i select the last field of a mysql table ?

Dropdown Populated From Mysql Field
I'm looking to create a drop down box that displays a field from a a mysql DB so that i can list all the names and when I select a name from the list it selects that record.

Post Two Values Into One Mysql Field?
I'm posting data into a MYSQL database, which works fine using the schema below and the php form below:

cms_test
story_id (int 3)
web_date (date)
web_time (time)

Code:

Selecting The MYSql Field W/ The Biggest #
Alright. I have searched and googled and cannot seem to find the answer. Perhaps I am not wording it right. But here's the issue.

Table: stores
Location1
25

Location2
10

Location3
15

How do I write a MySQL query to find the largest # (in this case is location1)

Reading MySQL Data In A Form Field
i am in the process of building an admin page for a site. Most of my site data is being held in MySQL and being pulled using PHP. The problem I have is while trying to build an Admin form to change data in MySQL, I want to have the data that is currently in the table be automatically put into the form field, so they can see what they are changing before they change it, or so if they do nothing it keeps the same data in it. My code is as follows: