Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #9951 > unrolled thread

mysqli --- who does the switching?

Back to article view | Back to comp.lang.php

Contents

  mysqli --- who does the switching? richard <noreply@example.com> - 2013-06-28 20:39 -0400
    Re: mysqli --- who does the switching? Lew Pitcher <lew.pitcher@digitalfreehold.ca> - 2013-06-28 21:11 -0400
      Re: mysqli --- who does the switching? richard <noreply@example.com> - 2013-06-28 21:23 -0400
        Re: mysqli --- who does the switching? Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-06-29 13:13 +0000
          Re: mysqli --- who does the switching? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-29 15:27 +0100
            Re: mysqli --- who does the switching? richard <noreply@example.com> - 2013-06-29 13:19 -0400
            Re: mysqli --- who does the switching? Tim Streater <timstreater@greenbee.net> - 2013-06-29 22:37 +0100
              Re: mysqli --- who does the switching? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-30 11:12 +0100
              Re: mysqli --- who does the switching? Alf Christophersen <alf.christophersen@medisin.uio.no> - 2013-07-06 23:33 +0200
                Re: mysqli --- who does the switching? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-07-07 23:15 +0200
                  Re: mysqli --- who does the switching? Richard Yates <richard@yatesguitar.com> - 2013-07-08 12:02 -0700
    Re: mysqli --- who does the switching? Scott Johnson <noonehome@chalupasworld.com> - 2013-06-28 18:36 -0700
      Re: mysqli --- who does the switching? richard <noreply@example.com> - 2013-06-28 21:50 -0400
        Re: mysqli --- who does the switching? Scott Johnson <noonehome@chalupasworld.com> - 2013-06-28 19:58 -0700
          Re: mysqli --- who does the switching? Richard Yates <richard@yatesguitar.com> - 2013-06-30 13:56 -0700
      Re: mysqli --- who does the switching? richard <noreply@example.com> - 2013-06-28 21:54 -0400
        Re: mysqli --- who does the switching? Scott Johnson <noonehome@chalupasworld.com> - 2013-06-28 20:02 -0700
          Re: mysqli --- who does the switching? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-06-29 05:43 +0200
            Re: mysqli --- who does the switching? Scott Johnson <noonehome@chalupasworld.com> - 2013-06-29 08:39 -0700
    Re: mysqli --- who does the switching? Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2013-06-29 04:37 +0200
      Re: mysqli --- who does the switching? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-29 10:40 +0100
        Re: mysqli --- who does the switching? Luuk <luuk@invalid.lan> - 2013-06-29 13:11 +0200
          Re: mysqli --- who does the switching? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-29 13:30 +0100
            Re: mysqli --- who does the switching? Luuk <luuk@invalid.lan> - 2013-06-29 20:39 +0200
            Re: mysqli --- who does the switching? Richard Yates <richard@yatesguitar.com> - 2013-06-30 13:59 -0700
    Re: mysqli --- who does the switching? Denis McMahon <denismfmcmahon@gmail.com> - 2013-06-29 17:25 +0000
    Re: mysqli --- who does the switching? Twayne <nobody@spamcop.net> - 2013-06-29 18:56 -0400

Page 1 of 2  [1] 2  Next page →

#9951 — mysqli --- who does the switching?

Y'all keep bashing me about switching to mysqli.
Well buttheads, as I see it, it ain't MY choice.
It is the decision of those that host the servers.
After all, where does mysql or mysqli reside? On my machine?

You also say I never read the frickin manuals.
BULLSHIT!
I read them a lot. On practically every issue I come across.
Just so that I can try to understand what it is I want to do.

But there are those times when the manuals don't always cover what I want
to know. 
I also do a ton of searching through google.
BEFORE I post here.
And sometimes I find what I need AFTER I post here.

I may have been tagged as "stupid", but that doesn't mean I am not capable
of learning. 

On my music site, I have written the scripts to make it work the way I want
and I'd say I've done a damn decent job of it.
And if something doesn't validate, I find out why and correct it.
That's a lot more than what major powerhouses like Google can say.

Running google.com through the validator shows 25 error and 4 warnings.
mroldies.net validates with only 2 minor warnings.
msnbc.com contains 140 errors and 31 warnings.
microsoft.com contains 520 errors and 482 warnings!

And these highly professional people get paid for their shitty ass work?

[toc] | [next] | [standalone]

#9953

On Friday 28 June 2013 20:39, in comp.lang.php, noreply@example.com wrote:

> Y'all keep bashing me about switching to mysqli.
> Well buttheads, as I see it, it ain't MY choice.
> It is the decision of those that host the servers.

FWIW, the mysqli() interface was introduced with PHP 5.0 (says 
http://www.php.net/manual/en/mysqli.overview.php)

As far as I can tell, your website is hosted by HostGator, who advertise
that their hosting services provide (among other things) PHP 5.
(http://www.hostgator.com/shared, under the "Programming and Database
Features" heading)

It looks like your hosting service provides the PHP level that supports
mysqli(). So, ISTM, there's nothing stopping you from writing your PHP
scripts to use the mysqli() interface.

[rant snipped]

HTH
-- 
Lew Pitcher
"In Skills, We Trust"

[toc] | [prev] | [next] | [standalone]

#9954

On Fri, 28 Jun 2013 21:11:56 -0400, Lew Pitcher wrote:

> On Friday 28 June 2013 20:39, in comp.lang.php, noreply@example.com wrote:
> 
>> Y'all keep bashing me about switching to mysqli.
>> Well buttheads, as I see it, it ain't MY choice.
>> It is the decision of those that host the servers.
> 
> FWIW, the mysqli() interface was introduced with PHP 5.0 (says 
> http://www.php.net/manual/en/mysqli.overview.php)
> 
> As far as I can tell, your website is hosted by HostGator, who advertise
> that their hosting services provide (among other things) PHP 5.
> (http://www.hostgator.com/shared, under the "Programming and Database
> Features" heading)
> 
> It looks like your hosting service provides the PHP level that supports
> mysqli(). So, ISTM, there's nothing stopping you from writing your PHP
> scripts to use the mysqli() interface.
> 
> [rant snipped]
> 
> HTH

the script I used had mysqli and it would not work that way.

[toc] | [prev] | [next] | [standalone]

#9966

richard <noreply@example.com> wrote in news:2y4pesy8rb8f$.7qsm5tfx3b6l$.dlg@
40tude.net:

> On Fri, 28 Jun 2013 21:11:56 -0400, Lew Pitcher wrote:
>> It looks like your hosting service provides the PHP level that supports
>> mysqli(). So, ISTM, there's nothing stopping you from writing your PHP
>> scripts to use the mysqli() interface.
> 
> the script I used had mysqli and it would not work that way.
> 
In other words... you didn't write it, and you don't have a clue how to fix it, eh?

[toc] | [prev] | [next] | [standalone]

#9967

On 29/06/13 14:13, Doug Miller wrote:
> richard <noreply@example.com> wrote in news:2y4pesy8rb8f$.7qsm5tfx3b6l$.dlg@
> 40tude.net:
>
>> On Fri, 28 Jun 2013 21:11:56 -0400, Lew Pitcher wrote:
>>> It looks like your hosting service provides the PHP level that supports
>>> mysqli(). So, ISTM, there's nothing stopping you from writing your PHP
>>> scripts to use the mysqli() interface.
>> the script I used had mysqli and it would not work that way.
>>
> In other words... you didn't write it, and you don't have a clue how to fix it, eh?
Hehe.

reminds me of a friend of mine walking into a company that had written a 
vast commercial package in GWBASIC.

She  said 'I am not touching this till there is a flow chart' She drew 
it on a roll of wallpaper and pinned it to the wall. It was  still there 
when she left a couple of years later.;

-- 
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to lead are elected by the least capable of producing, and where the members of society least likely to sustain themselves or succeed, are rewarded with goods and services paid for by the confiscated wealth of a diminishing number of producers.

[toc] | [prev] | [next] | [standalone]

#9970

On Sat, 29 Jun 2013 15:27:12 +0100, The Natural Philosopher wrote:

> On 29/06/13 14:13, Doug Miller wrote:
>> richard <noreply@example.com> wrote in news:2y4pesy8rb8f$.7qsm5tfx3b6l$.dlg@
>> 40tude.net:
>>
>>> On Fri, 28 Jun 2013 21:11:56 -0400, Lew Pitcher wrote:
>>>> It looks like your hosting service provides the PHP level that supports
>>>> mysqli(). So, ISTM, there's nothing stopping you from writing your PHP
>>>> scripts to use the mysqli() interface.
>>> the script I used had mysqli and it would not work that way.
>>>
>> In other words... you didn't write it, and you don't have a clue how to fix it, eh?
> Hehe.
> 
> reminds me of a friend of mine walking into a company that had written a 
> vast commercial package in GWBASIC.
> 
> She  said 'I am not touching this till there is a flow chart' She drew 
> it on a roll of wallpaper and pinned it to the wall. It was  still there 
> when she left a couple of years later.;

Heh.
I took a computer class once that was supposed to educate us on the
workings of BASIC. It was really a waste of my time because I knew more
about it than the instructor did.

One guy had written a piece of code that was something like:
If a<>b and c<>d then do this.
The instructor had no clues why it did not work.

When I wanted to do an input statement, I always included the semicolon at
the end.
input a$;
She always marked it as wrong.

For those of you who may still be interested in BASIC, you might want to
take a look at "liberty basic". www.libertybasic.com
It's BASIC on steroids and functions inside windows.
I find it very helpful when wanting to make a huge list of something.
LB also has some similarities to PHP.

[toc] | [prev] | [next] | [standalone]

#9973

In article <kqmqs0$k4u$1@news.albasani.net>,
 The Natural Philosopher <tnp@invalid.invalid> wrote:

> On 29/06/13 14:13, Doug Miller wrote:
> > richard <noreply@example.com> wrote in 
> > news:2y4pesy8rb8f$.7qsm5tfx3b6l$.dlg@
> > 40tude.net:
> >
> >> On Fri, 28 Jun 2013 21:11:56 -0400, Lew Pitcher wrote:
> >>> It looks like your hosting service provides the PHP level that supports
> >>> mysqli(). So, ISTM, there's nothing stopping you from writing your PHP
> >>> scripts to use the mysqli() interface.
> >> the script I used had mysqli and it would not work that way.
> >>
> > In other words... you didn't write it, and you don't have a clue how to fix 
> > it, eh?
> Hehe.
> 
> reminds me of a friend of mine walking into a company that had written a 
> vast commercial package in GWBASIC.
> 
> She  said 'I am not touching this till there is a flow chart' She drew 
> it on a roll of wallpaper and pinned it to the wall. It was  still there 
> when she left a couple of years later.;

Flow charts are a waste of time. Must be 45 years since I did one.

-- 
Tim

"That excessive bail ought not to be required, nor excessive fines imposed,
nor cruel and unusual punishments inflicted"  --  Bill of Rights 1689

[toc] | [prev] | [next] | [standalone]

#9987

On 29/06/13 22:37, Tim Streater wrote:
> In article <kqmqs0$k4u$1@news.albasani.net>,
> The Natural Philosopher <tnp@invalid.invalid> wrote:
>
>> On 29/06/13 14:13, Doug Miller wrote:
>> > richard <noreply@example.com> wrote in > 
>> news:2y4pesy8rb8f$.7qsm5tfx3b6l$.dlg@
>> > 40tude.net:
>> >
>> >> On Fri, 28 Jun 2013 21:11:56 -0400, Lew Pitcher wrote:
>> >>> It looks like your hosting service provides the PHP level that 
>> supports
>> >>> mysqli(). So, ISTM, there's nothing stopping you from writing 
>> your PHP
>> >>> scripts to use the mysqli() interface.
>> >> the script I used had mysqli and it would not work that way.
>> >>
>> > In other words... you didn't write it, and you don't have a clue 
>> how to fix > it, eh?
>> Hehe.
>>
>> reminds me of a friend of mine walking into a company that had 
>> written a vast commercial package in GWBASIC.
>>
>> She  said 'I am not touching this till there is a flow chart' She 
>> drew it on a roll of wallpaper and pinned it to the wall. It was  
>> still there when she left a couple of years later.;
>
> Flow charts are a waste of time. Must be 45 years since I did one.
>
well it was 35 years ago.

they make sense in procedural code of a certain sort


-- 
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to lead are elected by the least capable of producing, and where the members of society least likely to sustain themselves or succeed, are rewarded with goods and services paid for by the confiscated wealth of a diminishing number of producers.

[toc] | [prev] | [next] | [standalone]

#10037

On 29.06.2013 23:37, Tim Streater wrote:

> Flow charts are a waste of time. Must be 45 years since I did one.
>

By opening the source in Code visual to Flowchart, I get a flowchart 
drawn immediately and it is nice  to use for refactoring, at least with 
big procedures

[toc] | [prev] | [next] | [standalone]

#10038

Alf Christophersen wrote:

> On 29.06.2013 23:37, Tim Streater wrote:
>> Flow charts are a waste of time. Must be 45 years since I did one.
> 
> By opening the source in Code visual to Flowchart, I get a flowchart
> drawn immediately and it is nice  to use for refactoring, at least with
> big procedures

“the source in Code visual to Flowchart”?


PointedEars
-- 
    realism:    HTML 4.01 Strict
    evangelism: XHTML 1.0 Strict
    madness:    XHTML 1.1 as application/xhtml+xml
                                                    -- Bjoern Hoehrmann

[toc] | [prev] | [next] | [standalone]

#10043

On Sun, 07 Jul 2013 23:15:29 +0200, Thomas 'PointedEars' Lahn
<PointedEars@web.de> wrote:

>Alf Christophersen wrote:
>
>> On 29.06.2013 23:37, Tim Streater wrote:
>>> Flow charts are a waste of time. Must be 45 years since I did one.
>> 
>> By opening the source in Code visual to Flowchart, I get a flowchart
>> drawn immediately and it is nice  to use for refactoring, at least with
>> big procedures
>
>“the source in Code visual to Flowchart”?
>
>
>PointedEars

http://download.cnet.com/Code-Visual-to-Flowchart/3000-2212_4-10072756.html

[toc] | [prev] | [next] | [standalone]

#9955

On 6/28/2013 5:39 PM, richard wrote:
> Y'all keep bashing me about switching to mysqli.
> Well buttheads, as I see it, it ain't MY choice.
> It is the decision of those that host the servers.
> After all, where does mysql or mysqli reside? On my machine?

Richard, do you think us buttheads are telling you to switch just to 
make things harder for you?

In reference to mysql_query on the following page:
http://php.net/manual/en/function.mysql-query.php

When you looked at the manual for mysql_query, which you say you did 
below, what does the following sentence mean to you?

"This extension is deprecated as of PHP 5.5.0, and will be removed in 
the future."

And then WAAAAY down the page, lets say 3-4 next sentences it tells you 
your alternatives with links to how to do it.

If you use hostgator as a previous reply posted, so do I and I use the 
mysqli functions.  Just follow the manual and use either the OO or 
procedural method depending on how your framework is set up.

http://php.net/manual/en/mysqli.quickstart.dual-interface.php

>
> You also say I never read the frickin manuals.
> BULLSHIT!

Redefined BS to mean 'you are correct'.

Just joking don't blow a gasket.

> I read them a lot. On practically every issue I come across.
> Just so that I can try to understand what it is I want to do.
>
> But there are those times when the manuals don't always cover what I want
> to know.

This last particular post WAS covered in the manual.  Can you show me 
where it may have confused you on the order of arguments which was you 
problem?

> I also do a ton of searching through google.
> BEFORE I post here.
> And sometimes I find what I need AFTER I post here.

In my own opinion try to use Bing instead.  But with that said, as long 
as you have been working on the project and the tons to searching you 
have done, you should have a handful of reliable sources to go to 
without much more engine searching.

> I may have been tagged as "stupid", but that doesn't mean I am not capable
> of learning.

I personally have not called you stupid, but I did say you don not take 
notes when you are given solutions to basic function usage.

I have personally however sent you to the php->mysql link on how to use 
the mysql_query in the past along with the warning to switch.

My serious short coming is I forget many things while I am coding so I 
keep a notebook on some basic things and when an issue pops up, I 
probably have already had it solved either here or elsewhere.

You may want to consider the same approach.

>
> On my music site, I have written the scripts to make it work the way I want
> and I'd say I've done a damn decent job of it.
> And if something doesn't validate, I find out why and correct it.
> That's a lot more than what major powerhouses like Google can say
>
> Running google.com through the validator shows 25 error and 4 warnings.
> mroldies.net validates with only 2 minor warnings.
> msnbc.com contains 140 errors and 31 warnings.
> microsoft.com contains 520 errors and 482 warnings!
>
> And these highly professional people get paid for their shitty ass work?
>

[toc] | [prev] | [next] | [standalone]

#9956

On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:

> On 6/28/2013 5:39 PM, richard wrote:
>> Y'all keep bashing me about switching to mysqli.
>> Well buttheads, as I see it, it ain't MY choice.
>> It is the decision of those that host the servers.
>> After all, where does mysql or mysqli reside? On my machine?
> 
> Richard, do you think us buttheads are telling you to switch just to 
> make things harder for you?
> 
> In reference to mysql_query on the following page:
> http://php.net/manual/en/function.mysql-query.php
> 
> When you looked at the manual for mysql_query, which you say you did 
> below, what does the following sentence mean to you?
> 
> "This extension is deprecated as of PHP 5.5.0, and will be removed in 
> the future."
> 
> And then WAAAAY down the page, lets say 3-4 next sentences it tells you 
> your alternatives with links to how to do it.
> 
> If you use hostgator as a previous reply posted, so do I and I use the 
> mysqli functions.  Just follow the manual and use either the OO or 
> procedural method depending on how your framework is set up.
> 
> http://php.net/manual/en/mysqli.quickstart.dual-interface.php
> 
>>
>> You also say I never read the frickin manuals.
>> BULLSHIT!
> 
> Redefined BS to mean 'you are correct'.
> 
> Just joking don't blow a gasket.
> 
>> I read them a lot. On practically every issue I come across.
>> Just so that I can try to understand what it is I want to do.
>>
>> But there are those times when the manuals don't always cover what I want
>> to know.
> 
> This last particular post WAS covered in the manual.  Can you show me 
> where it may have confused you on the order of arguments which was you 
> problem?
> 
>> I also do a ton of searching through google.
>> BEFORE I post here.
>> And sometimes I find what I need AFTER I post here.
> 
> In my own opinion try to use Bing instead.  But with that said, as long 
> as you have been working on the project and the tons to searching you 
> have done, you should have a handful of reliable sources to go to 
> without much more engine searching.
> 
>> I may have been tagged as "stupid", but that doesn't mean I am not capable
>> of learning.
> 
> I personally have not called you stupid, but I did say you don not take 
> notes when you are given solutions to basic function usage.
> 
> I have personally however sent you to the php->mysql link on how to use 
> the mysql_query in the past along with the warning to switch.
> 
> My serious short coming is I forget many things while I am coding so I 
> keep a notebook on some basic things and when an issue pops up, I 
> probably have already had it solved either here or elsewhere.
> 
> You may want to consider the same approach.
> 
>>
>> On my music site, I have written the scripts to make it work the way I want
>> and I'd say I've done a damn decent job of it.
>> And if something doesn't validate, I find out why and correct it.
>> That's a lot more than what major powerhouses like Google can say
>>
>> Running google.com through the validator shows 25 error and 4 warnings.
>> mroldies.net validates with only 2 minor warnings.
>> msnbc.com contains 140 errors and 31 warnings.
>> microsoft.com contains 520 errors and 482 warnings!
>>
>> And these highly professional people get paid for their shitty ass work?
>>

are you saying then that mysqli_result() should be used instead of
mysql_query()?

[toc] | [prev] | [next] | [standalone]

#9960

On 6/28/2013 6:50 PM, richard wrote:
> On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:
>
>> On 6/28/2013 5:39 PM, richard wrote:
>>> Y'all keep bashing me about switching to mysqli.
>>> Well buttheads, as I see it, it ain't MY choice.
>>> It is the decision of those that host the servers.
>>> After all, where does mysql or mysqli reside? On my machine?
>>
>> Richard, do you think us buttheads are telling you to switch just to
>> make things harder for you?
>>
>> In reference to mysql_query on the following page:
>> http://php.net/manual/en/function.mysql-query.php
>>
>> When you looked at the manual for mysql_query, which you say you did
>> below, what does the following sentence mean to you?
>>
>> "This extension is deprecated as of PHP 5.5.0, and will be removed in
>> the future."
>>
>> And then WAAAAY down the page, lets say 3-4 next sentences it tells you
>> your alternatives with links to how to do it.
>>
>> If you use hostgator as a previous reply posted, so do I and I use the
>> mysqli functions.  Just follow the manual and use either the OO or
>> procedural method depending on how your framework is set up.
>>
>> http://php.net/manual/en/mysqli.quickstart.dual-interface.php
>>
>>>
>>> You also say I never read the frickin manuals.
>>> BULLSHIT!
>>
>> Redefined BS to mean 'you are correct'.
>>
>> Just joking don't blow a gasket.
>>
>>> I read them a lot. On practically every issue I come across.
>>> Just so that I can try to understand what it is I want to do.
>>>
>>> But there are those times when the manuals don't always cover what I want
>>> to know.
>>
>> This last particular post WAS covered in the manual.  Can you show me
>> where it may have confused you on the order of arguments which was you
>> problem?
>>
>>> I also do a ton of searching through google.
>>> BEFORE I post here.
>>> And sometimes I find what I need AFTER I post here.
>>
>> In my own opinion try to use Bing instead.  But with that said, as long
>> as you have been working on the project and the tons to searching you
>> have done, you should have a handful of reliable sources to go to
>> without much more engine searching.
>>
>>> I may have been tagged as "stupid", but that doesn't mean I am not capable
>>> of learning.
>>
>> I personally have not called you stupid, but I did say you don not take
>> notes when you are given solutions to basic function usage.
>>
>> I have personally however sent you to the php->mysql link on how to use
>> the mysql_query in the past along with the warning to switch.
>>
>> My serious short coming is I forget many things while I am coding so I
>> keep a notebook on some basic things and when an issue pops up, I
>> probably have already had it solved either here or elsewhere.
>>
>> You may want to consider the same approach.
>>
>>>
>>> On my music site, I have written the scripts to make it work the way I want
>>> and I'd say I've done a damn decent job of it.
>>> And if something doesn't validate, I find out why and correct it.
>>> That's a lot more than what major powerhouses like Google can say
>>>
>>> Running google.com through the validator shows 25 error and 4 warnings.
>>> mroldies.net validates with only 2 minor warnings.
>>> msnbc.com contains 140 errors and 31 warnings.
>>> microsoft.com contains 520 errors and 482 warnings!
>>>
>>> And these highly professional people get paid for their shitty ass work?
>>>
>
> are you saying then that mysqli_result() should be used instead of
> mysql_query()?
>

Your in the ball park.

You use the mysqli_query() to pass the query to the engine and then use 
the mysqli_results() to parse the results from what the query returned.

Now the connection function is also different as well so pay attention 
to that.

Here is a link on how to do a simple query with results.

http://www.php.net/manual/en/mysqli-result.fetch-assoc.php

This one uses fetch_assoc but there are several different ones depending 
on how you want your results structured.

Now pay attention to the manual because mysql is dual wielding.  You can 
use either Object notation or Procedure notation.

One major point to ummm point out.  If you use the procedure notation, 
the mysqli_query order of arguments is opposite of the mysql_query.

I know it sucks trying to learn a new way of doings things but in the 
long run you will thank yourself for doing so.

[toc] | [prev] | [next] | [standalone]

#9991

On Fri, 28 Jun 2013 19:58:09 -0700, Scott Johnson
<noonehome@chalupasworld.com> wrote:

>On 6/28/2013 6:50 PM, richard wrote:
>> On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:
>>
>>> On 6/28/2013 5:39 PM, richard wrote:
>>>> Y'all keep bashing me about switching to mysqli.
>>>> Well buttheads, as I see it, it ain't MY choice.
>>>> It is the decision of those that host the servers.
>>>> After all, where does mysql or mysqli reside? On my machine?
>>>
>>> Richard, do you think us buttheads are telling you to switch just to
>>> make things harder for you?
>>>
>>> In reference to mysql_query on the following page:
>>> http://php.net/manual/en/function.mysql-query.php
>>>
>>> When you looked at the manual for mysql_query, which you say you did
>>> below, what does the following sentence mean to you?
>>>
>>> "This extension is deprecated as of PHP 5.5.0, and will be removed in
>>> the future."
>>>
>>> And then WAAAAY down the page, lets say 3-4 next sentences it tells you
>>> your alternatives with links to how to do it.
>>>
>>> If you use hostgator as a previous reply posted, so do I and I use the
>>> mysqli functions.  Just follow the manual and use either the OO or
>>> procedural method depending on how your framework is set up.
>>>
>>> http://php.net/manual/en/mysqli.quickstart.dual-interface.php
>>>
>>>>
>>>> You also say I never read the frickin manuals.
>>>> BULLSHIT!
>>>
>>> Redefined BS to mean 'you are correct'.
>>>
>>> Just joking don't blow a gasket.
>>>
>>>> I read them a lot. On practically every issue I come across.
>>>> Just so that I can try to understand what it is I want to do.
>>>>
>>>> But there are those times when the manuals don't always cover what I want
>>>> to know.
>>>
>>> This last particular post WAS covered in the manual.  Can you show me
>>> where it may have confused you on the order of arguments which was you
>>> problem?
>>>
>>>> I also do a ton of searching through google.
>>>> BEFORE I post here.
>>>> And sometimes I find what I need AFTER I post here.
>>>
>>> In my own opinion try to use Bing instead.  But with that said, as long
>>> as you have been working on the project and the tons to searching you
>>> have done, you should have a handful of reliable sources to go to
>>> without much more engine searching.
>>>
>>>> I may have been tagged as "stupid", but that doesn't mean I am not capable
>>>> of learning.
>>>
>>> I personally have not called you stupid, but I did say you don not take
>>> notes when you are given solutions to basic function usage.
>>>
>>> I have personally however sent you to the php->mysql link on how to use
>>> the mysql_query in the past along with the warning to switch.
>>>
>>> My serious short coming is I forget many things while I am coding so I
>>> keep a notebook on some basic things and when an issue pops up, I
>>> probably have already had it solved either here or elsewhere.
>>>
>>> You may want to consider the same approach.
>>>
>>>>
>>>> On my music site, I have written the scripts to make it work the way I want
>>>> and I'd say I've done a damn decent job of it.
>>>> And if something doesn't validate, I find out why and correct it.
>>>> That's a lot more than what major powerhouses like Google can say
>>>>
>>>> Running google.com through the validator shows 25 error and 4 warnings.
>>>> mroldies.net validates with only 2 minor warnings.
>>>> msnbc.com contains 140 errors and 31 warnings.
>>>> microsoft.com contains 520 errors and 482 warnings!
>>>>
>>>> And these highly professional people get paid for their shitty ass work?
>>>>
>>
>> are you saying then that mysqli_result() should be used instead of
>> mysql_query()?
>>
>
>Your in the ball park.
>
>You use the mysqli_query() to pass the query to the engine and then use 
>the mysqli_results() to parse the results from what the query returned.
>
>Now the connection function is also different as well so pay attention 
>to that.
>
>Here is a link on how to do a simple query with results.
>
>http://www.php.net/manual/en/mysqli-result.fetch-assoc.php
>
>This one uses fetch_assoc but there are several different ones depending 
>on how you want your results structured.
>
>Now pay attention to the manual because mysql is dual wielding.  You can 
>use either Object notation or Procedure notation.
>
>One major point to ummm point out.  If you use the procedure notation, 
>the mysqli_query order of arguments is opposite of the mysql_query.
>
>I know it sucks trying to learn a new way of doings things but in the 
>long run you will thank yourself for doing so.

When I converted a 200+ page site to mysqli I found this tool to be
very helpful: 

https://wikis.oracle.com/display/mysql/Converting+to+MySQLi

You do have to do some preparation of the scripts first, and some
tidyhing up afterward) but the tool then does nearly all of the
conversion automatically.

Richard Yates

[toc] | [prev] | [next] | [standalone]

#9957

On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:

> On 6/28/2013 5:39 PM, richard wrote:
>> Y'all keep bashing me about switching to mysqli.
>> Well buttheads, as I see it, it ain't MY choice.
>> It is the decision of those that host the servers.
>> After all, where does mysql or mysqli reside? On my machine?
> 
> Richard, do you think us buttheads are telling you to switch just to 
> make things harder for you?
> 
> In reference to mysql_query on the following page:
> http://php.net/manual/en/function.mysql-query.php
> 
> When you looked at the manual for mysql_query, which you say you did 
> below, what does the following sentence mean to you?
> 
> "This extension is deprecated as of PHP 5.5.0, and will be removed in 
> the future."
> 
> And then WAAAAY down the page, lets say 3-4 next sentences it tells you 
> your alternatives with links to how to do it.
> 
> If you use hostgator as a previous reply posted, so do I and I use the 
> mysqli functions.  Just follow the manual and use either the OO or 
> procedural method depending on how your framework is set up.
> 
> http://php.net/manual/en/mysqli.quickstart.dual-interface.php
> 
>>
>> You also say I never read the frickin manuals.
>> BULLSHIT!
> 
> Redefined BS to mean 'you are correct'.
> 
> Just joking don't blow a gasket.
> 
>> I read them a lot. On practically every issue I come across.
>> Just so that I can try to understand what it is I want to do.
>>
>> But there are those times when the manuals don't always cover what I want
>> to know.
> 
> This last particular post WAS covered in the manual.  Can you show me 
> where it may have confused you on the order of arguments which was you 
> problem?
> 
>> I also do a ton of searching through google.
>> BEFORE I post here.
>> And sometimes I find what I need AFTER I post here.
> 
> In my own opinion try to use Bing instead.  But with that said, as long 
> as you have been working on the project and the tons to searching you 
> have done, you should have a handful of reliable sources to go to 
> without much more engine searching.
> 
>> I may have been tagged as "stupid", but that doesn't mean I am not capable
>> of learning.
> 
> I personally have not called you stupid, but I did say you don not take 
> notes when you are given solutions to basic function usage.
> 
> I have personally however sent you to the php->mysql link on how to use 
> the mysql_query in the past along with the warning to switch.
> 
> My serious short coming is I forget many things while I am coding so I 
> keep a notebook on some basic things and when an issue pops up, I 
> probably have already had it solved either here or elsewhere.
> 
> You may want to consider the same approach.
> 
>>
>> On my music site, I have written the scripts to make it work the way I want
>> and I'd say I've done a damn decent job of it.
>> And if something doesn't validate, I find out why and correct it.
>> That's a lot more than what major powerhouses like Google can say
>>
>> Running google.com through the validator shows 25 error and 4 warnings.
>> mroldies.net validates with only 2 minor warnings.
>> msnbc.com contains 140 errors and 31 warnings.
>> microsoft.com contains 520 errors and 482 warnings!
>>
>> And these highly professional people get paid for their shitty ass work?
>>

Or would this be the more proper way of doing mysql_query()?

http://www.php.net/manual/en/mysqli-result.data-seek.php

[toc] | [prev] | [next] | [standalone]

#9961

On 6/28/2013 6:54 PM, richard wrote:
> On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:

<snip>

>
> Or would this be the more proper way of doing mysql_query()?
>
> http://www.php.net/manual/en/mysqli-result.data-seek.php
>

I have not used data_seek but it just seems like a way to place a 
pointer in the result set.  Not 100% since I just glanced at it.

Look at the fecth_???? methods but with the mysqli_query not the 
mysql_query.   The (i) is the key.

And if you have issues getting it to work just throw the code you are 
using up here and I am sure someone can help since you are updating your 
code.

[toc] | [prev] | [next] | [standalone]

#9962

Scott Johnson wrote:

> On 6/28/2013 6:54 PM, richard wrote:
>> On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:
> <snip>
>> Or would this be the more proper way of doing mysql_query()?
>>
>> http://www.php.net/manual/en/mysqli-result.data-seek.php
>>
> 
> I have not used data_seek but it just seems like a way to place a
> pointer in the result set.  Not 100% since I just glanced at it.
> 
> Look at the fecth_???? methods but with the mysqli_query not the
> mysql_query.   The (i) is the key.
> 
> And if you have issues getting it to work just throw the code you are
> using up here and I am sure someone can help since you are updating your
> code.

Sorry to kill the mysqli hype here, but the most intuitive and easiest to 
learn database API to replace mysql is by far PHP Data Objects (PDO), which 
is stable since PHP 5.1 (2005) [1].  It is also database-agnostic.  Use that 
instead of mysql(i) if possible.  And avoid servers running PHP < 5.3 if you 
value your data.  The last PHP 5.2.x was released more than two years ago. 
[2]


[1] <http://php.net/pdo>
[2] <http://php.net/ChangeLog-5.php>


PointedEars
-- 
var bugRiddenCrashPronePieceOfJunk = (
    navigator.userAgent.indexOf('MSIE 5') != -1
    && navigator.userAgent.indexOf('Mac') != -1
)  // Plone, register_function.js:16

[toc] | [prev] | [next] | [standalone]

#9968

On 6/28/2013 8:43 PM, Thomas 'PointedEars' Lahn wrote:
> Scott Johnson wrote:
>
>> On 6/28/2013 6:54 PM, richard wrote:
>>> On Fri, 28 Jun 2013 18:36:42 -0700, Scott Johnson wrote:
>> <snip>
>>> Or would this be the more proper way of doing mysql_query()?
>>>
>>> http://www.php.net/manual/en/mysqli-result.data-seek.php
>>>
>>
>> I have not used data_seek but it just seems like a way to place a
>> pointer in the result set.  Not 100% since I just glanced at it.
>>
>> Look at the fecth_???? methods but with the mysqli_query not the
>> mysql_query.   The (i) is the key.
>>
>> And if you have issues getting it to work just throw the code you are
>> using up here and I am sure someone can help since you are updating your
>> code.
>
> Sorry to kill the mysqli hype here, but the most intuitive and easiest to
> learn database API to replace mysql is by far PHP Data Objects (PDO), which
> is stable since PHP 5.1 (2005) [1].  It is also database-agnostic.  Use that
> instead of mysql(i) if possible.  And avoid servers running PHP < 5.3 if you
> value your data.  The last PHP 5.2.x was released more than two years ago.
> [2]
>
>
> [1] <http://php.net/pdo>
> [2] <http://php.net/ChangeLog-5.php>
>
>
> PointedEars
>

Not sure if I would call it a hype, just giving an alternative to what 
is being used that I am familiar with.

PDO may be an option worth exploring.

[toc] | [prev] | [next] | [standalone]

#9959

</killfile>

richard wrote:

> I may have been tagged as "stupid", but that doesn't mean I am not capable
> of learning.

Then *finally* *show* *us[tm]* that you are capable of learning:

- Use a proper From
- RTFM before you post
- STFW before you post
- Do not insult the people who have helped you and could help you again
- etc.

See also: <http://www.catb.org/~esr/faqs/smart-questions.html>

Or FOAD.

<killfile>

[toc] | [prev] | [next] | [standalone]

Page 1 of 2  [1] 2  Next page →

Back to top | Article view | comp.lang.php

csiph-web