Have you any script/example how to Save As Excel file to CSV using PHP?
You don't need to repost your question if you don't get an immediate response.
Going file, save as is client side. PHP can't interact with excel
like that. Create a VB macro or something to do it.
--
Postgresql php
On 3/14/06, Eustace [EMAIL PROTECTED] wrote:
Hello,
I hope somebody can assist. I am using dreamweaver 8, Mysql, PHP5 for a
simple we application. After using the dreamweaver wizard to make a
connection, then created a recordset. Trouble starts when I use
require_once(connections/ConnSAFDEM)
\safdem_web\Admin\Connections\connSAFDEM.php
because that's what the server is looking for.
-Original Message-
From: chris smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 14, 2006 12:04 PM
To: [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Mysql/PHP5 connection error
On 3/24/06, SJL [EMAIL PROTECTED] wrote:
It´s true. I find the sources of oci8.so.
But in my first try to compile it, It failed because the it have calls
to php.h and info.h, so I try to move the sources files to the path
where I have this files (taking care with the relative path in the
On 4/2/06, Rodney Topor [EMAIL PROTECTED] wrote:
I've just started using PDO with PHP 5.1 and MySQL 5.0. Everything
seems to work fine, except for one issue with the following example
from the PHP manual.
?php
try {
$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
On 4/5/06, Julien Bonastre [EMAIL PROTECTED] wrote:
http://www.tech-recipes.com/internet_tips1157.html
Should help you out I hope
Wasn't awfully difficult to source either
Method:
Step one: Enter google.com.au in internet browsing client of choice
Step two: use msn messenger add
On 4/9/06, blackwater dev [EMAIL PROTECTED] wrote:
Hello all,
I set up freetds on one of my servers and everything worked fine. I just
set it up on another server (this one with the latest php) and now the same
code seems to connect but can't select the db mssql_select_db(): Unable to
On 4/14/06, Will Chapman [EMAIL PROTECTED] wrote:
I have a few different pg_prepare statements in my PHP script. I was
wondering what scope they lie in. Im assuming they are not saved in the
PSQL database, so it is just for the script? They are inside of
functions... does it only last until
On 4/15/06, Robert [EMAIL PROTECTED] wrote:
Does anyone have an example of how to insert and select a blob field in a
MySQL 4.1 database ?
Search google for php mysql blob it will give you tons of results
(link is too long to post).
First 3 results are articles on exactly what you want.
--
On 4/18/06, Sean Mumford [EMAIL PROTECTED] wrote:
Hi Guys,
I'm working on securing user passwords in a MySQL 4 database with a PHP5
frontend. I remember being told in one of my classes (I'm currently a
college junior) that the best way would be to hash a salt and the password
together and
On 4/18/06, Giff Hammar [EMAIL PROTECTED] wrote:
For an example, look at how UNIX/Linux stores regular login passwords. In
short, the salt is the first two characters in the password. When comparing
passwords, you take the salt and the user supplied password, encrypt, then
compare the two
I have some php scripts that i have to run automatically at 5.00am (on
Windows platform). I am using MySql.
I've tried using Scheduled Task and Cron, and i converted the extension files
to .bat format. But always error on functions
mysql_connect,mysql_query,and other DBS functions. I don't
On 5/1/06, Ron Piggott (PHP) [EMAIL PROTECTED] wrote:
I am using mySQL
.. a google search for mysql reset auto_increment reveals the answer!
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On 5/11/06, Adrian Bruce [EMAIL PROTECTED] wrote:
Hi
I have pdf's stored as a blob in a MySQL database, how can i set a
script (PHP obviously!) to email these blobs as pdf files. The only way
i can think of at the moment is to write them to disk and then attach
them to the mail before sending
On 6/3/06, Blanton, Bob [EMAIL PROTECTED] wrote:
Hi,
I'm new to web programming and Apache PHP so this may seem like a
dumb question. Is there a preferred way to implement SSL in a website
or web application? Is it handled using PHP or Apache? Or both? I see
there is the Apache Open SSL
On 6/9/06, Arie Nugraha [EMAIL PROTECTED] wrote:
Hi list,
yesterday i compile postgresql 7.4 in my FreeBSD 5.4 box.
I manage to run the server smoothly without any problem.
But then i try to connect with my php script with pg_connect function, and
it returns an error like this :
*cant make
On 7/1/06, Dwight Altman [EMAIL PROTECTED] wrote:
Thanks, but that's an additional query.
I was wondering if there may be a PHP function that can operate on the
$result or perhaps $link of the single query that uses a LIMIT clause and
have the information [count(*) had there not been a LIMIT
--
$query1 = SELECT distinct link_id, url, title, description, $fulltxt, size
FROM .$mysql_table_prefix.links WHERE link_id in ($inlist);
$result = mysql_query($query1);
echo mysql_error();
and what does $fulltxt contain when you get the error?
On 12/21/06, Ondrej Kohout [EMAIL PROTECTED] wrote:
It's better to use SQL_CALC_FOUND_ROWS and information function
FOUND_ROWS().
Has nothing to do with the problem.
its simply showing the else condition which does not have NEXT
or PREVIOUS hyperlinked.
Try OKi98's suggestion, it will most
On 1/5/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I am using CURL to check pages outside my site on the internet for some
text, then I email someone on my database who supposedly looks after the
site. The script creates a process that does not terminate. It is running
on a scheduled
On 9/11/07, Niel Archer [EMAIL PROTECTED] wrote:
mysql explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes;
+--+--+---+--+-+--+--+---+
| table| type | possible_keys | key | key_len | ref | rows |
Extra |
On 10/12/07, Claude Masseron [EMAIL PROTECTED] wrote:
Hi,
Not sure if I'm asking in the right place. One of our engineers
wrote a PDO driver for the IBM U2 databases. Info can be found at:
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0612xia/
On Nov 9, 2007 1:18 AM, Colin Guthrie [EMAIL PROTECTED] wrote:
Lasitha Alawatta wrote:
There is a tool call idera (SQL diagnostic manager). Basically it is
a performance monitoring and diagnostics tool.
It has a feature;
Identifying of worst-performing codes –
Identifies
On Nov 9, 2007 8:34 PM, Andrew Blake [EMAIL PROTECTED] wrote:
Hello
It seems that the normal mysql_query doesn't error when an sql command
forces the server to truncate the data. The mysql server executes the
sql and provides a warning but it still executes the sql so allowing php
to ignore
I'm not one of the people who create the code behind php. You will
need to discuss your idea with them.
http://www.php.net/mailing-lists.php
Join the internals list and discuss it there.
On Dec 22, 2007 7:06 AM, Dmitry Shukaylo [EMAIL PROTECTED] wrote:
Hm..
In that case be so kind to inform
$result3=mssql_query($query3) or die (The query has failed);
snip
http://dev.mysql.com/doc/refman/5.0/en/insert-select.html
Ah - the OP isn't using mysql, it's ms-sql.
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To
I really need some help. I'm trying to use an IF statement in a multi-table
left join. I'm joining four tables (customers, contents, courses
locations).
IF can only be used in the select part or the where part, it can't be
used in the join part of a query.
In the contents table I have two
On Mon, Dec 29, 2008 at 10:17 AM, Keith Spiller larent...@hosthive.com wrote:
Another option that would work if I can figure out the correct syntax is to
just NULL certain values if a given condition exists. If
product_type='course' then just use the o.product_id value for field4. If
On Wed, Feb 11, 2009 at 7:36 PM, mrfroasty mrfroa...@gmail.com wrote:
Hello,
I have been browsing on mysql manual
http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html
with not much of success.I am trying to put 2 foreign keys(from
different external table) on my table,
This worked for me:
CREATE TABLE hotel (
items_no int(16) NOT NULL auto_increment,
INDEX (items_no),
PRIMARY KEY (items_no)
)ENGINE=INNODB;
CREATE TABLE pack (
items_no int(16) NOT NULL auto_increment,
INDEX
On Fri, Feb 13, 2009 at 6:01 PM, Mika Jaaksi mika.jaa...@gmail.com wrote:
With these:
$band_id = $_SESSION['session_var'];
echo band_id: . $band_id;
$query=SELECT * FROM pic_upload WHERE band_id=$band_id;
echo query: . $query;
I get these:
band_id: 11
query: SELECT * FROM pic_upload
1. I ran php configuration as below.
$./configure --with-apxs2=/usr/local/apache2/bin/apxs
--with-mysql=/apps/mysql/mysql
It went fine.
Are you sure?
2. While running make, i got following relink error.
ld: fatal: file /usr/local/mysql/lib/libmysqlclient.so: wrong ELF class:
ELFCLASS64
Do you mean i am using 32bit PHP libraries? If so could you please let me
know where to download 64bit PHP libraries. I tried over the net but i
couldn't get it.
No, I meant this:
ld: fatal: file /usr/local/mysql/lib/libmysqlclient.so: wrong ELF class:
ELFCLASS64
ld: fatal: file
On Mon, Mar 16, 2009 at 6:51 PM, Mark Halling-Brown
mhallingbr...@icr.ac.uk wrote:
Thanks for your replies.
In my desperation, I declared those environment variables in as many places
as I could think of. The script (Although I know I shouldnt), php.ini and
also the apache httpd.conf file:
On Fri, Aug 7, 2009 at 5:10 PM, kranthikranthi...@gmail.com wrote:
You're assuming that. It could be the queries being run are the costliest.
It has got nothing to do with the cost of query. bare mysql_connect()
is very costly.
I'm not arguing with that, I'm saying that the cost of the
The } else { confuses PHP. I am not sure what I should be doing.
You're missing at least one brace.
If the code you supplied is a copy of what you have, you're missing a
} for the end of the while loop and one for the end of the else
condition.
So it's treating } else { as part of the while
36 matches
Mail list logo