php-general Digest 6 Oct 2002 20:00:00 -0000 Issue 1628

Topics (messages 118984 through 119012):

How to connect Web database
        118984 by: Vinod Bhaskar
        118986 by: Intruder

How to connect Web Database from local machine
        118985 by: Vinod Bhaskar
        118996 by: John W. Holmes

sessions without cookies *or* URLs
        118987 by: David T-G
        118990 by: Justin French

Using date() function
        118988 by: Davy Obdam
        118989 by: nicos.php.net
        118992 by: Davy Obdam
        118994 by: . Edwin
        118995 by: John W. Holmes

mysql_fetch_row() problem
        118991 by: tony.tabzilla.com
        118993 by: Intruder

Re: MySQL>Limit size
        118997 by: John W. Holmes
        118998 by: Christian Ista
        118999 by: John W. Holmes

Re: [PHP-WIN] RE: [PHP] Re: Using date() function
        119000 by: Davy Obdam
        119001 by: John W. Holmes

Re: Mysqldump
        119002 by: Paul Nicholson

working with pspell
        119003 by: Andy
        119006 by: Lowell Allen

Re: access denied
        119004 by: Simon Angell

Re: Quick question.
        119005 by: Simon Angell

Can it be Done?
        119007 by: Stephen
        119008 by: Sascha Cunz
        119009 by: . Edwin
        119012 by: Adriano

Re: after mysqlfront?
        119010 by: John W. Holmes

formatting / beautifying PHP code
        119011 by: Andrew Ziem

Administrivia:

To subscribe to the digest, e-mail:
        php-general-digest-subscribelists.php.net

To unsubscribe from the digest, e-mail:
        php-general-digest-unsubscribelists.php.net

To post to the list, e-mail:
        php-generallists.php.net

----------------------------------------------------------------------

attached mail follows:

Hi Friends,
I am having a local MySQL database & tables in Linux and the data is
updated in the table using PHP scripts working through apache web server.
local MySQL database is connected using the following php scripts.

mysql_connect("localhost","root","vinodb")
or die ("cannot connect to mysqld");

mysql_select_db("lnnet")
or die("cannot select database");

I have created same database and tables which is available locally on web
which is having MySQL & PHP
support. Now I want to update the web database from the local database
using php scripts.
How do I connect web database and local database simultaneously. I will be
grateful, if any body can
mail me the connecting scripts, so that I can write php scripts to update
the records from local database.
or can any body suggest a solution on how to update the tables.

Regards,
Vinod.

attached mail follows:

You have to use mysqldump utility to make script, then you can put it into your
PHP script and run that script:
<?php
$sql = "<PRODUCED SCRIPT BODY GOES HERE>";
mysql_query($sql);
?>

or just dump your database directly to remote server by running mysqldump with
parameters Host and some other. The only difficulty could be, that remote
provider could reject all emote connections :((

the third way is to place PHP script on remote mashine and to connect to your
local MySQL server and just make some SELECT-INSERT. Here you can have the same
problem as in previous: proveder can reject all connection aoutside their box
:(((

attached mail follows:

Hi all,

I am having MySQL database on web. (eg., at www.lmcr.net). What is the PHP
script which I can connect the MySQL table from my Local machine. Can
anybody help me.

Regards,

Vinod.

attached mail follows:

> I am having MySQL database on web. (eg., at www.lmcr.net). What is the
PHP
> script which I can connect the MySQL table from my Local machine. Can
> anybody help me.

Well, most hosting companies do not allow remote access to the MySQL
server, but if you're does, then you connect the same way as usual...

$link_id = mysql_connect("mysql.yourdomain.com","user","password");

You just pass the IP or name of your MySQL server in the mysql_connect
function. To also connect to your local database, just use

$link_id2 = mysql_connect("localhost","user","password");

And then you have a connection to each one open. Be sure to use the
appropriate $link_id in your queries.

---John Holmes...

attached mail follows:

Hi, all --

I've seen a recent flurry of discussion on sessions, and that's good;
lovely how that has shown up just as I need to dig into sessions. I
think I've come to understand, though, that you can't manage sessions
without either URL extensions or cookies, and that's bad (for me, at
least).

Is that a correct understanding? It seems that using forms to pass the
session token would work, but that means having all buttons instead of
links, which has its own disadvantages. Is there any other way to get
data to the server?

We currently use the URL to pass variables but we don't want to hang the
page password out there :-) and so we have to maove away from that somehow,
and it would be nice if we could get away from URL mangling entirely.
Cookies aren't an option, though.

TIA & HAND

:-D

-- 
David T-G                      * It's easier to fight for one's principles
(play) davidtgjustpickone.org * than to live up to them. -- fortune cookie
(work) davidtgworkjustpickone.org
http://www.justpickone.org/davidtg/    Shpx gur Pbzzhavpngvbaf Qrprapl Npg!

-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD)

iD8DBQE9oB3jGb7uCXufRwARAqQ2AKC4oJU7j37Znaq4eVXuQV+TtC2EHQCdGaPf v631MS8XK+ydjTryg4U0sSI= =GW6j -----END PGP SIGNATURE-----

attached mail follows:

I think you're under a little misconception about how sessions are used. Maintaining a session is simply just having a unique identifier for each "user", so that the server can recognise the user from page to page, maintaining state.

Typically this is done by passing a session id around in he URL or cookies or POSTing forms. A session ID is typically a long unique number -- that's it.

What you then do associate or register data TO that Session ID... this data is stored on the SERVER, and NOT passed around in the URL.

So you pass around PHPSESSID=198235021612423 in the url or a cookie, and assign data to that session... all of which is stored server side.

The session with the id 198235021612423 may have a username, password, shoe size, favourite colour, etc etc all attached to it, done with either:

$_SESSION['shoesize'] = "14"; // new register globals OFF method

or

$shoesize = "14"; session_register("shoesize"); // old method

Therefor, I can see no need for anything other than the session ID to be passed around in the URL.

Hope this clears it up!

Justin French

on 06/10/02 9:26 PM, David T-G (davidtg-phpjustpickone.org) wrote:

> Hi, all -- > > I've seen a recent flurry of discussion on sessions, and that's good; > lovely how that has shown up just as I need to dig into sessions. I > think I've come to understand, though, that you can't manage sessions > without either URL extensions or cookies, and that's bad (for me, at > least). > > Is that a correct understanding? It seems that using forms to pass the > session token would work, but that means having all buttons instead of > links, which has its own disadvantages. Is there any other way to get > data to the server? > > We currently use the URL to pass variables but we don't want to hang the > page password out there :-) and so we have to maove away from that somehow, > and it would be nice if we could get away from URL mangling entirely. > Cookies aren't an option, though. > > > TIA & HAND > > :-D

attached mail follows:

Hi people

I have a guestbook, and i need to convert the date and time from the database into a normal readable date.. Like Sunday, 6 october 2002 13:30:00. I thought i could use the date() function here. I have done this:

$entry_date = date('l, d F Y H:i:s','$sql["date"]'); echo $entry_date;

But then i dont get the date i need. It says Thursday, 01 January 1970 01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that guestbook. Any sugestions what i am doing wrong. Thanks for your time.

Best regards, Davy Obdam, mailto:infodavyobdam.com

attached mail follows:

First you should use : $entry_date = date('l, d F Y H:i:s',$sql['date']);

And $sql['date'] must be a TIMESTAMP.

--
Nicos - CHAILLAN Nicolas
nicosphp.net
www.WorldAKT.com - Hébergement de sites Internet
"Davy Obdam" <infodavyobdam.com> a écrit dans le message de news:
001601c26d2c$e5391ff0$9600000adavy...
> Hi people
>
> I have a guestbook, and i need to convert the date and time from the
> database into a normal readable date.. Like Sunday, 6 october 2002
> 13:30:00. I thought i could use the date() function here. I have done
> this:
>
> $entry_date = date('l, d F Y H:i:s','$sql["date"]');
> echo $entry_date;
>
> But then i dont get the date i need. It says Thursday, 01 January 1970
> 01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that
> guestbook. Any sugestions what i am doing wrong. Thanks for your time.
>
> Best regards,
>
> Davy Obdam,
> mailto:infodavyobdam.com
>
>

attached mail follows:

Hi Nicos,

Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date'] is a TIMESTAMP and looks like this 20021006141256 in the datebase. It should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know a solution?

Best regards, Davy Obdam, mailto:infodavyobdam.com

-----Original Message----- From: nicosphp.net [mailto:nicosphp.net] Sent: Sunday, October 06, 2002 1:59 PM To: php-generallists.php.net; php-windowslists.php.net Subject: [PHP] Re: Using date() function

First you should use : $entry_date = date('l, d F Y H:i:s',$sql['date']);

And $sql['date'] must be a TIMESTAMP.

--
Nicos - CHAILLAN Nicolas
nicosphp.net
www.WorldAKT.com - Hébergement de sites Internet

attached mail follows:

Hello,

Why not just do it in your sql query?

If you're using MySQL perhaps this page would be helpful:

http://www.mysql.com/doc/en/Date_and_time_functions.html

Just an idea...

- E

On Sunday, October 6, 2002 10:01 PM Davy Obdam wrote: > Hi people > > I have a guestbook, and i need to convert the date and time from the > database into a normal readable date.. Like Sunday, 6 october 2002 > 13:30:00. I thought i could use the date() function here. I have done > this: > > $entry_date = date('l, d F Y H:i:s','$sql["date"]'); > echo $entry_date; > > But then i dont get the date i need. It says Thursday, 01 January 1970 > 01:00:00 (i wasn`t even born then;-), so it wasn`t me signing that > guestbook. Any sugestions what i am doing wrong. Thanks for your time. > > Best regards, > > Davy Obdam, > mailto:infodavyobdam.com > >

attached mail follows:

> Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me > back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date'] is > a TIMESTAMP and looks like this 20021006141256 in the datebase. It > should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know a > solution?

No, not weird. MySQL uses a timestamp in the YYYYMMDDHHMMSS format. Date() is expecting a UNIX timestamp, which is the number of seconds since Jan 1, 1970.

So... you can either use DATE_FORMAT() in your query, with is the MySQL equivalent of date(). Look up the format in the manual. Or, you can use UNIX_TIMESTAMP() in your query to select out the unix timestamp instead of the mysql timestamp, and then use that value within date() in your PHP script.

---John Holmes...

attached mail follows:

I have this small bit of code to fetch the latest songs submitted by a user on theire profile for my tab website, here is the code:

<?php $get_songs = mysql_query("SELECT `id`,`title`,`artist_id`,`type` FROM `resources` WHERE `user_id` = '$id' ORDER BY `rating` LIMIT 0,10"); ?> <table border="0" cellpadding="1"><tr><td><B>10 Latest Songs Submited by <?php echo($profile_array[0]); ?></b></td><td></td><td></td></tr> <?php for ($i = 0; $i < mysql_num_rows($get_songs); $i ++) { $latsongs = mysql_fetch_row($get_songs); $get_anames = mysql_query("SELECT `name` FROM `artists` WHERE `artist_id` = '$id'"); $anames = mysql_fetch_row($get_names); // !!! ERROR LINE !!! echo("<tr><td><a href=\"view.php?id=$latsongs[0]\">$latsongs[1]</a></td><td><a href=\"artist.php?id=$latsongs[2]\">$anames[0]</a></td><td>($latsongs[3])</t d></tr>"); } ?>

The problem is with the line i labelled !!! ERROR LINE !!!, to fetch the artist name. The error returned is:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/tabzilla/public_html/profile.php on line 115

You can see the complete page at http://www.tabzilla.com/profile.php?id=3

attached mail follows:

ttc> $get_anames = mysql_query("SELECT `name` FROM `artists` WHERE `artist_id` = ttc> '$id'"); ttc> $anames = mysql_fetch_row($get_names); // !!! ERROR LINE !!!

of course it is an error! check your spelling !!! $get_names != $get_anames ;))))

attached mail follows:

> I have a form with a textarea. When I put a long text(one word page for > example), when I submit, the form is not submitted. I have to remove > some line to submit. I don't have any limit in the textarea. The content > of this form is sorted in a MySQL database. I tried to set the field > where the textarea will be stored to LONGTEXt or LONGBLOB but I have all > the time the same problem.

Are you using POST or GET for your form? Show some code...

---John Holmes...

attached mail follows:

> Are you using POST or GET for your form? Show some code...

I use get. But I tried to post and look ok. Why this difference ?

Christian,

attached mail follows:

> > Are you using POST or GET for your form? Show some code... > > I use get. But I tried to post and look ok. Why this difference ? > > Christian, >

You can only send so much data through GET, because the URL is limited as to how long it can be. It may be different for each browser, but I think it's usually 1024 characters. There is no limit with POST.

---John Holmes...

attached mail follows:

Hi John,

How do u use UNIX_TIMESTAMP or DATE_FORMAT in your query. My query now looks like this:

"SELECT * FROM guestbook2002 ORDER BY entryID DESC LIMIT $entry, $show";

Can u help me;-) Thanks for your time

Best regards, Davy Obdam, mailto:infodavyobdam.com

-----Original Message----- From: John W. Holmes [mailto:holmes072000charter.net] Sent: Sunday, October 06, 2002 3:31 PM To: 'Davy Obdam'; nicosphp.net; php-generallists.php.net; php-windowslists.php.net Subject: [PHP-WIN] RE: [PHP] Re: Using date() function

> Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me > back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date'] is > a TIMESTAMP and looks like this 20021006141256 in the datebase. It > should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know a > solution?

No, not weird. MySQL uses a timestamp in the YYYYMMDDHHMMSS format. Date() is expecting a UNIX timestamp, which is the number of seconds since Jan 1, 1970.

So... you can either use DATE_FORMAT() in your query, with is the MySQL equivalent of date(). Look up the format in the manual. Or, you can use UNIX_TIMESTAMP() in your query to select out the unix timestamp instead of the mysql timestamp, and then use that value within date() in your PHP script.

---John Holmes...

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

attached mail follows:

> Hi John, > > How do u use UNIX_TIMESTAMP or DATE_FORMAT in your query. My query now > looks like this: > > "SELECT * FROM guestbook2002 ORDER BY entryID DESC LIMIT $entry, $show"; > > Can u help me;-) Thanks for your time

Did you read the Date and Time Functions chapter of the MySQL manual??

SELECT UNIX_TIMESTAMP(your_timestamp_column) AS alias FROM your_table ...

SELECT DATE_FORMAT(column,'<format>'), column2, column3, etc FROM yourtable ...

You have to name the columns and not use * in your query. You'll also want to read up on the AS alias, if you don't know what that is.

---John Holmes...

attached mail follows:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Hey, I'm not sure about windows machines as I use linux but it looks like you're sending the right commands. You need to check your permissions. ~Paul

On Sunday 06 October 2002 12:30 am, Uma Shankari T. wrote: > Hello, > > I am trying to dump the text file contents to mysql which was already > backup from mysql only..While trying to dump it is telling access denied > error > > i am trying from here > > d:\mysql\bin>mysqldump databasename txt.file name > > Can anyone tell me how to go about with this ?? > > Regards, > Uma

- -- ~Paul Nicholson Design Specialist WebPower Design "The web....the way you want it!" paulwebpowerdesign.net

"It said uses Windows 98 or better, so I loaded Linux!" Registered Linux User #183202 using Register Linux System # 81891 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org

iD8DBQE9oFpTDyXNIUN3+UQRAq7wAJ97jRHEUq/oQivyZzHD22wpQegbZwCdGeTl Sux8I5NCDdbJk9lstKeKsr8= =dwjM -----END PGP SIGNATURE-----

attached mail follows:

Hi everybody,

I just installed pspell and would like to get behind of the whole concept of spellchecking with php.

As far as I understand, I have to check it word by word. Is there an algorithm which allowes to give a sentence to check and highlight all the words mispelled. On clickin the mispelled word to open a popup with suggestions and by clicking on the proper word to automaticly replace the wrong word.

This sounds very complicated. Has anybody a good suggestion, or article to recommend on this topic?

Thanx for your help,

Andy

attached mail follows:

> From: "Andy" <news.lettersgmx.de> > > I just installed pspell and would like to get behind of the whole concept of > spellchecking with php. > > As far as I understand, I have to check it word by word. Is there an > algorithm which allowes to give a sentence to check and highlight all the > words mispelled. On clickin the mispelled word to open a popup with > suggestions and by clicking on the proper word to automaticly replace the > wrong word. > > This sounds very complicated. Has anybody a good suggestion, or article to > recommend on this topic? > I'm currently doing a spell checker, and found this article very helpful: <http://www.zend.com/zend/spotlight/spellchecking.php>.

--
Lowell Allen

attached mail follows:

I don't know exactly what shell access is, but in my quest to do what i was trying to do, i realised its not worth it due to the fact the file i was copying was still being accessed everytime the php file was open, and my aim was to get the particular file from the remote server, copy it onto my server 2 times a day and then the php file that im working on would access the local file instead of the remote file which its doing now,

Anyways, thanx for all your help

--
Cheers
---------------------------------------------------------
Simon Angell
Canberra ACT
www.canberra-wx.com
---------------------------------------------------------
Member of:
Australian Severe Weather Association.
www.severeweather.asn.au
---------------------------------------------------------
This email is virus free.
Scanned before leaving my mailbox
using Norton Antivirus 2002 for Win2k
Scanned with the latest definition File.

attached mail follows:

Hi, sorry about the delay, i have some computer problems in the last few days, all fixed now i hope.

I don't know exactly what shell access is, or ssh for that matter, but in my quest to do what i was trying to do, I realised its not worth it due to the fact the file i was copying was still being accessed everytime the php file was open, and my aim was to get the particular file from the remote server, copy it onto my server 2 times a day and then the php file that im working on would access the local file instead of the remote file which its doing now,

Anyways, thanx for all your help

--
Cheers
---------------------------------------------------------
Simon Angell
Canberra ACT
www.canberra-wx.com
---------------------------------------------------------
Member of:
Australian Severe Weather Association.
www.severeweather.asn.au
---------------------------------------------------------
This email is virus free.
Scanned before leaving my mailbox
using Norton Antivirus 2002 for Win2k
Scanned with the latest definition File.

attached mail follows:

Hello,

I was wondering if what I want to do is possible. I have a website that uses iframes and sometimes the search engines pick up the file that's displayed in the iframe. That file jsut plain looks really bad but in the site itself and displayed in the iframe it looks a whole lot better.

What I want to be able to do is this. If the file is being displayed just plain, not in the iframe, it forwards to the main site and then displays the file in the iframe. But then, if the file is already being displayed in the iframe, it doesn't do anything. Can this be done and how?

Thanks, Stephen Craton

attached mail follows:

Hi, i don't think you can do this all on Server-side. I once made things like that work with usual frames. I used Javascript in each page of the frameset to find out if the "parent" exists - and if not, redirect to the frameset which itself was a PHP script whom i told to load the current page in correct frames. I don't know if that's also posibile with iframes.

Anyway, you need to do two steps:

1. You must be able to view the outer page with a parameter, which tells it what Site is to be viewed inside the iframe.

2. Some sort of JavaScript wich redirects to the outer page. Tha JavaScript must live inside each site that might show up inside the iframe.

Regards Sascha

Am Sonntag, 6. Oktober 2002 18:29 schrieb Stephen: > Hello, > > I was wondering if what I want to do is possible. I have a website that > uses iframes and sometimes the search engines pick up the file that's > displayed in the iframe. That file jsut plain looks really bad but in the > site itself and displayed in the iframe it looks a whole lot better. > > What I want to be able to do is this. If the file is being displayed just > plain, not in the iframe, it forwards to the main site and then displays > the file in the iframe. But then, if the file is already being displayed in > the iframe, it doesn't do anything. Can this be done and how? > > Thanks, > Stephen Craton

attached mail follows:

'Not really sure, but perhaps, with Javascript.

But I'd rather recommend you to give up iframes... ;)

- E

On Monday, October 7, 2002 1:29 AM Stephen wrote: > Hello, > > I was wondering if what I want to do is possible. I have a website that uses iframes and sometimes the search engines pick up the file that's displayed in the iframe. That file jsut plain looks really bad but in the site itself and displayed in the iframe it looks a whole lot better. > > What I want to be able to do is this. If the file is being displayed just plain, not in the iframe, it forwards to the main site and then displays the file in the iframe. But then, if the file is already being displayed in the iframe, it doesn't do anything. Can this be done and how? > > Thanks, > Stephen Craton

attached mail follows:

Hi people, Edwin wrore:

> 'Not really sure, but perhaps, with Javascript. > > But I'd rather recommend you to give up iframes... ;) >

Can you post an example of Javascript code checking for _parent frame? By the way, what's wrong with iframes? bye, Adr

attached mail follows:

> DB tools (getting better every version) > http://www.dbtools.com.br/EN/

Let's hope so, because the version I just downloaded would always crash whenever you tried to set up a new connection....

Mascon seems to be a very good project and far more features than MySQL-Front. And I'm a big fan of MySQL-Front...

---John Holmes...

attached mail follows:

Is there a utility that formats / beautifies PHP code like indent does for C code?

--
Andrew Ziem
Is Jesus Your Answer?
http://www.ChristianAnswers.net/gospel

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]