php is not the only language susceptible to x-browser attacks... seems
unfair to single it out.
And as previously pointed out, many times it the developer's fault for
writing that insecure code
Bastien
From: JupiterHost.Net [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB]
http://www.weberdev.com/get_example-4236.html is an example that I wrote
that does this
bastien
From: Eustace [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] PHP/Mysql search
Date: Mon, 22 May 2006 14:58:59 +0200
Hello,
Please be patient and assist
Nah, he just needs to have the value in quotes when its presented as the
html form
bastien
From: Brad Bonkoski [EMAIL PROTECTED]
To: Andres Figari [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Pulling data - stops at spaces
Date: Wed, 24 May 2006 12:45:34 -0400
How does
I approach this by assigning a value to a variable and then comparing to see
if i need to write out a new title
$oldDVD = ;
while ($rows=mysql_fetch_array($result))
{
//decide whether to show the DVD title
if ($oldDVD != $rows['title'])
{
echo trtd.$rows['title']./td/tr;
$oldDVD =
test both and let us know
bastien
From: Andrew Darby [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQL/PHP Left Join Question
Date: Thu, 25 May 2006 12:33:15 -0400
Thanks to Bastien and TG for their suggestions. I'd been looking at
it Bastien's way, but TG's is probably
is $conn defined?
Bastien
From: Scott Wettstein [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] odbc_exec error
Date: Thu, 1 Jun 2006 14:19:50 -0500
I'm pretty new to PHP so I need help. I'm getting this error:
Error in updating SQL PHP Warning: odbc_exec()
google 'cross tab queries'...there is a php/mysql example (sorry travelling
and don't have the link) on who to create a cross table query which is what
you are looking for
Bastien
From: Blanton, Bob [EMAIL PROTECTED]
To:
[EMAIL PROTECTED],php-db@lists.php.net,[EMAIL PROTECTED]
Subject:
if you have these as strings, I would recommend a column data type
conversion to int(or other numeric as the case may be)failing that I
would use the CAST command to convert the data to numerics
see here
http://dev.mysql.com/doc/refman/4.1/en/cast-functions.html
to use
select
eval$code);
bastien
From: Mark Fellowes [EMAIL PROTECTED]
Reply-To: Mark Fellowes [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Generating forms and form elements
Date: Tue, 20 Jun 2006 15:37:10 GMT
Hi, Hitting up the list for maybe a decent link(s) or pointers.
I need to
whoops
eval ($code);
Bastien
From: Bastien Koert [EMAIL PROTECTED]
To: [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] Generating forms and form elements
Date: Tue, 20 Jun 2006 16:44:22 -0400
eval$code);
bastien
From: Mark Fellowes [EMAIL PROTECTED]
Reply-To: Mark Fellowes
Not commenting on the appropriateness or security of the eval function.
Merely offering a possible path. It is up to the OP to decide if that
solution is the correct one.
B
From: Stut [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], php-db@lists.php.net
Subject
I have fixed values that I adjust to, but you basically need to give the
frame an ID and then use .rows and.columns to adjust the size
function shrink() {
top.document.getElementById(TOP).rows = 65,*,0,46,0;
}
function expand() {
top.document.getElementById(TOP).rows = 65,*,200,46,0;
}
$val = number_format($row['val'],2);
Bastien
From: Mark Bomgardner [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Php-Db php-db@lists.php.net
Subject: [PHP-DB] Converting to Decimal
Date: Wed, 28 Jun 2006 17:20:21 -0500
I am query a database and pulling some decimal values out of the
why no use phpmyadmin to admin the db?
Bastien
From: Jeffrey [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] mysqldump via php
Date: Thu, 29 Jun 2006 12:38:51 +0200
I would like to do a backup of an entire MySQL database via php. My thought
was to use mysqldump, write
I am not sure that any dbs will do thati usually run two queries (one
for the limit data and one for the total rows)
Bastien
From: chris smith [EMAIL PROTECTED]
To: Dwight Altman [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] LIMIT
Date: Sat, 1 Jul 2006 18:51:11 +1000
Your example predicates that the resultset it passed to an array which you
then take the size of, which would only give you the LIMIT value if that
clause is specified in the query...
Bastien
From: JupiterHost.Net [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] LIMIT
Date:
http://www.sitepoint.com/article/php-gallery-system-minutes is a great
aticle with code on this...
bastien
From: Skip Evans [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Uploading multiple files?
Date: Mon, 03 Jul 2006 15:08:48 -0600
Hey all,
I have a client who uses
I don't see you closing the single quote at the end of the statement before
do loop
Bastien
From: Mark Bomgardner [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Php-Db php-db@lists.php.net
Subject: [PHP-DB] Do while loop inside of mail()
Date: Wed, 05 Jul 2006 16:55:23 -0500
MySQL
stick the array in a session variable
Bastien
From: Miguel Guirao [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Populating an array to the next script!
Date: Thu, 06 Jul 2006 23:28:06 -0500
Hello,
Is there a way to populate an array from one script to the next one?
I'm
You should be able to open a web page from access (might need to write a
module) and call a page that would then run your script
Bastien
From: bill [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] running program after insert w/MySQL 4.1
Date: Fri, 07 Jul 2006 15:11:07 -0400
I
You can't...best to zip the files and let the user decide where they need to
go
Bastien
From: Skip Evans [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Getting directory from local machine?
Date: Thu, 13 Jul 2006 13:27:03 -0600
Hey all,
I have looked but been unable to find a
http://ca3.php.net/manual/en/function.substr.php is the function you want
bastien
From: Benjamin Adams [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Only a section from the database result
Date: Tue, 18 Jul 2006 13:24:51 -0400
I have articles in a MySQL database and I
Order the query by the category, when the category changes echo out the new
category like a heading
?php
...
echo tabletr;
$old_cat = '';
while ($rows = mysql_fetch_array($result))
{
if ($rows['cat'] != $old_cat)
{
echo td . $rows['cat'] . /td;
echo /trtr;
$old_cat =
SELECT count(*) FROM `bsp_area` GROUP BY boroughID
Bastien
From: Skip Evans [EMAIL PROTECTED]
To: Php-Db php-db@lists.php.net
Subject: [PHP-DB] Using MAX with COUNT?
Date: Sat, 22 Jul 2006 13:48:43 -0600
Hey all,
I have a table like this:
boroughID Area
=
1
SELECT count( * )
FROM `bsp_area`
GROUP BY boroughID ORDER BY count(*) DESC LIMIT 1
Bastien
From: [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] Using MAX with COUNT?
Date: Sat, 22 Jul 2006 20:25:57 -0600 (MDT)
Hi
use mysql_result
mysql_result ( $result, 0, 2 )
where 2 is the offset of the fields in the row
Bastien
From: Peter Beckman [EMAIL PROTECTED]
To: PHP-DB Mailing List php-db@lists.php.net
Subject: [PHP-DB] Direct Access to an Array Item?
Date: Tue, 8 Aug 2006 22:34:55 -0400 (EDT)
I want to
not as sucj, but you could consider a sub-select (providiing your version of
mysql supports it)
something like this might also work
$query = select id from table where somefield [in|=|like] (.
in_array(row,'$user_area').);
Bastien
From: Kevin Murphy [EMAIL PROTECTED]
To:
try posting the code
Bastien
From: Miguel Guirao [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Strange problem!
Date: Wed, 23 Aug 2006 09:41:05 -0500
Hello everybody out here and there,
I'm experiencing a weird problem with one of my scripts, I'm using
ob_start() in order
SQL Server and DB2 (version dependant) don't support regexp in sql
Bastien
From: Micah Stevens [EMAIL PROTECTED]
To: J R [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Distinct Partial Matches: RegExp
Date: Wed, 30 Aug 2006 18:29:19 -0700
You can do regular expression
Try base_64_encod(ing) it then compressing it. on the way out, uncompress,
base-64-decode the value and see what you get
Bastien
From: Nathan Harmon [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Postgres and gzcompress
Date: Wed, 06 Sep 2006 15:39:37 -0700
Hi,
I would like
try
while($row = $db-sql_fetchrow($result))
{
//[INSERT CODE HERE, I want to display the 'user' and 'count']
$user = $row[0];
$count = $row[1];
}
bastien
From: JM [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Displaying SQL
I think you need to add a content-type of application/pdf to the code to
tell the browser that its a pdf coming down
// We'll be outputting a PDF
header('Content-type: application/pdf');
Bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB
Assuming that tim is a pure timestamp column then try
select * from table where date_format(tim,'%Y-%m-%d) = DATE_SUB(curdate(),
INTERVAL 7 DAY)
Bastien
From: Muhammad Mustafa [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] how to show all recordes inserts in a table for the
eregi_replace or str_replace can do that for you
Bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Searching PHP strings
Date: Thu, 28 Sep 2006 21:12:18 -0400
I have been playing tonight for a few minutes.
The
same again on the back end
Bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: [PHP-DB] I still have a bit more of the string to get rid of ...
Date: Thu, 28 Sep 2006 22:13:59 -0400
Where
You need to just start adding echo statements to the code to see where the
hang up is
Bastien
From: David Skyers [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] How to stop the server timing out
Date: Tue, 3 Oct 2006 11:51:30 +0100
Hi,
I have written a php page and every time
easist way is to wrap the entire value in single quotes not double
quotes...kinda breaks the rules but it will work..the other option is to
search your value and do a replace on the double quotes
bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB
i tend to take the approach of
$next_wed = date(Y-m-d, strtotime(next wednesday));
Bastien
From: Niel Archer [EMAIL PROTECTED]
Reply-To: php-db@lists.php.net
To: php-db@lists.php.net
Subject: Re: [PHP-DB] SELECT date query
Date: Sat, 07 Oct 2006 05:49:36 +0100
Hi Ron
I've made the
whynot keep all and just sort/limit them to get the data you want?
bastien
From: bob plano [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] mysql databases
Date: Sat, 14 Oct 2006 12:47:38 -0500
sorry, i meant that i wanted to remove the oldest entry and put in a
new entry
use an array
$months = array('01'='January','02'='February'...);
$thisMonths = array_flip($months);
$month = $thisMonths['January'];
echo $month;
though its easier to just create the array the other way and the just
reference it
$months = array(''January''='01','February'='02...');
$month
mysql_query($query) or die(mysql_error);
will give an error and stop the script if there is an issue, this also can
work for the mysql_select_db
bastien
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Verifying syntax
show relevant code around the query and attempt to loop thru resultset
bastien
From: Vignesh M P N [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Problem with pg_fetch_array
Date: Mon, 23 Oct 2006 15:12:25 -0500
Hi
I am trying to display the rows from a database table in a
www.fpdf.org has a free class / tutorial
bastien
From: Jorge Giménez [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Converting text field to barcode CODE 39
Date: Fri, 27 Oct 2006 23:49:22 +0200
Hello.
Can anyone tell me where I can find information or examples about
chmod will work for both folders and files...
bastien
From: Andrew Darby [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: Re: [PHP-DB] Permissions for mkdirs
Date: Sat, 28 Oct 2006 18:06:36 -0400
Unfortunately, I can't get in to the conents
The code does need to know what the fields are...I think a more likely issue
is the query for some reason, also change the $query to result in the query
statement
try
$result=pg_query($query) or die(pg_error()); //to see if there are any
errors with the query
is your server set to work with php files?
Bastien
From: Desmond Coughlan [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED], [EMAIL PROTECTED],
php-db@lists.php.net
Subject: [PHP-DB] RE : RE: [PHP-DB] re: small question php/postgreSQL
(basic question, not small)
Date: Tue, 7 Nov 2006
WE use XML here to store the values, however our requirements also add the
ability to use mutiple languages so its a little more complex.
For personal projects I store the various data like this into a
system_option table as text (1,Male;2,Female;) and then have a common
routine that grabs
1. yes, user a rich text editor plugin in you web page
(http://www.kevinroth.com/rte/ is one such beast)
2. sure, in a text / blob field
3. yes, but likely you'll need to do it as CDATA
hth
Bastien
From: David Skyers [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Help
goolge cross tab query ... that is what you are looking for
bastien
From: Suprie [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Help on query report...
Date: Wed, 15 Nov 2006 13:28:15 +0700
dear all,
i have this table
id | contract No | site id | handover date |status|
Adiran
There are several solutions that i can see in doing this without csv
1. create a vba module in the excel sheet to handle the connections and
insert/update the data in either direction. This does suppose that the web
server you are using can be accessed directly from the client machine
have you tried the standard sql method
select database_name1.table_name1.field_nameA,
database_name2.table_name2.field_nameB from
...
Bastien
From: C. Tate Baumrucker [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] multiple database join with pdo
Date: Tue, 28 Nov 2006
insert into tableb (select * from tablea)
bastien
From: Rosen [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Transfer data between tables in MySQL
Date: Wed, 29 Nov 2006 13:44:24 +0200
Hi,
I have to transfer all data between two tables ( with identical structure )
Is this
Have you tried limiting it first via a subselect and then doing the full
text match?
bastien
From: benmoreassynt [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Speeding up a query by narrowing it down
Date: Wed, 29 Nov 2006 21:02:03 -0500
Hi,
I have a query which works
here is a link to one such example
http://www.weberdev.com/get_example-3852.html
Bastien
From: Miguel Guirao [EMAIL PROTECTED]
To: David Skyers [EMAIL PROTECTED], php-db@lists.php.net
Subject: RE: [PHP-DB] List menus
Date: Tue, 05 Dec 2006 08:59:44 -0600
The solution has been posted
use the limit clause
$count = 25;
$query=SELECT * FROM WHERE hello = '$hello' limit $count;
Bastien
From: Chris Carter [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Limited number of database results
Date: Wed, 13 Dec 2006 08:51:47 -0800 (PST)
Hi,
I have more than 200
I would think the one huge query (using an IN clause) would be better than
multiple queries...especially if you structure it to use an index
$query=UPDATE some_table SET x='$y' WHERE id
IN('.$z[$key].','.$z[$another_key].','.$z[$another_key]...
bastien
From: Jeffrey [EMAIL PROTECTED]
To:
why not just create a simple single logon page and not include itthen on
sucessful login, redirect the user to the index page?
bastien
From: Haig Dedeyan [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Login script help
Date: Thu, 21 Dec 2006 16:36:11 -0500
Hi everyone,
My
1. yes indexes could help, if mysql uses them. The mysql optimiser may or
may not use the index for the query depending on the statement...it sounds
like you are doing a full table scan on the data
2. there are two schools of thought here:
a. run the whole thing as two statements (one outer
i tend to have a function that show the form and a processing function. In
the processing function i preform my sanity checks and then if there are
errors pass the $_POST data back to the show_form($data, $errors) with the
relevant errors. This removes the need to have the users press the back
are you sure that the problem is not in the browser settings (not to accept
session cookies)?
Bastien
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: php-db@lists.php.net
Subject: RE: [PHP-DB] Session Problem
Date: Fri, 12 Jan 2007 15:34:06 +0900
1. Did you mean that on phpinfo(),
I think the issue might be that you cannot stack the queries in mysqlyou
can't run both queries separated by a semi-colon. You will likely need to
loop thru the queries and execute them one at a time
Bastien
From: marga [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB]
I would tend to agree with this
Bastien
From: Edward Vermillion [EMAIL PROTECTED]
To: Ritesh Nadhani [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: Re: [PHP-DB] PHP with a XML database
Date: Fri, 26 Jan 2007 15:36:33 -0600
I would imagine that parsing the XML file you get once a
http://en.wikipedia.org/wiki/Multidimensional_database
http://en.wikipedia.org/wiki/OLAP
bastien
From: Santiago Zarate [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] OLAP Multidimensional databases and PHP
Date: Sun, 4 Feb 2007 13:37:01 -0400
I would suggest placing all the data into divs and using some js to show
those divs when the time is right
bastien
From: Matthew Ferry [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] echo delay...
Date: Fri, 16 Feb 2007 03:37:17 -0500
Hi fellow php late night peoples
Simple, just add the image tag around it
$query=SELECT logos FROM table WHERE sno = '$sno';
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$logos=mysql_result($result,$i,logos);
echo
div
pimg src'$logos' /p
/div;
Bastien
From: Chris Carter [EMAIL PROTECTED]
To:
select * from table where field_3 is not null
bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] NOT NULL query
Date: Mon, 26 Feb 2007 07:55:41 -0500
Is it possible to do a SELECT query where field_3 isn't null? What
Not sure if you got a reply to this yet, but another option is to read the
mailbox via a cron job. I use this successfully. You can see an example here
( http://www.weberdev.com/get_example-4015.html )
bastien
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To:
What about just writing a batch script that opens the ftp services and sends
the file?
Bastien
From: bedul [EMAIL PROTECTED]
To: php-windows@lists.php.net,php-db@lists.php.net
Subject: [PHP-DB] auto upload
Date: Thu, 1 Mar 2007 12:03:48 +0700
this might a strange code i request, plz forgive
You could use php+gtk to write it that way, but a simple batch file is the
best bet since you could then use task scheduler to run this batch file at
scheduled times.
Just google dos batch files
bastien
From: bedul [EMAIL PROTECTED]
To: Bastien Koert [EMAIL PROTECTED]
CC: php-db
1. install php, we have both running on our iis servers with no problems
2. you can use either one iis or apache ( my work machine runs several
servers at once) The trick will be to designate the ports that the servers
listen on
bastien
From: bedul [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
have you tried to 'flush privileges' to get the server to recognize the user
account. Another option might be to open the mysqld from the command line
and use the GRANT statement to create user without the gui.
bastien
From: Roberto F Tavares Neto [EMAIL PROTECTED]
To: php-db@lists.php.net
another option might be to store xml snippets that match the array.
if you are using large numbers of arrays, perhaps a revamping of the db
structure to map the arrays to sub-tables might be in order
bastien
From: Micah Stevens [EMAIL PROTECTED]
To: Sancar Saran [EMAIL PROTECTED]
CC:
check your php ini file for memory limits and filesize limits. Also check
the mysql (if that is where the problem is) config to make sure you have
enough resources allocated in memory
bastien
From: bedul [EMAIL PROTECTED]
To: Hartleigh Burton [EMAIL PROTECTED]
CC:
Can you supply the code...because if you are trying to use the php
imageftbbox function
a. you spelled it wrong
b. do you have the appropriat arguements ( float $size, float $angle, string
$font_file, string $text [, array $extrainfo] )
Bastien
From: Mad Unix [EMAIL PROTECTED]
To:
best sore the image on the filesystem and use that field to store the path
and image name. Its simpler to manage
Bastien
From: Chetan Graham [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Storing 4KB jpeg images on hospital web server
Date: Thu, 8 Mar 2007 07:06:39 +0300 (EAT)
explain to him that there is a perfomance hit to storing images in the db as
well as causing some db bloat. You will also need to handle the output of
the images differently to ensure that they show up
see these example for getting info in and out of the db
are you dumping the data or you just want to reset?
issuing the 'empty table' command in phpmyadmin will do that
or you can do
ALTER TABLE tbl AUTO_INCREMENT = 100;
bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB]
you can write an html page on the fly and save that to the hard drive
have a look at fopen/fwrite etc
bastien
From: Vincent [EMAIL PROTECTED]
Reply-To: Vicente [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Caching query results in html pages
Date: Tue, 13 Mar 2007 14:20:58
http://www.weberdev.com/get_example-4082.html
From: Vincent [EMAIL PROTECTED]
Reply-To: Vincent [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re[2]: [PHP-DB] Caching query results in html pages
Date: Tue, 13 Mar 2007 18:41:42 +0100
Bastien wrote:
BK you can write an html page on the
too small a sort space on the server? have you checked the server config?
Bastien
From: Tony Grimes [EMAIL PROTECTED]
To: PHP-DB php-db@lists.php.net
Subject: [PHP-DB] MySQL sort stopped working
Date: Tue, 13 Mar 2007 13:22:25 -0600
I have this page that lists artists alphabetically:
select date_format(datefield,'%M') as theDate from table [where clause]
Bastien
From: Ron Piggott [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Values in a date field
Date: Sat, 17 Mar 2007 09:44:43 -0400
I have a $subscription_begins
Wouldn't the simplest solution be to update the entire account all the time?
You are presenting all the data to the user each time any way...so updating
the record is a given anyway.
The benefits are that the sql is simplified since there are only two
statments (insert and update) and the
use
mysql_real_escape_string($_POST['field'] IN the query
use addslashes
use htmlspecialentities
use str_replace to switch it to an ascii equivalent
hth
bastien
From: Stephen Smith [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] Using apostrophe's within a text field
Date: Wed,
if you view the source of the generated page, is the image name correct? is
the path to the image correct?
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] echo Date: Tue, 27 Mar 2007 22:07:37 -0700 (PDT)
Hi all,
I am new to web programming.
I have code
try
echo img src='/album/img/{$row[photoFileName]}' / ;
warpping the array element in braces allows for proper evaluation
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] echo
Date: Thu, 29 Mar 2007 05:08:36 -0700 (PDT)
thanks to Chris and Dimiter,
I
Hve you tried the ODBC connections instead?
http://ca3.php.net/manual/en/ref.dbx.php
bastien
From: Phares Kariuki [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] DBX
Date: Thu, 29 Mar 2007 15:25:12 +0300
Hello,
Is there a DBX module for php5 on debian... I have just installed
That is not a two dimensional array. Its two one dimensional arrays and yo
do it like this
while ($row = mysql_fetch_array($result))
{
$title[] =$row['title'];
$description[] =$row['description'];
}
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net
you need to escape double quotes in an echo if you use double quotes as the
wrapper.
bastien
From: elk dolk [EMAIL PROTECTED]
To: php-db@lists.php.net php-db@lists.php.net
Subject: [PHP-DB] width height
Date: Fri, 30 Mar 2007 04:31:52 -0700 (PDT)
it might be a stupid question but I think it
I would say no, due to the overhead. What I would recommned is setting that
up as a cron task and running it on a scheduled basis, usually when the
server is liightly loaded. Monitor the server and pick an optimal time. This
is the same for all server mainenance type situations like index
use cURL to execute the remote code
Bastien
From: ioannes [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Include function across servers
Date: Tue, 03 Apr 2007 00:06:25 +0100
I have a particular business application so just returning html is OK,
store your password/access credentials outside the web root and use php to
read the data in. Another alternative is to wrap those items in a function
and check the calling source to make sure its only your application
hth
Bastien
From: Roberto Mansfield [EMAIL PROTECTED]
To:
explode(delimiter, $string);
is the correct function
Bastien Date: Thu, 9 Aug 2007 04:53:53 -0700 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] use of str_split Hi when i try to
use this function str_split() it shows me as invalid function what
is solution
Or assuming he really wants to print the page
script language='javascript'window.print();/script
Bastien From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net
Date: Mon, 13 Aug 2007 16:26:40 +0300 Subject: RE: [PHP-DB] this is arafat
So far I understood from your question:
http://www1.auspost.com.au/postcodes/
bastien
Date: Tue, 14 Aug 2007 13:36:54 -0400 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] australian city db -lat/lon? I've
found a few places to get a zipped file of US cities with zips and lat/lon
for insertion into my
Why not look at mambo or drupal to provide the framework? Be a lot quicker than
coding it from scratch
bastien Date: Fri, 24 Aug 2007 23:18:48 -0500 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Looking for some help on a project!
Hello, im working on making a custom
Condition is a reserved word in mysql...you will need to change the field name
bastien Date: Tue, 28 Aug 2007 18:11:20 -0700 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] mysql error... this is bugging me to
no end (no pun intended)... I am getting the error: invalid
are you sure that you have
1. error handling turned on
2. browser set to display all errors ( friendly error messages unchecked)
bastien
Date: Fri, 21 Sep 2007 23:42:40 +0100 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Pages not fully loading I am
stumped and
Realistically, there are three options:
1. run the code twice to connect and pass the data to each server
2. set up a primary server and use a stored procedure to load the other server
(providing db supports it)
3. set up replication and make one a master and the other a slave and the the
what about wordpress? you may also want to look at some of the code generators
bastien Date: Fri, 28 Sep 2007 10:44:31 +0900 From: [EMAIL PROTECTED] To:
php-db@lists.php.net Subject: [PHP-DB] Looking for a small open-source PHP-DB
app that utilize OOP. Hi, For a study purpose, I'm looking
Chris
try just initializing the variable
$view = 0; // if int
$view = ''; // if string
Bastien Date: Tue, 2 Oct 2007 10:55:06 +1000 From: [EMAIL PROTECTED] To:
[EMAIL PROTECTED] CC: php-db@lists.php.net Subject: Re: [PHP-DB]
Error:Undefined index, for a simple line. Chris Carter
501 - 600 of 720 matches
Mail list logo