PHP Developers Network

Pyrite

and then if you really want to get fancy ...

SELECT @row := @row + 1 as counter, t.* FROM users t, (SELECT @row := 0) r

Then you can just do:

Code: Select all

while ($ma = mysql_fetch_array($result)) {
	echo $ma['counter'] . ':' . $ma['username'] . "\n";
}

Pyrite

Just don't select *, and either use everything you select in the GROUP BY clause or use an aggregate function (like COUNT() perhaps).

Pyrite

What do you mean by dynamic sequences?

I use Postgres, and seqs are created/used automatically for serial types.

Not sure what you are asking.

Pyrite

Try using the General Query Log feature in MySQL.

http://dev.mysql.com/doc/refman/5.1/en/query-log.html

Also, many PHP frameworks log this as well, with certain debug levels turned on (e.g. CakePHP with Debug Level 2).

Pyrite

Hello, I'm Pyrite, I've been using PHP since 1999, and been a member of devnet for several years. For the last 2+ years at work, I've been using CakePHP for rapid web development. I'm not a CakePHP expert, but I just wanted to introduce myself, and I'll try to help others using this framework. Cheer...

Pyrite

Jason, thank you for granting my wish for a home for CakePHP :) The frameworks forum you made is perfect. I do however disagree about your assessments of Cake, CakePHP code is really its own code, as compared to PHP code. Comparatively speaking, it would be like writing Java Desktop apps versus say ...

Pyrite

I have a table that looks like this (people that play on my game servers): id|name|ip|guid And I have a search page, that basically does this: $sql = "SELECT id, name, INET_NTOA(ip) AS ip, guid FROM 1up_people WHERE (name LIKE \"%$query%\" OR INET_NTOA(ip) LIKE \"%$query%\" ...

Pyrite

I have written phpDoc for several companies, that being said, I'll offer a few pieces of advice. Firstly, you seem to have most of your methods phpDoc'ed. Sorry, do you want me to say functions? Ha. But what about your constructor? It equally is important, Also what about your member variables? They...

Pyrite

Hmm, looks like I fixed it. I just added some \s* around the (.*?) and that seems to have fixed it.

Code: Select all

preg_match_all("/^\s*(\d+)\s*(-{0,1}\d+|CNCT|ZMBI)\s*(\d+)\s*(.*?)\s*(\d*)\s*(\S*)\s*(\d*)\s*(\d*)\s*$/", $line, $out);

Pyrite

In the game Urban Terror, you can issue a rcon command called status which returns something like: [text] map: ut4_algiers num score ping name lastmsg address qport rate --- ----- ---- --------------- ------- --------------------- ----- ----- 4 1 45 {&}TheBrew 0 74.97.237.134:27960 13024 8000 5 ...

Pyrite

Anything ever become of this idea? I've been using CakePHP at work for over a year now, sure do wish there was more of a cake community here

Pyrite

Why not try GimpShop ?

Pyrite

It would be just lovely if there was a forum devoted to development with the MVC way of programming with PHP, if not specifically for the ruby on rails like framework known as CakePHP.

What do you think?

Pyrite

Admining a Linux server starts to be a pain when all the accounts for all the types of services are in seperate places. I'd like to store all the accounts in one place on the server, and have all the services (including local accounts/ssh etc) authenticate against it. This would include Apache, Samb...

Pyrite

Awesome!, so the real question is, can PHP parse the PDF?

I've seen many classes to create them, not many to read/parse them though?

PHP Developers Network

Search found 766 matches

Re: Php mysql database question?

Re: Basic Query, where no row contains a certain word - how?

Re: Linking sequences with tables

Re: How do I get a prepared query as it will execute?

[CakePHP] Introduce myself

Re: CakePHP

SQL Design Help (self join, sorta)

Re: Example code for new job

Re: Need Help with Regex

[FIXED] Need Help with Regex

Re: CakePHP

Re: photoshop

CakePHP

Centralized Server

Re: Design Question