t connects where
you really want.
You mentioned a field "def" while printing the query's output which
obviously is not included in the table's description. Have you changed
the schema in the meantime?
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
y exceed. So if you use either you may need to fine-tune
PHP by increasing the per process memory (memory_limit in php.ini) or MySQL.
In case you use unbuffered queries you cannot use transactions as far as
I can recall.
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
manner. Better questions get better answers.
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I have Fedoara 2.6.27.5-37.fc9.i686
that has perl:
This is perl, v5.10.0 built for i386-linux-thread-multi
I searched the entire system and found neither pecl or phpize
Although this not a php question try:
yum install php-devel
--
Thodoris
--
PHP Database Mailing List
$result3=mssql_query($query3) or die ("The query has failed");
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
Ah - the OP isn't using mysql, it's ms-sql.
Oups didn't notice that :-) .
--
Thodoris
ios(field1, field2) select field1, field2 from
other_table where
the db will (internally) loop over the results and do the work.
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
Not to mention that you don't even need PHP for that. You just need to
open a client and make the query.
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
MHO this is
the best practice.
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
speediest but it can
have more failures because are session vars or cookies. It depends of
your control errors and also the visits profile.
I wouldn't bet on that I think it depends on the case.
Hope it helps,
--
Thodoris
ttp://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
J.A. van Zanen
--
Thodoris
8062
===
I think that the manual is quite clear on this:
http://dev.mysql.com/doc/refman/5.1/en/call.html
You use a way to query the database like PDO or mysqli and you wite sql.
Is there something specific that you want to ask?
--
Thodoris
-
n/5.0/en/innodb-foreign-key-constraints.html
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
O/H TK ??:
At 03:21 AM 7/9/2008, Thodoris wrote:
At 04:16 PM 7/8/2008, Philip Thompson wrote:
On Jul 8, 2008, at 11:55 AM, TK wrote:
I'd like to use a PDO prepared statement to perform a MySQL query
that uses the IN function.
I.e.:
$stmt = $pdo->prepare(
value.
The other goes as you suggested:
$stmt = $pdo->prepare('
select *
from mytable
where myfield IN (:contents)
);
$stmt->bindValue(':contents', $contents);
$stmt->execute();
Where contents is:
$pre_contents = array('mystring1', 'mystring2');
$contents = implode(',',$pre_contents);
or
$contents = 'mystring';
--
Thodoris
you separate
them. This is probably slower if the collectibles are few in number but
I think it gets better when their number increases badly.
Tell us what you think.
--
Thodoris
O/H Hussein Jafferjee ??:
Hey Guys,
I have been developing for a while and never found the best solution
if you choose
to do it this way but it would be a session id. However have in mind
that you may have more control over sessions because you can configure
your server to make great deal of things like say eliminate all sessions
every say 5 minutes.
I don't know if this was much of a help
would be greatly appreciated.
These are fresh so you shouldn't be having a problem.
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
his
$keys = implode(",",$keyword);
$query .= $keys;
This is the reference in the manual:
http://gr2.php.net/manual/en/function.implode.php
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
tion /
encoding.
PS Why don't you try replication instead of exporting / importing data??
--
Thodoris
O/H elk dolk ??:
Hi everybody,
1- I have created a database in the remote server and I have the same
database in my local machine ,which is configured a
O/H Kazuhiro IIzuka ??:
Thanks Thodoris.
But this is not things I desired.I've already read php manual and known
about PDO::getAttribute() before I post my question.
When I get to server version,I can use $dbh->getAttribute(PDO::
ATTR_SERVER_VERSION),but there are no attribu
Predefined Constants list in:
http://www.php.net/manual/en/ref.pdo.php
--
Thodoris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
quot;.$e->getMessage();
}
You can use try {} with almost everything so give it a "try" :-) .
Send us some feed back or post full source if you keep having trouble.
--
Thodoris
is that you should try to execute your queries using
the command line client or any other that you use before putting it in
use in order to find out what's wrong.
--
Thodoris
O/H Jas ??:
Hello all, I receive an error of the following: The used SELECT
statements have a different n
't do the trick for me. Does anybody have
previous experience concerning charset encoding in order to help me.
Thanks in advance.
PS: I am writing in sreadsheet format using Spreadsheet_Excel_Writer
pear module*
*
--
Thodoris
by hand and you have updated sqlite you
should recompile your apache against the new sqlite.
Hope this do some magic for you cause I have run out of ideas.
|
--
Thodoris
O/H Markus Wolff έγραψε:
Hi Thodoris,
I've checked on one of the three boxes now and the SQLite version used
by both t
e the pop-up window does not returm to the parent window
something. I searched through the web and nothing seems to do the magic
for me. Please any suggestions would be welcome cause I have been
working on this for several hours as we speak.
--
Thodoris
--
PHP Database Mailing List
0 can only use files with file_format==1. Version 3.1.3
** can read and write files with file_format==1 or file_format==2.
** Version 3.1.4 can read and write file formats 1, 2 and 3.
*/
Meaning that not all sqlite3 versions support all file formats. That is
why you should check the version of sql
after can
read file formats 1,2 and 3. Is you database format new?|
|
--
Thodoris
O/H Markus Wolff έγραψε:
Chris schrieb:
It can't be file permissions, I've even tried to set the database file
to 777... no change at all.
My guess is still permissions. If you try a raw fopen instead
Well the directory that houses the database should be writable.
Running the script from command line it gives you write access probably
but it won't work using mod_php because the web server probably can't
write. Try it and give us some feedback.
--
Thodoris
O/H Chris έγραψ
28 matches
Mail list logo
