No
i checked the name of name of image values returned.
all is working fine
As i already mentioned tht it is working the right way on my local server.
reagrds
umeed
php-db-digest-help@xxxxxxxxxxxxx wrote:
php-db Digest 13 Sep 2005 22:56:53 -0000 Issue 3090
Topics (messages 40255 through 40261):
Re: image display problem
40255 by: Sebastian Mendel
Re: Inserting same text into HTML files
40256 by: Jens Schulze
Re: Inserting same text into HTML files. .
40257 by: Norland, Martin
Re: retrieving field names in ascending order
40258 by: graeme_foster
Re: Possible MySQLi extension BUG!
40259 by: Ziv Gabel
DataObject feature request
40260 by: Alessandro Pasotti
mysql_fix_privilege_tables error
40261 by: Carson Au
Administrivia:
To subscribe to the digest, e-mail:
php-db-digest-subscribe@xxxxxxxxxxxxx
To unsubscribe from the digest, e-mail:
php-db-digest-unsubscribe@xxxxxxxxxxxxx
To post to the list, e-mail:
php-db@xxxxxxxxxxxxx
----------------------------------------------------------------------
To: php-db@xxxxxxxxxxxxx
Date: Tue, 13 Sep 2005 12:15:09 +0200
From: Sebastian Mendel <lists@xxxxxxxxxxxxxxxxxx>
Subject: Re: image display problem
umeed hayyat wrote:
> Hi
> I have a form where user can add a category or edit some existing
> category.
> It is perfectly running on localhost but when i uploaded it to an ftp
> server (that was Linux based), it isnt displaying any images when i add
> any image through image uploading script, neither can i view any image
> on edit_category page, nor i can view when i change image while i edit
> any category.
>
> [...]
> if(isset($Upload))
> {
> $uploaddir = '../images/categories/';
> $uploadfile = $uploaddir . $_FILES['file1']['name'];
> $name = $HTTP_POST_FILES['file1']['name'];
try:
$name = $_FILES['file1']['name'];
check if $name holds the correct img name
--
Sebastian Mendel
www.sebastianmendel.de
www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet
To: php-db@xxxxxxxxxxxxx
Date: Tue, 13 Sep 2005 14:18:12 +0200
From: Jens Schulze <jens@xxxxxxxxxxxxxxxxxx>
Subject: Re: Inserting same text into HTML files
I don't understand why you don't use search&replace, as every normal
html file should start with .
Jens
Date: Tue, 13 Sep 2005 08:03:38 -0500
From: "Norland, Martin" <Martin.Norland@xxxxxxxxxx>
To: <php-db@xxxxxxxxxxxxx>
Subject: RE: Re: Inserting same text into HTML files. .
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
dir="ltr">
... Not necessarily.
cheers,
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.
-----Original Message-----
From: Jens Schulze [mailto:jens@xxxxxxxxxxxxxxxxxx]
Sent: Tuesday, September 13, 2005 7:18 AM
To: php-db@xxxxxxxxxxxxx
Subject: Re: Inserting same text into HTML files. .
I don't understand why you don't use search&replace, as every normal
html file should start with .
Jens
Date: Tue, 13 Sep 2005 19:21:44 +0600
From: graeme_foster <graeme_foster@xxxxxxxxxxxxxxxx>
To: hope <umeed921@xxxxxxxxx>
CC: php-db@xxxxxxxxxxxxx
Subject: Re: retrieving field names in ascending order
how about usort($myarray, "strcasecmp");
graeme
hope wrote:
> Well now i m retrieving results into an array
>
> Then i m using sort($myarray)
> but the problem is that it sorts in this way
> (
> e.g.
> ABB MBB
> ZZZ
> abc
> def
> ztt
>
> )
>
> i.e it sorts capital letters first n then it sorts the small letters
>
> but i want the display to sort in ascending order whether it is
> capital or smal lettr.
> i want my output to look like this
> (
> abc
> ABB
> def
> MBB
> ztt
> ZZZ
> )
>
> even if i use parameter
>
> sort($myarray, SORT_ASC);
>
> doesnt help.
>
>
> Regards
>
> hope
>
>
> Bastien Koert wrote:
>
>> AFAIK you can't order the
>
>
>> SHOW COLUMNS from TABLE
>
>
>> Yo could pass the results to an array and sort it in the array
>
>
>> Bastien
>
>
>
>>> From: umeed921@xxxxxxxxx (hope)
>>> To: php-db@xxxxxxxxxxxxx
>>> Subject: retrieving field names in ascending order
>>> Date: Thu, 08 Sep 2005 04:23:31 -0400
>>>
>>>
>>> hi
>>>
>>> how can i retrieve field names from a table(e.g products_attributes)
>>> in ascending order???
>>> i need to display each of the fieldnames alongwith its datatype and
>>> length on the page.
>>>
>>>
>>> regards hope
>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>
Date: Tue, 13 Sep 2005 17:17:18 +0200
From: "Ziv Gabel" <ziv@xxxxxxxxxxx>
To: "Bastien Koert" <bastien_k@xxxxxxxxxxx>,
<renich@xxxxxxxxxxxxxxxx>,
<php-db@xxxxxxxxxxxxx>
Subject: RE: Possible MySQLi extension BUG!
this is probably the reason that everything I do that got somthing to do with programming is always in english
I don't understand why you need all this problems when you can make all your "background" work (mysql db names,fields,variables) in english and spare the trouble of having to debug encoding problems
best regards
ziv gabel
________________________________
îàú: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx]
ðùìç: å 09/09/2005 20:05
àì: renich@xxxxxxxxxxxxxxxx; php-db@xxxxxxxxxxxxx
ðåùà: RE: Possible MySQLi extension BUG!
Questions:
1. what is the current database collation and character set? check with
whatever GUI tool you use to admin the db
2. Are they the same? ie UTF-8
3. the query of course would be correct since it hasn't touched mysql yet.
Its a straight representation from PHP.
Notes:
1. Spaces in DB table/field names are a really bad idea and should be
avoided if possible. Replace the spaces with underscores if you want the
appearance of the space
Bastien
>From: Renich Bon Ciric
>To: php-db@xxxxxxxxxxxxx
>Subject: Possible MySQLi extension BUG!
>Date: Fri, 09 Sep 2005 12:50:31 -0500
>
>Ok,
>
>Firs of all, I wanna say I have spent a whole week looking for answers
>elsewhere. The reason of this message is to look for a practical solution.
>
>My Systems:
>Server:
>Fedora Core 4 (up2dated)
>PHP5.04 (cli)
>MySQL 14.7 Distrib 4.1.12
>using mysqli extension
>Apache/2.0.54 (Fedora)
>
>Workstation:
>Windows XP SP2
>Zend Studio Enterprise 4.02
>
>Well, let me explain the problem:
>
>I'm developing some aplications that require the use of foreign characters.
>The language is spanish, so you use accends or tilde on some works
>(example, comisi?n, ni?o, etc).
>
>I have a simple query that uses tables (named with this foreign
>characters). Example:
>
>directorio
> - Empresa
> - Direcci?n
> - Asistente de Direcci?n
>
>A query to this database should be as follows:
>
>SELECT *
>FROM `Asistente de Direcci?n`;
>
>This returns an error like:
>
>Table 'directorio.Asistente de Direcci?³n' doesn't exist.
>
>I have changed EVERYTHING to utf-8 charset:
>
>httpd.conf - AddDefaultCharset = UTF-8
>php.ini - default_charset = "UTF-8"
> mbstring.internal_encodign = UTF-8
> mbstring.http_input = UTF-8
> mbstring.http_output = UTF-8
> mbstring.detect_order = UTF-8,SJIS,ASCII
>my.cnf - [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> old_passwords=1
> default-character-set=utf8
> [mysql.server]
> user=mysql
> basedir=/var/lib
>
> [mysqld_safe]
> err-log=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
>
> [mysql]
> default-character-set=utf8
>
>This config sets ALL my servers to utf-8
>
>- Apache works perfectly fine in UTF-8, no problems
>- PHP encodes everything to utf-8... at least thats what i think
>- All my MySQL char variables are set to UTF-8, except
>"default-character-result" its set to NULL
>
>As far as I know, there is no other config made to be done.
>
>My theory is this:
>
>Consider:
>
>>
>$link = mysqli_connect('mysql.fedora', 'root', 'idontrecall',
>'directorio');
>
>if ( isset($_POST['submit']) && $_POST['submit'] == 'Search' )
>{
>$query = "SELECT *
> FROM `Empresa`,
> `Presidente`,
> `Asistente de Presidencia`,
> `Director`,
> `Asistente de Direcci?n`, `
> Centro de Distribuci?n 01`,
> `Centro de Distribuci?n 02`,
> `Centro de Distribuci?n 03`,
> `Centro de Distribuci?n 04`,
> `Centro de Distribuci?n 05`,
> `Centro de Distribuci?n 06`,
> `Centro de Distribuci?n 07`,
> `Centro de Distribuci?n 08`,
> `Centro de Distribuci?n 09`,
> `Centro de Distribuci?n 10`
>
>WHERE Empresa.Emp_Gro LIKE '%$_POST[input]%'
>AND Empresa.ID = Presidente.ID
>AND Empresa.ID = `Asistente de Presidencia`.ID
>AND Empresa.ID = Director.ID
>AND Empresa.ID = `Asistente de Direcci?n`.ID
>AND Empresa.ID = `Centro de Distribuci?n 01`.ID
>AND Empresa.ID = `Centro de Distribuci?n 02`.ID
>AND Empresa.ID = `Centro de Distribuci?n 03`.ID
>AND Empresa.ID = `Centro de Distribuci?n 04`.ID
>AND Empresa.ID = `Centro de Distribuci?n 05`.ID
>AND Empresa.ID = `Centro de Distribuci?n 06`.ID
>AND Empresa.ID = `Centro de Distribuci?n 07`.ID
>AND Empresa.ID = `Centro de Distribuci?n 08`.ID
>AND Empresa.ID = `Centro de Distribuci?n 09`.ID
>AND Empresa.ID = `Centro de Distribuci?n 10`.ID";
>
>// Make the query
>$result = mysqli_query($link,$query) or die(mysqli_error($link));
>
>// Fetch the results
>while ($data = mysqli_fetch_assoc($result))
>{
> // Print the data obtained
> print_my_data($data);
>}
>
>}
>// Close conection
>mysqli_close($link);
>
>?>
>
>if you add a "print $query;" just before it makes the query; and as long as
>you have your webpage with the charset meta-tag set to "utf-8" and
>everything utf-8 encoded... you'll get the right query...
>
>this is
>
>SELECT * FROM `Empresa`, `Presidente`, `Asistente de Presidencia`,
>`Director`, `Asistente de Direcci?n`, ` Centro de Distribuci?n 01`, `Centro
>de Distribuci?n 02`, `Centro de Distribuci?n 03`, `Centro de Distribuci?n
>04`, `Centro de Distribuci?n 05`, `Centro de Distribuci?n 06`, `Centro de
>Distribuci?n 07`, `Centro de Distribuci?n 08`, `Centro de Distribuci?n 09`,
>`Centro de Distribuci?n 10` WHERE Empresa.Emp_Gro LIKE '%try this%' AND
>Empresa.ID = Presidente.ID AND Empresa.ID = `Asistente de Presidencia`.ID
>AND Empresa.ID = Director.ID AND Empresa.ID = `Asistente de Direcci?n`.ID
>AND Empresa.ID = `Centro de Distribuci?n 01`.ID AND Empresa.ID = `Centro de
>Distribuci?n 02`.ID AND Empresa.ID = `Centro de Distribuci?n 03`.ID AND
>Empresa.ID = `Centro de Distribuci?n 04`.ID AND Empresa.ID = `Centro de
>Distribuci?n 05`.ID AND Empresa.ID = `Centro de Distribuci?n 06`.ID AND
>Empresa.ID = `Centro de Distribuci?n 07`.ID AND Empresa.ID = `Centro de
>Distribuci?n 08`.ID AND Empresa.ID = `Centro de Distribuci?n 09`.ID AND
>Empresa.ID = `Centro de Distribuci?n 10`.ID
>
>following the error
>Table 'directorio.Asistente de Direcci?³n' doesn't exist
>
>As you can see, this is not logical. You had your query printed just above
>and it printed out fine!... Sorry, if i got a little carried away...
>
>This is why i think that the mysqli extension haves a bug. I have my
>connection, server, etc... variables set to UTF-8 in MySQL. The one that is
>converting the code while using the "mysqli_fetch_assoc()" function is
>php...
>
>If anybody knows how to correct this... or how to make the example work...
>please tell me. I have worked on this too much.
>
>I know that if I change the tablenames, it will work. In fact, a query like
>
>SELECT *
>FROM `Empresa`;
>
>Works perfectly fine.
>
> Help me and all the foreign php and mysql users use our own
>characters!
>
>Things I have checked:
>- Searched my.cnf, httpd.conf and php.ini for any "ISO-8859-1","latin1"
>strings.
>- Checked the db file names (/var/lib/mysql/)
>- Checked if the script files are UTF-8 encoded
>- Checked if the browser is accepting the UTF-8 charset
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
************************************************************************************
This footnote confirms that this email message has been scanned by
PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses.
************************************************************************************
From: Alessandro Pasotti <ale.pas@xxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Date: Tue, 13 Sep 2005 17:58:17 +0200
CC: Justin Patrin <papercrane@xxxxxxxxx>
Subject: DataObject feature request
Hello,
This is just an idea, DataObject already store most information about the
fields, there is still a feature that is really useful during input
validation, this is field max length for varchar fields.
Do you think it is possibile to store also this important piece of information
into .ini file?
Such values could be used in the validate() function to check user input
length on text fields.
--
Alessandro Pasotti
ICQ# 245871392
Linux User #167502
To: PHP DB <php-db@xxxxxxxxxxxxx>
From: Carson Au <cau@xxxxxx>
Date: Tue, 13 Sep 2005 15:56:47 -0700
Subject: mysql_fix_privilege_tables error
Hi Guys, I am a newbie and having a lot of trouble with PHP/MySQL
lately... We have a number of PHP/MYSQL solutions developed on our
server and I have the pleasure to maintain them...
The copy of MySQL 3.23 has started crashing and refusing to start, so
what I did was I backed up all the DBs and then reinstalled version 4,
things seems to be working ok.
Then I discovered this:
http://www.educ.sfu.ca/phpbb2/
and in phpmyadmin I get this message:
"Warning: Your privilege table structure seem to be older than this
MySQL version!
Please run the script mysql_fix_privilege_tables that should be
included in your MySQL server distribution to solve this problem!"
So I tried to do the following...
$ sudo -s
$ mysql_fix_privilege_tables mypassword
And this is the errors I got:
This scripts updates the mysql.user, mysql.db, mysql.host and the
mysql.func table to MySQL 3.22.14 and above.
This is needed if you want to use the new GRANT functions,
CREATE AGGREAGATE FUNCTION or want to use the more secure passwords in
3.23
If you get Access denied errors, you should run this script again
and give the MySQL root user password as a argument!
If your tables are already up to date or partially up to date you will
get some warnings about 'Duplicated column name'. You can safely ignore
these!
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
Creating Grant Alter and Index privileges if they don't exists
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
Creating the new table and column privilege tables
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
Changing name of columns_priv.Type -> columns_priv.Column_priv
You can ignore any errors from this
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
Fixing the func table
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password:
YES)
Any suggestion? I have checked the permission table using phpmyadmin
and grant=Yes for "root".
Anything else I need to do differently?
Regards,
Cars
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
