Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    PHP


SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Displaying Full URL Address From Mysql DB


Hi all

I am having a problem, displaying a field form my mysql db.

the field is a text varchar(80) containing url's (web addresses more importantly).

the issue is, when a user enters into the db an address without the 'http' suffix on the start of the url, I try to display it.. but obviously the browser then renders it as a file to the root directory when actually its an entire new url. Did I explain that good enough?




View Complete Forum Thread with Replies

Related Forum Messages:
Full URL Address In A Variable
I have a website where I invite people to write a review about a product. When a person wants to write a review, I ask him either for LOGIN or REGISTRATION, after successful LOGIN or REGISTRATION, I want him to show the page where he was before the LOGIN or Registration.

Let say my URL address looks like this

"http://www.anydomainnamexyz.com/directory/hardware/product.php?pid=1&brand=Imate&model=Jam&ram=64"

I am confused how to catch the whole URL into a single variable called $page_back, so I can send back the user to the above page after successful LOGIN or REGISTRATION.

View Replies !
How To Get Full Address Of The Website Dynamically?
how to get full address of the website dynamically?
like www.yahoo.com/op/guy/123/
using server var($_SERVER).

i just want path till current working dir from www.yahoo.com/op/guy/123/ page.php i don't need it.

View Replies !
$_SERVER['HTTP_REFERER']; That Will Display The Full Address Path.
Which predefined variables is it that will let me just echo the domain of the person who is visiting referred from? I know I can do this:

$_SERVER['HTTP_REFERER']; but that will display the full address path. I want to only be able to see this:  www.domain.com. I used to know how to do this; but I have forgotten how. Any body remember which predefined variable this is?

View Replies !
Problem Using GET And Displaying Value In Browser Address Bar
I have constructed a PHP generated HTML layout, which on POSTing the
menu option the user selects, calls the same PHP code / page which
generates the HTML page and GET's the correct SHTML page into the design
(kind of like frames but without the annoyance of frames).

Whilst for all other pages I have on my layout the correct page is shown in
the browsers address bar (and hence if I copy and paste that URL into the
browser the correct page is generated [like
www.abc.com?&page=interesting])... I cannot do the same with the FORM code
on one of my pages.

How can I show the option that was picked in the FORM in the URL (something
like www.abc.com?&track=a01-t01), baring in mind that the PHP code that
inserts the page is GET'ed somewhere in the middle of the PHP generated
HTML page.

The SHTML

<FORM method="POST" action="../../index.php?&page=track" name="myform01">
<select name="album">
<option value="a01-t01" SELECTED>Track 01</option>
<option value="a01-t02">Track 02</option>
<option value="a01-t03">Track 03</option>
<option value="a01-t04">Track 04</option>
<option value="a01-t05">Track 05</option>
</select>
<BR><BR>
<input type="submit" name="submit" value="Go get the lyrics">
</FORM>

The PHP the above SHTML calls (within a PHP generated HTML page)
The bit that deals with the above code is the GET['page'] == album
section...

<?
if ($_GET['page'] == '')
{
include ("index2.php");
}
else
if ($_GET['page'] == album)
{
echo $_POST['album'];
include ("/html/lyrics/".$_POST['album'].".htm");
}
else
if ($_GET['page'] == index)
{
header ("Location: /index.php");
}
else
{
include ("/html/".$_GET['page'].".shtml");
}
?>

View Replies !
How Do I Delete A Full Row In Mysql ?
how do i delete a full row in mysql ?

View Replies !
Full Text Search ( Mysql )
I was searching the sql man , for some good ways to search a mysql db. so i found that Full text search the best way is to go becease LIKE just gives to mutch output.PHP Code:

View Replies !
Full-text Search Mysql
I building a little site using PHP and mysql. Now I want to make full
text searches on some columns in one table. The problem is that I have
25 colums in the table that I want to put at full-text index on. I
belive there is a limitation of 14(?) colums. What is the proper way
to handle this?

Reading about full-text indexes, do I have to make a "repair table..."
after each time I insert data in the table the will be included in the
indexed columns? If this is the case I must repair the table every
time I insert anything?!

I am using "DBDesigner 4". How can I see in my table that it is a
full-text index. Seems like it appears as a normal index in my data
definition as well as in the reversed engineered graphical
interface.

View Replies !
MySQL Full-Text Searching
I am reading this article that says by default, the ft_min_word_len is 4 characters and the ft_max_word_len is 84 characters. I don't have access to the MySQL configuration file, is there a way to change the full-text word length settings like using .htaccess?

I access my MySQL using phpMyAdmin, which is shared with a bunch of other users. So I have no rights to make modification whatsoever. Is there a way to modify just my table in there?

View Replies !
Full Stops In Mysql Queries
I am using Mysql to search for domains in a database. For example: PHP Code:

SELECT COUNT(*) FROM domains WHERE domain = 'phpbuilder.com'

The problem is that the query will always return 0 whatever domain I input (that is present in the database). Unfortunately I built some more complicated parts of this script before testing the query itself so it took me a little while to figure out the problem was because of the full stop. If I remove the full stop in the database and use domaincom in the SQL query then the query works fine.

View Replies !
Showing Full 2d Array On Screen From MySQL
I have successfully created a MySQL database, and inserted a table "65chain" into it.

The table has 10 columns, including the primary key column Drop_1, and 6 rows. The Drop_1 column is indexed at 600, 800, 1000, 1200, 1400, and 1600. The table is representative of a series which will have varying numbers of rows and columns.

In phpMyAdmin, I see the 2d array I would like to see eventually on my web page, when I select the SQL tab and enter
SELECT * FROM `65chain` WHERE Drop_1 is not null

Great. I am now creating my script.

So far I have:

View Replies !
Full HTML Pages In MySQL Page?
I'm working on a small script to put full html pages in a database and then retreive the data to show on the page. The problem is that VARCHAR can only go up to 255 characters I believe. I also tried TEXT, but then I get a few columns like 'Field','Type','Function','Null' and 'Value'.

I don't know what to do with the other columns. I also can't seem to be able to put data in the table with a script.

Can anyone tell me what the best way is to do this and how to insert data into it with PHP? And are there any problems when I try to display it on the page (I read somewhere that special characters are being left out sometimes).

View Replies !
MySQL 5.0, FULL-TEXT Indexing And Search Arabic Data, Unicode
MySQL 4.0, FULL-TEXT Indexing and Search Arabic Data, Unicode

[This version has a couple subtle edits from the orginial I posted
on mailing.database.myodbc - I'm cross posting here on this
topic/subject related newsgroup]

I was wondering if anybody has experienced the same issues
challenges I'm experiencing I'll describe shortly. Once
resolved some fascinating and powerful multi-lingual
apps incorporating non-English/latin character sets can be
realized by many developers.

I have a Unicode utf8 English - Arabic - Hebrew - Greek (and
several other languages) database in Microsoft Excel. I KNOW
that it is Unicode utf8 data because MySQL tells me it
recognizes the encoding as such but not in the context I want.

Allow me to explain ...

I can search the Unicode utf8 encoding with no problem in
Excel. While in Excel I highlight a complete word or a
partial string of an Arabic word copy it to the clipboard
(i.e. memory). I then do a find and the process is the
same successful result as if it was an English string.

MySQL 5.0 is supposed to handle Unicode utf8

I created a MySQL database I named: languages

CREATE DATABASE languages ;

and I implemented the following command on a MySQL
command prompt:

ALTER DATABASE languages DEFAULT CHARACTER SET utf8;

No problem (so far) MySQL seemingly recognized utf8 and
accepted it. My understanding is with the ALTER command
the tables I create against languages will be utf8.

I now created a table I named mainlang which denotes it
will be the main table for my languages.

mysql>CREATE TABLE mainlang
->(
->langNumID varchar(30),
->colB varchar(30),
->colC varchar(30),
->primary key (langNumID, colB)
->);

Again so far no problem: Table successfully created.
My third column 'colC' is where the Unicode data
will be stored.

I now attempt to import the database from my
Excel file into my MySQL database as follows:

mysql>load data infile 'c:arabicdictionary.csv'
->into table mainlang
->fields terminated by ','
->lines terminated by '
'
->(langNumID, colB, colC);
ERROR 1406 (22001): Data too long for 'colC' at row 1

So what to do? I did a search and found other
people seemingly had the same problem and someone
suggested:

ALTER DATABASE languages DEFAULT CHARACTER SET cp1250;

I dropped mainlang, recreated it, redid the load and
Lo and behold ... it seemed to work. No Data too long
error occurred and when I did the following query:

mysql>select langNumID, colB, colC
->from mainlang
->where colB = &#55617;&#57074;'

I see colA have a correct numeric value, colB a
correct numeric value (4994) and for colC a string of
unintelligible characters with diacritical marks,
oomlats etc. which I know is the cp1250 encoding
interpretation of the Unicode utf8 data which is
similarly unintelligible in its own regard.

Now what I try is: do a copy of the obscure colC
cp1250 character string into the clipboard/memory
and then do the following tweak on the original
select statement to see if I can search on the
(now) cp1250 character string:

mysql>select langNumID, colB, colC
->from mainlang
->where colc = 'paste of the cp1250 character string'

The computer would not allow a paste unless I pressed
the escape key. On initiating this select command
I got an empty set (no match)

My questions are:

Has anyone been successful creating a Unicode utf8
MySQL database that accepts Arabic?

If yes, how did you get around or not encounter the
Data too long issue?

Have you tried the cp1250 (or cp1251 - same mechanics
same results) work around as I have? Are you
able to search the cp1250 character string (my colC)?
If yes, how did you successfully manage to do it?

Lastly, if I take the cp1250 encoded string and paste
it into Excel ... I can string search the cp1250
encoding with no problem.

Also, here's how I know my Unicode utf-8 data is
correct apart from my own manual cross-referencing
and being recognized by MySQL in some respect:

When I copy the Unicode utf8 encoding and try to
paste it into the select command to see what would
happen I get the following error:

ERROR 1257 (HY000): Illegal mix of collations
(cp1250_general_ci, IMPLICIT) and
(utf8_general_ci, COERCIBLE) for operation '='

So what I have here is a situation where MySQL
is recognizing Unicode utf8 encoding but not
from the respect of packing a table!

Go Figure ...

View Replies !
Full Text Search After Upgraded Mysql To Lastest Version Not Working
i upgraded mysql to lastest version one of my query worked right in previos version but it doesn't work now. i have a table with "test" name and 4 fields (id,title,intro,content)
these fields are full text: Code:

View Replies !
Gaining Access To How MySql Parses Text For Full Text
I want to gain access to the function or process MySql uses to parse words and phrases for Full Text searching. Here is an example.

If the user inputs...

Milan in history

MySql will search for milan, history, and milan history. Is there a way to extract just the combination of terms MySql uses to search the db without the stop words? Stop words are automatically eliminated from the search request unless the user encloses a phrase in quotes.

What I am trying to do is develop a script to highlight found search terms and phrases. I can explode a phrase into single words but if I do that the stop words would be included in the array. If there is some way of getting into the parsed words or phrases MySql Full Text actually uses to search, I can use each of those combinations as a keyword in my highlighting script.

This request is about searching for the code or any code related to the questions involved.

View Replies !
Address Labels Using Php | Mysql | Fpdf
i'm looking for some script which would export address labels from a
mysql db to pdf ...

There's an exapmle, but i'm not able to convert it for using with
mysql ... can anybody help?
.......

View Replies !
Changing Localhost IP Address For MySQL
I am moving a bunch of my database sites to a new server. I have to keep the databases hot durring the switch. Is there a way to change the IP address of 'localhost' to another IP address when you connect in PHP to MySQL? That way I wouldn't have to change 'localhost' to the new IP address on every script.

View Replies !
Php - Mysql - Search On Partial IP Address
I have a database that stores all the ip addresses of the machines on my network. One table consists of the ip address itself, and the second field is an ip_number (converted via the ip2long function in php).

I could not find a way to search on the normal, dotted quad IP address notation, hence the ip_number field. I can easily search on this field when using the entire IP address, but would like to allow the user to enter partial IP addresses.

Any ideas on how I can do this when I need to convert the IP address to an IP number to actually do the search?

View Replies !
Host Address For Mysql Server
My mysql database resides on the server. I have to connect it by navicat or other conversion tool. But there is some problem of host address. It shows the incorrect host address or port no. It seems that host address is wrong. What may be the host address of mysql server.

View Replies !
Modifying Data In Address Book With PHP And MySQL
I'm working off a tutorial on building an address book with mysql and php. For a reference you can find it here:

http://php.about.com/od/finishedphp1...dress_book.htm

I'm having no problems with creating the database in sql, I've entered some sample data into the table with phpmyadmin, and the code below will correctly display the info on the page.

The problem I'm having is modifying the data. Whenever I click on the add contact, edit, or remove links, nothing happens. Sure, the url in the address bar will change from www.mysite.com/address.php to www.mysite.com/address.php?mode=add when I click on the add contact link, but no form appears so I can input data. Code:

View Replies !
Use A Script That Has A Mail() Function And The Address Is To An Address Of The Same Domain As The Site
I just moved my php site to a new host. The previous host and the new one are both running the PHP 4.3.11. The sendmail path is the same.

If I use a script that has a mail() function and the address is to an address of the same domain as the site, it works ok. If it is to an outside address, it disappears. Though it returns it was a successful send.

View Replies !
Secure Php Mail Script That Will Select The Appropriate Email Address From A MYSQL Table.
I need a reasonably secure php mail script that will select the appropriate Email Address from a MYSQL Table.

View Replies !
Mail() Bounces To Server Address Instead Of From Address
All email sent from php mail() that bounces is being returned to my servers admin email address instead of the "From" or "reply-to" address.

What needs to be put in my header code to ensure that this does not happen?

View Replies !
PHP, MySQL And Displaying JPG Images
I got a script that is supposed to display a JPG image from the database, but, instead of displaying the image, it displays the JPG binary output with those alphanumeric characters.

Coule this be a Header MIMI type problem in my script?

View Replies !
Displaying A MySQL String Using PHP
I've got a multiline string of data held in a MySQL database.

I can extract the data using PHP and display it on the screen but when I do so, the string loses all of its formatting (i.e. The carriage returns and line breaks get lost and the string is placed all on one line).

How can I display the string correctly without using a <pre> tag and without putting the string into a <textarea>.

View Replies !
Displaying MySQL Tables
I am creating a database that allows anyone to fill out a form and be added to the MySQL database. My problem is, I can't see who has been added. Could anyone please help me with the PHP code for this? I have tried the following: PHP Code:

View Replies !
Displaying Mysql Querry
I have problem displaying this mysql table from datbase: I need to show column hrt1 from table hrt order by id

CREATE TABLE hrt (
id int(11) NOT NULL auto_increment,
hrt1 varchar(255) NOT NULL default '',
hrt2 varchar(255) NOT NULL default '',
hrt3 varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;


I tried this but it isn't working: PHP Code:

View Replies !
Displaying An Image From A MYSQL DB
Can someone point me in the right direction as to display an image in PHP that is being stored in MySQL? Basically I know how to store the image in MySQL, but getting it to display on a web page is what I am having trouble with.

View Replies !
Displaying The Top 4 Mysql Database's
I was wondering how I would Display the top 4 mysql database's? I was thinking of using the switch function but I don't know what the variable would be.

View Replies !
Displaying Text From MySQL
I am working on a very simple news page for a website. I've setup a simple form that writes news to my database and the data is then displayed on my news page. I have gotten everything to work successfully but the content in the article loses all its paragraph formatting when I try to display it. I can use break tags to make the formatting show up but there has to be an easier way.

This is the code I am using now, which I found on a tutorial somewhere and then tried to modify to work for my site: Code:

View Replies !
Error In Displaying MYSQL
I am having this problem at the moment with this script below. The probelm is that it keeps on chucking out an error:

QuoteParse error: parse error, unexpected $end in index.php on line 559
Online 559 is just the close of the html tag outside of the php. Code:

View Replies !
Displaying Mysql On Web Page
i am archiving data in mysql, each has an id number from smallest (oldest) to largest (newest), by the week. on my website, i would like to display only the newest week and the week before it. (or the weeks with the largest ids). how can i do that?

View Replies !
Displaying MySQL Version Using PHP, How?
how to display MySQL's version using php script? I know i did this before the problem is i can't recall it anymore.

View Replies !
Displaying Results From MySql
poss to display only 1/3rd of a feild in db. My feild is called Description and has the text would only like to show part of this results in a quick veiw page.
can i add somthing to this code?

echo '<p>' . $row ['discription'] . '</p>'

View Replies !
[PHP/MySQL] Displaying Articles =/
I've encountered a problem while coding PHP: The users on my website have their own page where they can post articles. They have the opportunity to publish the articles for everybody (status=4) or publish them only for friends (status=2).

Now, what I want is that the script automatically detects whether a user (who is logged in by cookie) is a friend of the author of the articles he is viewing. If so, the articles that are marked by the author with "only visible for friends" must ALSO appear among the other articles :). Code:

View Replies !
Displaying MySQL Results
Normally to loop my results I use the while statement (or whatever it is officially called) and that works perfectly except it only does it in a single column within a table. I would like to display the results in more than one column in a table.

Example:

XXX
XXX
XXX

(X's signafying a value from the db). I have no idea what this is called so I don't know what to search for in search engines or forums.

View Replies !
Displaying MySQL Rows
I am trying to create a code that will display all records in a database table if there are any. If there are none, I want it to display "No Events"... This is the code I have;
PHP Code:

<? if ("$row_events['id'];" != "") {
          echo ("<td width="20%"><?php echo $row_events['date']; ?></td>
          <td width="80%"><a href="viewevent.php?id=<?php echo $row_events['id']; ?>"><?php echo $row_events['title']; ?></a></td>"); }
          else echo("<th colspan="2" scope="col">No Events</th>");?>

The error I get is;

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

View Replies !
Displaying Mysql Records:
I wondered if anyone could offer some guidance, I trying to write a php script to connect to a database, and display the records in a table. I found the code here in a php4 text, and when I run this directly through the php intrupeter, the line Successfully connected is display and 4 as the number of rows. The database table we connect to, has three field username, firstname, surname.

When I tried a while loop, to display the data in a table. No values were displayed. Could anyone possibly demonstrate how to display the username, firstname, surname values in a basic table?

<?php
function db_connect(){
global $MYSQL_ERRNO, $MYSQL_ERROR;

$link_id = mysql_connect("localhost","user04", "password04");

if(!$link_id){
$MYSQL_ERROR = "Connection failed";
..................

View Replies !
Displaying Items From MySQL
I just noticed that there is a problem with it. When I search for 'wheels', there are 200 results. When I search for 'wheel' there are 400 results. I have both words, wheel and wheels, in my keywords table.

Is there something I can do in my query SELECT statement or my while loop to eliminate duplicates? Code:

View Replies !
Displaying MySql Data
I dont know if this has been addressed before, but I am trying to display my MySql data in a table format. I can get the data out from a query just fine, but I need to know a way to neatly arrange the displayed data in nice columns under header titles for each data field. i have an html table with the headers in it, and would like to stack up the subsequent query's in line under the headers.

View Replies !
MySQL Constantly Displaying
This is something weird that I can't work out. I am developing something using a localhost installation of Apache2, MySQL, PHP on MacOSx. Within my scripts, anytime I call a 'select * from xxx' the first item is lost and not presented. For example, if I do a 'select * from xxx' then the first item by the primarykey is missing, if I spcify a order by then the first on is lost in that so it's not the same thing that's being dropped. mysql_num_rows($result1) shows the correct number I am expecting, but when a while script is used to print them, one is always missing.


View Replies !
Displaying MySQL Column Names Using PHP
I'd like to be able to display the column names of a table on a page. Is there a way to read that information in using SHOW? And then to display that information again? Or would I have to store these names in a seperate table and display these values?

I tried this, but it sure didn't work:
$result = mysql_query ("show columns from industries");

print ("<table>");
if ($row = mysql_fetch_array($result)) {
do {
print ("<tr><td bgcolor=#cccccc>");
print $row["field"];
print ("</td><td bgcolor=#cccc00>");
print $row["type"];
print ("</td><td bgcolor=#cccc00>");
print $row["null"];
print ("</tr>"); }
while($row = mysql_fetch_array($result)); }
else {print "Sorry, no records were found!";}

print ("</table>");

View Replies !
Displaying Text Pulled From A MySQL DB
I have a web edit, delete and update script set up. its all working pretty much as i need except for one thing, the editing function.

When an admin clicks edit beside an entry that page is resubmitted using $PHP_SELF and a variable is set. A check is then carried out in each form field to see if this variable is set, if it is set then a query is carried out and it enters the value of the query result for a table field as the value for the form field. You can see this in the code below.

My problem is this: when the values of the DB are echoes out into the form fields they dont display correctly or they just display the first word until they reach the first space and then nothing else. PHP Code:

View Replies !
PHP MySQL Query Not Displaying Data
I am having some problems with a database query that I am trying to do.
I am trying to develop a way to search a database for an entry and
then edit the existing values. Upon submit, the new values are updated
in all corresponding tables (the function of the pages in question).
However, on the page that does the DB update, I also want to do some
checks on the data before performing the update.

Now, the problem that I am running into is that when I don't update the
primary key field (keyid) the page is running into the section where it
displays a message that the keyid already exists. This only happens
when the keyid on the previous page is not changed.

Upon troubleshooting the problem I found that the very first SELECT
statement does not seem to be returning any rows despite the fact that
the statement, when run on the SQL server, returns exactly one row. If
any could provide some assistance with this matter, I would be most
appreciative.

Code:
<?php
session_start();
header("Cache-control: private"); //IE 6 Fix

//continue if authenticated
if ($_SESSION['auth'] == 1)
{

//get variables from post
$keyid = $_POST['keyid'];
$username = $_POST['username'];
$corpid = $_POST['corpid'];
$usergroupname = $_POST['usergroupname'];
$oldkeyid = $_POST['oldkeyid'];
$oldcorpid = $_POST['oldcorpid'];
echo("Keyid: $keyid");

// Connect to MySQL
mysql_connect ("address.com", "user", "pass")
or die ('I cannot connect to the database because: ' .
mysql_error());
//select database on server
mysql_select_db ("seniorproject");

//SQL Statement
$sql = "SELECT keyid, corpid FROM users
WHERE keyid='".$keyid"'";

// Execute the query and put results in $result

$result = mysql_query( $sql )
or die ( 'Unable to execute query.' );
echo mysql_result($result,0);

// Count number of matches and print to screen
$numrows = mysql_numrows( $result );
if ($numrows == 1)
{echo(" SQL Query: $sql");
$result_ar = mysql_fetch_row($result);
$result_ar = mysql_fetch_row($result);
$dbkeyid = $result_ar['keyid'];
$dbcorpid = $result_ar['corpid'];
echo("<br> CorpID: $corpid <br>");
echo(" DBCorpid: $dbcorpid <br>");
echo(" DBKeyID: $dbkeyid <br>");
if($dbcorpid == $oldcorpid)
{
//If this condition is true, then KEYID has not changed. Execute
code

// Formulate the query

$sql = "UPDATE users
SET corpid = '".$corpid."', username = '".$username."',
usergroup = '".$usergroupname."', keyid = '".$keyid."'
WHERE keyid = '".$oldkeyid."'";........

View Replies !
[MySQL] PhpBB Not Displaying Topics
Yes, I know there exists a suport forum for discussion about problems
with phpBB, but noone there seems to know the solution to my problem...
so I ask here.

I've been messing around with phpbb_ tables in my database... I'm trying
to convert a incomplete Ikonboard forum to phpBB, and had to do lots of
stuff manually (which is fine as I'm familliar with MySQL). And, now I'm
stuck and can't figure out the problem...

The forum in question is:
http://fly.srk.fer.hr/~nick/remorkeri/phpBB2/

The situation is this:
a) from the outside:
On index.php I can see numer of topics, number of posts and info about
last post. On viewforum.php I get "There are no posts in this forum.".
b) from the inside:
select post_id, topic_id, forum_id from phpbb_posts;
returns a whole bunch of everything, so this table seems OK.

select post_id, post_text from phpbb_posts_text;
same thing.

select topic_id, forum_id, topic_title from phpbb_topics;
same thing.

So, form the inside everything seems nice. So, why viewforum.php doesn't
see the articles? I tried to figure out the PHP code, but couldn't,
haven't got all the time in the world...

View Replies !
Problem Displaying The # Sign From Mysql
I have a "#" sign in one of the fields of mysql db. I tried using htmlspecialcharacter(), htmlentities() and stripslashes() to have it properly displayed, but none of them work.
How does one display the # character in PHP?

View Replies !
Displaying Inline Images Thru MySQL
I run a board that runs the Invision Board program. We are a photography forum, so lots of images get posted. IPB places all uploaded images and the GD-created thumbnails in one directory... right now there are over 40,000 files in there. We would like to archive the older images in a different place, so I devised a script that uses a coped table from the database with all rows without a image post deleted.

The problem I have is that the database cross-references the original filenames with the new names they are given on the server. DSC_1000.JPG would get renames to "post-107-12382148343984.jpg" for instance. We would prefer to keep those "post" names for security, but would like to duplicate the method IPB uses to display the images with the file saving as the original (DSC) filename.

Dissecting the IPB code returned nothing I can use nor figure out without a complete re-write of my script. So how would one go about opening a file depending on the query string, and place the real name of the file into the header dynamically? I have tried the following, and other derivations, but keep getting errors: PHP Code:

View Replies !
Problem Displaying Pdfs From Mysql
I have uploaded a pdf file into my db and am trying to display it
again here is the code i have used (at the moment it is just displaying
the binary file's code as text in a html page:

<?php session_start();
include("connection.php");

$query = "SELECT resource, resource_name FROM tblresources WHERE id =
&#393;' ";

$result = mysql_query($query) or die(mysql_error() );

$row = mysql_fetch_array($result);
$content = $row['resource'];

header("Content-type: application/pdf");

echo $content;

?>

//am i missing something else to go with header to make it be read as a
pdf file?

View Replies !
Displaying The Number Of Featured Ads In Mysql
I was looking for away to have it display how many featured items are in a table then display that number in the admin next to the featured item check box that way the person know how many items are currently featured.

View Replies !
Displaying International Characters From Mysql
I have a database with international characters and they display perfectly in phpmyadmin. However they come up as a "?" (question mark) when I try to call them in my pages. I have the encoding set to:

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

which is the same as phpmyadmin. What am I doing wrong?

View Replies !
Displaying A Pdf Coming Out Of A Mysql-db In A Frame
I have a mysql-database with some pdf in it.
I can send them to a webbrowser using this script:

<?php
//output.php4
$sql = "SELECT * FROM tbfiles WHERE tbfiles.ID={$id}";
$result = mysql_query($sql);
$dateien = mysql_fetch_object($result);
$daten = $dateien->Inhalt;
$name = $dateien->Dateiname;
$groesse = $dateien->Groesse;
$typ = $dateien->Typ;

header("Content-type: $typ");
header("Content-length: $groesse");
header("Content-Disposition: attachment; filename=$name");
echo $daten;
?>

My problem is that I get a download dialog where I want to save the pdf but
I want to open it in a fram or iframe like this:
<iframe src="./output.php4?id=129" width="100%" height="400"
name="outputbox">
where id=129 indicates my document.

I get the correct result in Internet Explorer (but not in Opera) if I change
the script like this:

header("Content-type: image/jpeg");
header("Content-Disposition: inline; filename=$name");

Does anybody know a solution for Opera? Then I could provide different
scripts depending on the browser.
Or even better a solution working in all browsers?

View Replies !
Problem Displaying Images With Php And Mysql
I am uploading images to a server and saving the script location to a mysql database.  It is loading into the server. When I call it with PHP it doesn't show up.  When I try to access it directly I get a an error stating that this directory is restricted without an index file.  I added an index file, but it made no difference.  The directory is set to 777.  Also, I manually changed the chmod on the image to 777 and now I am getting a "page not found" error.

here is the upload code:

View Replies !
Displaying MySQL Results As URLs
I'm attempting to turn the results of a query into urls, yet I keep getting this error, "Parse error: syntax error, unexpected '<' in staff.php on line 190." I've coded and recoded this, yet for some reason I cannot get this error to go away. I know it's probably simple, but what am I missing? Code:

View Replies !

Copyright © 2005-08 www.BigResource.com, All rights reserved