RE: [PHP-DB] NC takes forever to connect to the db
Similar yes, solution no... But it seem only to happen when I test on my internal test enviroment, not when deployed on more serious installed FreeBSD or Solaris servers. (Internally I use a Win2k Prof. installation *sigh*) / LJ -Original Message- From: Andy [mailto:[EMAIL PROTECTED]] Sent: 11. december 2001 21:45 To: [EMAIL PROTECTED] Subject: [PHP-DB] NC takes forever to connect to the db Hello, my application works fine with IE, but running it on NC it takes on certain connections forever to get a response from the server. But here it comes... as soon as I click on another window for example make Outlook the aktive window. NC connects in the backgroud fast as light! So what the hack is going on? Does anybody have similar experiance? Thanx for any help! Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
*laugh* I was reading this and thought to reply simply for the fact Søren is fellow danish guy, but refrained momentarily till I got this one... There are many alternatives to mySQL and much more commercial too... Try get your hotshot boss to belive in mySQL rather from business buzzword Oracle (by know, I think 95% know Oracle is the major db engine - especially on the ridiculus pricetag it comes with), but MSSQL, Sybase, PostgreSQL, Informix, Paradox ect ect ect. Okay, I am a bit colored by my short but exiting experience over 4 years pro. Since the zend guys came into the picture with the rewriting of php engine they worked quite close with monty and the boyz over at mySQL... The integration between these two systems is one of the closest and seemlessly I have seen to date, with experience from IPerForm/MSSQL6.5(later 7.0) - if you dont know IPerForm, be happy about it and never think of it - JSP/Servlet/Oracle and latest PHP/mySQL. It is unique, fast and never a problem needless what platform it runs on (though I advice noone to do Windowshosting with PHP/mySQL *ouch* can already feel I'm being dragged outside and beaten upon - Windows if for testing and development only, I always run on FreeBSD or Linux servers and it ruuuns smth) Hmm, about the Nasa part, I never conducted business quite like the guys at Nasa so I presume my needs is quite different - prefer to find the optimal solution... Heck, there are alot of bigshot sites out there running ASP *www* does that mean it is the optimal solution ? Wasn't it Ratschiller / Gerken (sorry if I got the names wrong) who had an entire chapter about the PHP / mySQL tieup - well, check their book out, I dont agree with it in full but it has its great parts... :) Enough storytelling, goodluck on your assignment / Lars PS. Søren, skriv hvis der er noget... Jeg har arbejdet de sidste par år med PHP / mySQL for firmaer som TDC KabelTV og lign. -Original Message- From: PHPGalaxy.com [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:38 To: søren eriksen Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Why use MySQL with PHP My reasons: 1) Heard of Oracle, didnt know it was a database program 2) Never heard of PostgreSQL 3) MySQL is the most talked about, from what I've seen, so there's plenty of people to get help from 4) It's free. 5) It runs in Windows 5) NASA uses it, or so their site says 6) It works! So I've no need to switch to anything else 7) Most PHP webhosting services offer only MySQL. 8) Gotta love that lil dolphin! søren eriksen wrote: Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
Well, need to hook up on mysql.com to check it out... 4.0 is already out on development, but even I tend to tell my clients I am on the cutting-edge *laugh* yeah, I know - bullshit buzzword - I prefer it to be stable releases before relying even remotely on these. mySQL 4.1 will become VERY exciting with the fulltext indexing (more than a mere OR search), Stored Procedures and even they promise an performance increase... hmm, our buddies at mySQL seem to make alot of promises, lets just hope they are not like politicians and actually will put a product behind the words to back it up. Monty and co. got my confidence, I look forward playing with a new toy. Refs : http://www.mysql.com/products/mysql-4.0/index.html And : http://www.mysql.com/news/article-81.html / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 21:32 To: 'Lars B. Jensen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP sounds wonderful - do you know when (roughly) it's gonna be released? I thought that one of the reasons it was so fast was that the DB engine wasn't cluttered with procedures? (which is why it's so damn good for not-so-complicated sites)? i'm no expert at all, but won't mySQL 4 therefore be slower? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 12:19 To: matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail
RE: [PHP-DB] phpdb error, need help
Clay, Looks like a small tweak in php.ini will do the trick for you. You can change the error_reporting below to something like error_reporting = E_ALL ~(E_NOTICE | E_USER_NOTICE); The problem seems to be caused since the developers of the phpdb wrapper relies on the fact that a variable will be initialised automatically by PHP - heck, I often do that myself in simple vars, not arrays ect ofcourse. Try it and report back if it works or if you need further assistance Lars B. Jensen, CEO and Founder LJWeb GmbH www.ljweb.com -Original Message- From: Clay Culver [mailto:[EMAIL PROTECTED]] Sent: 14. november 2001 12:21 To: PHP DB List Subject: [PHP-DB] phpdb error, need help Hi, I have been using the phpdb wrapper on http://phpdb.linuxbox.com for about a year now, and have used it to great extent. But now as I have built a new http server for my company I seem to be getting an error with it and the URL for the wrapper is not resolving so tech help there won't work and there is no email address for the author listed. The error is this [Quote] Warning: Undefined variable: boolDBSelected in D:\Inetpub\hells_horses\database\phpDB-mysql.lib on line 110 [/Quote] You can view this in action here http://207.216.247.148/hells_horses/database/codex/roster.php To view what it should be doing go here http://chh.darkness-is.com/database/codex/roster.php I have put the phpdb.inc and the phpdb-mysql.lib in to a zip file and it can be downloaded here http://chh.darkness-is.com/files/phpdb.zip below is the code that I use to use this in a php page. [Quote] ?php include(phpDB.inc); $db = new phpDB(); $db-connect(localhost, guest, guest, CHH); ? The only major changes to how I have the server setup is the fact I am using PHP 4.0.6 and MySQL 3.23.44 the rest of the server information is as follows. [Quote] 2xPII Xeon 450 w/2MB cache MSI 6135 Revision 1 2x512 ECC Registered Corsair PC100 RAM 2xQuantim 18.9GB SCSI-3 7200 RPM HDD 1x12GB Fujitsu EIDE 7200 RPM HDD Windows 2000 Server w/SP2 and all the Windows Updates [/Quote] Clay Culver [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Can't connect Mysql using php
you need to install your PHP using ./configure --with-mysql rather than ./configure --without-mysql / LJ -Original Message- From: Jae [mailto:[EMAIL PROTECTED]] Sent: 27. september 2001 13:05 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Can't connect Mysql using php './configure' '--prefix=/usr' '--with-config-file-path=/etc' '--disable-debug' '--enable-pic' '--enable-shared' '--enable-inline-optimization' '--with-apxs=/usr/sbin/apxs' '--with-exec-dir=/usr/bin' '--with-regex=system' '--with-gettext' '--with-gd' '--with-jpeg-dir=/usr' '--with-png' '--with-zlib' '--with-db2' '--with-db3' '--with-gdbm' '--enable-debugger' '--enable-magic-quotes' '--enable-safe-mode' '--enable-sockets' '--enable-sysvsem' '--enable-sysvshm' '--enable-track-vars' '--enable-yp' '--enable-ftp' '--enable-wddx' '--without-mysql' '--without-oracle' '--without-oci8' '--with-xml' thx Jason Wong [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó 000a01c14674$87e58080$[EMAIL PROTECTED]">news:000a01c14674$87e58080$[EMAIL PROTECTED]... -Original Message- From: Jae [mailto:[EMAIL PROTECTED]] Sent: 26 September 2001 17:41 To: [EMAIL PROTECTED] Subject: [PHP-DB] Can't connect Mysql using php ±H¥óªÌ: Jae [EMAIL PROTECTED] ¦¬¥óªÌ: [EMAIL PROTECTED] ¥D¦®: Re: Error on connecting to mysql database ¤é´Á: 2001¦~9¤ë26¤é ¤U¤È 05:09 After recompile, the error still occurs. pls help Jae [EMAIL PROTECTED] ¼¶¼g©ó¶l¥ó [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... I got this message when i call the php script, Fatal error: Call to undefined function: mysql_connect() in /home/jaelee/public_html/test01.php on line 6 what's wrong? thx Run ? phpinfo(); ? and tell us the output of the 3rd row of the first table, ie the Configure Command. -- Jason Wong Gremlins Associates www.gremlins.com.hk Tel: +852-2573-5033 Fax: +852-2573-5851 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] USA Attacks
Nostradamus died in 1566... I wonder who wrote or re-wrote that passage for the event... / LJ -Original Message- From: Danny N. [mailto:[EMAIL PROTECTED]] Sent: 13. september 2001 01:43 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] USA Attacks quite interesting from Nostradamus's passage!!! In the year of the new century and nine months,From the sky will come a great King of Terror... The sky will burn at forty-five degrees.Fire approaches the great new city... There will be a great thunder,Two brothers torn apart by Chaos, While the fortress endures,The great leader will succumb, The third big war will begin when the big city is burning --Nostradamus 1654 Mihai Marcian Dumitrescu [EMAIL PROTECTED] wrote: I'm sure that the killer will be destroyed. America will winn. Mihai Dumitrescu Romania -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] USA Attacks
It is replies like this that makes me understand the terrorism in the world... No doubt, it was a horrible act by cowards, but what comes up must come down. US has been playing with fire once too often and suddenly tasted their medicine - maybe time to rethink the world police strategy again. I feel sympathy for all who died in the incident for no cause. Dont get me wrong on that point ! / LJ -Original Message- From: Bartek Pawlik [mailto:[EMAIL PROTECTED]] Sent: 12. september 2001 14:35 To: [EMAIL PROTECTED] Subject: Odp: [PHP-DB] USA Attacks My deepest sympathy to all Americans, It's horrible, I can still believe it. Kill everyone who is involved into these attacks Bartek Pawlik Poland - Original Message - From: Steve Farmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 12, 2001 4:28 AM Subject: [PHP-DB] USA Attacks Hi, My heart goes out to all our American cousins in their time of tragedy. Steve Farmer -- --- Minds are like parachutes, they work best when open Support free speech; visit http://www.efa.org.au/ Heads Together Systems Pty Ltd http://www.hts.com.au Email: [EMAIL PROTECTED] Tel: 612 9982 6767 Fax: 612 9981 3081 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Zagraj z finalistkami Miss Polonia [ http://miss.onet.pl/start.html ] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] How can you hide database login passwd in your script?
a .php file is only viewable on the server if users have access to the site through eg. FTP, Telnet or alike. When displaying or trying to download a PHP file, the server will first execute it and return the result being your HTML output or result of function, without login information nor PHP content. / LJ LJWeb GmbH -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: 2. september 2001 13:55 To: [EMAIL PROTECTED] Subject: [PHP-DB] How can you hide database login passwd in your script? How can you hide database login passwd in your script? I hate having to have scripts with passwords in it that can be viewed by others. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
FW: [PHP-DB] Re: replace string - case insensitive
depending on what you're replacing with what, a solution is eregi_replace. I do not advice to upper nor lowercase the source as it will change parts of data unwantedly. / Lars www.ljweb.com -Original Message- From: Elman Cheng [mailto:[EMAIL PROTECTED]] Sent: 16. august 2001 10:41 To: J- E- N Cc: [EMAIL PROTECTED] Subject: [PHP-DB] Re: replace string - case insensitive try to change the string to uppercase or lowercase first. J- E- N wrote: hello str_replace is case sensitive, what function should i use for case insensitive. thanks very much. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Re: replace string - case insensitive
Hugh,
Looking through the code I am not doubting it works, but what I wonder if it
is really a preferred choice over for example reg. expressions ? You have
idea what would be the fastest performancewise choice here ?
/ LJ
-Original Message-
From: Hugh Bothwell [mailto:[EMAIL PROTECTED]]
Sent: 16. august 2001 12:17
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Re: replace string - case insensitive
Lars B. Jensen [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
depending on what you're replacing with what, a solution is eregi_replace.
I
do not advice to upper nor lowercase the source as it will change parts of
data unwantedly.
Yes, I agree; another solution is as follows:
function alt_str_replace($search, $replace, $subject) {
// Temporary copies of search string and subject string;
// both shifted to lowercase to make the search case insensitive.
$t_search = strtolower($search);
$t_subject = strtolower($subject);
// Initialize result string
$res = ;
// Initialize search vars
$search_offs = 0;
$shift = strlen($search);
// As long as another match is found...
while (($t = strpos($t_subject, $t_search, $search_offs)) !== false) {
// Copy non-matching portion of string
$res .= substr($subject, $search_offs, $t-$search_offs);
// Add replacement value
$res .= $replace;
// Update search offset
$search_offs = $t + $shift;
}
// Add trailing end of string
$res .= substr($subject, $search_offs);
return $res;
}
Hope that helps...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] start over on database read inorder to read from the beggining again
To run with less overhead, I would advice to only access the database when
absolutely nessary. Therefor I would approach the problem with pasting the
database result into an array and then doing the work from here - an array
is much faster to work with rather than db.
An approach could be
?php
$connect = mysql_connect($host,$user,$pass) OR die(mysql_error());
$selectdb = mysql_select_db($db) OR die(mysql_error());
$result = mysql_query(SELECT * FROM teams where week='$list' ORDER BY
date);
if (!mysql_num_rows($result)) {
die (No results);
}
$res = array();
while($foo = mysql_fetch_row($result)) {
$res[] = $foo;
}
$resSize = sizeof($res);
# now add your code... loop through the array using
for ($i=0; $i$resSize; $i++) {
echo $res[$i][RowName];
}
?
/ Lars
LJWeb GmbH
www.ljweb.com
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: 14. august 2001 13:40
To: Caleb Walker; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] start over on database read inorder to read from
the beggining again
How can I run through a database like I am trying to do here? It seems
like
at the end of the first I need to start over in order to start reading
from
the beggining of the database on the second.
I hope that I hace explained my problem well if not please reply with your
questions. Thank you in advance.
Caleb
!--Snip--
$connect = mysql_connect($host,$user,$pass) OR (die(mysql_error));
$selectdb = mysql_select_db($db) OR (die(mysql_error));
$result = mysql_query(SELECT * FROM teams where week='$list' ORDER BY
date);
while($view = mysql_fetch_row($result))
{
code;
}
more code;
and html
while($view = mysql_fetch_row($result))
{
code;
}
try adding:
mysql_data_seek($result, 0);
before your second loop. This should reset your dataset so you can loop
again.
regards
--
Jason Wong
Gremlins Associates
www.gremlins.com.hk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Merge two arrays into associative arrays?
Have followed this group for a while, it is my turn to try send an response.
Would this angle with a for loop not be better than a foreach angle ?
?php
$a = array(1,2,3,4,5);
$b = array(a,b,c,d,e);
$c = array();
$arraysize = sizeof($a);
for ($i=0;$i$arraysize;$i++) {
$c[$a[$i]] = $b[$i];
}
?
/ Lars
www.ljweb.com
- Original Message -
From: Jonathan Hilgeman [EMAIL PROTECTED]
To: 'Shahmat Dahlan' [EMAIL PROTECTED]
Cc: PHP-DB (E-mail) [EMAIL PROTECTED]
Sent: Monday, May 21, 2001 6:10 PM
Subject: RE: [PHP-DB] Merge two arrays into associative arrays?
try:
$a=array(1,2,3,4,5);
$b=array(a,b,c,d,e);
$c = array();
foreach($a as $a_key = $a_value)
{
$c[$a_value] = $b[$a_key];
}
that should give you what you want.
Jonathan
-Original Message-
From: Shahmat Dahlan [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 21, 2001 12:23 AM
To: PHP-DB
Subject: [PHP-DB] Merge two arrays into associative arrays?
Is there anywhere possible for me to merge two arrays into associative
arrays?
e.g.
$a=array(1,2,3,4,5);
$b=array(a,b,c,d,e)
into
$c=array(1 = a, 2 = b, etc... )
Thanks in advance..
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
