On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I wish to accomplish the following with prepared statements:
$stmt = mysqli_stmt_init($cxn);
if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site,
MedRec, Fname, Lname,
Ethan Rosenberg, PhD
/Pres/CEO/
*Hygeia Biomedical Research, Inc*
2 Cameo Ridge Road
Monsey, NY 10952
T: 845 352-3908
F: 845 352-7566
erosenb...@hygeiabiomedical.com
On 09/02/2012 08:33 AM, Matijn Woudt wrote:
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I wish to accomplish the following with prepared statements:
$stmt = mysqli_stmt_init($cxn);
if($stmt = mysqli_stmt_prepare($stmt, INSERT INTO Intake3 (Site,
MedRec, Fname, Lname,
On Sun, Sep 2, 2012 at 10:41 PM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
On Sun, Sep 2, 2012 at 6:45 AM, Ethan Rosenberg, PhD
erosenb...@hygeiabiomedical.com wrote:
Dear List -
I wish to accomplish the following with prepared statements:
$stmt =
Dear List -
I wish to accomplish the following with prepared statements:
FYI -
The Database:
mysql describe Intake3;
++-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-+---+
| Site
Jason Pruim wrote:
Hey everyone,
Have a weird issue that I can't seem to figure out...
Using PHP to insert phone numbers into the site... I have the Area Code,
Exchange, and then dynamically create the last 4 digits... Once it's
inserted it's dropping the leading zero's... Here's some
Hello,the phpers.i'm recently learn to use the pear HTML_Template_IT,
The following is my test template test.tpl,the source code is :
html
table
!-- BEGIN CELL --
tr
td
{DATA}
/td
!-- END CELL --
/tr
/table
/html
And my php revoke source code is :
?php
require_once
Mysql Username or password error.please testing connect setting
--
NADARAJAH SIVASUTHAN NADARAJAH nsivasut...@live.com, haber iletisinde
sunlari yazdi:col106-w49cf8a0029c9582f1c0161d5...@phx.gbl...
Dear all,
When I try to retrive data from two tables using JOIN OR INNER JOIN
Hello everyone, I have a problem.
I use the following to *try* and insert data into my MySQL database...
//Variables come from a form
$username= $_POST['username'];
$password = $_POST['password'];
$email = $_POST['email'];
//Connect to the database
$connect = mysqli_connect($hostname,
Remove the quotes around the variables in all your statements.
For example, this statement:
mysqli_stmt_bind_param($submitadmin, isss, '$numrows', '$admin',
sha1('$password'), '$email');
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
That worked, thanks!
Remove the quotes around the variables in all your statements.
For example, this statement:
mysqli_stmt_bind_param($submitadmin, isss, '$numrows', '$admin',
sha1('$password'), '$email');
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows,
kesavan trichy rengarajan wrote:
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
Turning on E_STRICT in PHP 5.3 will show
PHP Strict Standards: Only variables should be passed by reference
This is also true in earlier
Done. Thanks for letting me know about that.
kesavan trichy rengarajan wrote:
could be rewritten as:
mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin,
sha1($password), $email);
Turning on E_STRICT in PHP 5.3 will show
PHP Strict Standards: Only variables should be
Hi i wanna ask a question. I am trying to create an image on fly, please do
help me , following is the code.
*File Name : Font.php
Code: *
html
head
titleImage Creation/title
script language=javascript
var xmlhttp;
function showPic()
{
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
{
when you click on the wamp icon in your taskbar you will get an popup menu:
by clicking on phpMyAdmin your browser will open with phpMyAdmin. From
there you can check the database and create databases and tables as you go.
If phpmyadmin could not open. : page times out then click on the wamp
Hi there,
I'm having some serious problems with the PHP Data Object functions. I'm
trying to loop through a sizeable result set (~60k rows, ~1gig) using a
buffered query to avoid fetching the whole set.
No matter what I do, the script just hangs on the PDO::query() - it
seems the query is
.. if there any result (reply).. i send to you
- Original Message -
From: Jody Williams [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2007 10:36 PM
Subject: Re: [PHP-WIN] Problem With Pear::DB
THat is what I thought. Just to confirm, I created an ODBC connection
G'day,
I've got a number of PHP4 scripts that work just fine under PHP4 on a
Tru64 Unix server. Moving these over to PHP4 running on a Mac OS X server,
I find that the OCILogin function intermittently fails [1] with the
following error message:
Warning: ocilogon(): OCIEnvNlsCreate() failed.
At 10:04 09/05/2006, you wrote:
Message-ID: [EMAIL PROTECTED]
From: Andy Rolls-Drew [EMAIL PROTECTED]
To: php-db@lists.php.net
Date: Tue, 9 May 2006 10:03:54 +0100
Message-ID:
!~!UENERkVCMDkAAQACABgAGw7HZJPFmUmqr9/[EMAIL PROTECTED]
MIME-Version: 1.0
Content-Type:
Hi,
I searched quite a while for a solution but I just don't find one.
I use:
- MS ACCESS as the database (I know there are better solutions but I
have to use MS ACCESS 2002)
- PHP Version 5.0.5
- Windows 2000
- Apache/2.0.54
I've got the following query:
SELECT table1.col1,
Hi,
Apologies if this isn't the right place to ask - but I'm banging my head
against the wall with this one!
I'm trying to update a record in the table (creation script below) using the
following SQL statement:
UPDATE shop_customer SET eu_vat_number = SK1234567890 AND vat_amount = 0
AND
You need to separate the SET arguments with commas, not ANDs...
It's really doing something like this:
UPDATE shop_customer SET eu_vat_number = (SK1234567890 AND vat_amount = 0
AND total_amount = 8.4925) WHERE customer_id = 7 AND hash=dcd5e751
(SK1234567890 AND vat_amount = 0 AND total_amount =
Message-
From: Jenaro Centeno Gómez [mailto:[EMAIL PROTECTED]
Sent: 04 March 2006 17:35
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL update statement problem
Maybe I am wrong, biut isn´this the rigth way to do this:
UPDATE shop_customer SET eu_vat_number = SK1234567890, vat_amount =
0
Hi all,
I have an elusive problem with PHP and ODBC.
I want to use ODBC to contact a MSSQL server on an NT box, from a linux
machine.
FreeTDS driver, no problem
unixODBC, no problem
I can contact the correct database on the NT box through isql and tsql, no
problem
I can make a command-line
umeed hayyat wrote:
Hi
I have a form where user can add a category or edit some existing
category.
It is perfectly running on localhost but when i uploaded it to an ftp
server (that was Linux based), it isnt displaying any images when i add
any image through image uploading script, neither
No
i checked the name of name of image values returned.
all is working fine
As i already mentioned tht it is working the right way on my local server.
reagrds
umeed
[EMAIL PROTECTED] wrote:
php-db Digest 13 Sep 2005 22:56:53 - Issue 3090
Topics (messages 40255 through 40261):
Re:
I have problem with MySQL in PHP 5.0.4 (WIN XP). I use charset cp1250
(win-1250, Czech) and PHP5 show results from db in incorect charset. When i
use PHP 4, there is no problem! Configuration MySQL server is in both case
the same.
--
PHP Database Mailing List (http://www.php.net/)
To
I have problem with MySQL in PHP 5.0.4 (WIN XP). I use charset cp1250
(win-1250, Czech) and PHP5 show results from db in incorect charset. When i
use PHP 4, there is no problem! Configuration MySQL server is in both case
the same.
--
PHP Database Mailing List (http://www.php.net/)
To
does your web server, php and db all use the same charset? they all should
match
From: Dominik Fi¹er [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL in PHP5 - problem with charset
Date: Sun, 11 Sep 2005 14:35:44 +0200
I have problem with MySQL in PHP 5.0.4 (WIN XP). I
:[EMAIL PROTECTED]
does your web server, php and db all use the same charset? they all should
match
From: Dominik Fi¹er [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL in PHP5 - problem with charset
Date: Sun, 11 Sep 2005 14:35:44 +0200
I have problem with MySQL in PHP 5.0.4
Helo everyone !
I find this problem and I think I am close to the solution but ...
The question: I need to import a few thousand of record storee in a *.csv
file on my local harddisk, with my php application, managing my mysql engine.
So, in command line, all works fine, all records are
I could be 100% wrong on this, but I do not think that a command line
statement can be executed through mysql_query() - try exec().
If I remember correctly mysql load data infile ... is not executed from
within mysql, but at the command line.
(Hint: look at the source for phpMyAdmin and copy
You can definitely do a load file from within the mysql client, so I'd
guess you can do it through mysql_query, too. I'm wondering about the
semi-colon within the query. Maybe it needs to be escaped, too.
David
I could be 100% wrong on this, but I do not think that a command line
statement
where you open
the file and read it in, parsing thru it to access the data elements and
running sql statements thru a loop
Bastien
From: [EMAIL PROTECTED]
To: Miles Thompson [EMAIL PROTECTED]
CC: php-db-list php-db@lists.php.net
Subject: Re: [PHP-DB] load data infile -- problem
Date: Thu, 18
Use a real hostname, not 'localhost'.-
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Andrés G. Montañez [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Use a real hostname, not 'localhost'.-
Will give that a try. Thank you.
--
Atte, Andrés G. Montañez
Técnico en Redes y Telecomunicaciones
Montevideo - Uruguay
--
PHP Database Mailing List (http://www.php.net/)
To
I've installed a game on my server, but it wants to email new registrants.
When it attempts this the following error is displayed:
Warning: mail() [function.mail]: Failed to connect to mailserver at
localhost port 25, verify your SMTP and smtp_port setting in php.ini
or use ini_set() in
Hi, I'm trying to use strtotime(last month), strtotime(-1 month), or
strtotime(1 month ago) to get the last month. However, it keeps returning
March, not February. This started happening just yesterday, March 29th. This
obviously has something to do with February's shorter amount of days, since
try the mktime function
bastien
From: Shay [EMAIL PROTECTED]
Reply-To: Shay [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] strtotime: Last Month problem
Date: Wed, 30 Mar 2005 15:02:27 -0700
Hi, I'm trying to use strtotime(last month), strtotime(-1 month), or
strtotime(1 month ago
hallo,
i have changed file signup1.php with login1.php, in action fied of form
form name=form1 method=POST action=--
and saved .
but when i run this file and click on submit button, it still shows old
sighnup1.php. and data is also not entering in database. while it data was
amol patil wrote:
hallo,
i have changed file signup1.php with login1.php, in action fied of form
form name=form1 method=POST action=--
and saved .
but when i run this file and click on submit button, it still shows old sighnup1.php. and data is also not entering in database. while it
There are scores of examples / tutorials on this. Google turned up 6,070
hits on this expression:
add user php mysql example
Here's one of them, although it assumes register globals is on
http://www.php-scripts.com/php_diary/072000.php3
Why don't you pick one, work with it and
On Tue 28 Dec 04, 11:44 AM, Miles Thompson [EMAIL PROTECTED] said:
At 09:25 AM 12/28/2004, amol patil wrote:
hallo,
i have changed file signup1.php with login1.php, in action fied of form
form name=form1 method=POST action=--
and saved .
but when i run this file
To view the terms under which this email is distributed, please go to
http://disclaimer.leedsmet.ac.uk/email.htm
On 30 November 2004 14:45, SCALES, Andrew wrote:
Thanks very much for your help. The main difficulty I was
having really was
unlocking the record again if the user crashed out
though.
Andy
-Original Message-
From: Norland, Martin [mailto:[EMAIL PROTECTED]
Sent: Monday, 29 November 2004 15:36
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
-Original Message-
Does anyone know a good way of locking out access to a record on a
MySQL
try that.
Thank you both for the advice,
Andy
-Original Message-
From: Gryffyn, Trevor [mailto:[EMAIL PROTECTED]
Sent: Monday, 29 November 2004 15:44
To: [EMAIL PROTECTED]
Cc: Bastien Koert; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
Yeah, all good thoughts
have issues. :)
Good luck!
-TG
-Original Message-
From: SCALES, Andrew [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 30, 2004 9:45 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
Thanks very much for your help. The main difficulty I was
having
Hello,
Does anyone know a good way of locking out access to a record on a MySQL
database when someone has the update page open?
The problem is that we have a local intranet site which is accessed by
members of different departments. Now at the moment when someone loads the
page all of the data is
really like it, since the ultimate choice is left to the user as to what
data is correct.
Bastien
From: SCALES, Andrew [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Multi-User Update Problem
Date: Mon, 29 Nov 2004 11:16:08 -
Hello,
Does anyone know a good way of locking out
-Original Message-
Does anyone know a good way of locking out access to a record on a
MySQL database when someone has the update page open? The problem is
that we have a local intranet site which is accessed by members of
different departments. Now at the moment when someone loads the
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Monday, November 29, 2004 10:22 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Multi-User Update Problem
Its a tough one. My personal fav is to mark the record as
locked by changing
All you have done here is just assigned the query string to a variable. This alone
does absolutely nothing as far as the db is concerned. You need to execute the query
against the db for it to have an effect. The mysql_query() function is used for all
queries, not just selects.
$sql = INSERT
Here is the code I use:
$dsn = mssql://username:[EMAIL PROTECTED]/database;
$options = array(
'debug' = 2,
'portability' = DB_PORTABILITY_ALL,
);
$db = DB::connect($dsn, $options);
if (DB::isError($db)) {
$db-getDebugInfo();
die($db-getMessage());
}
$sql = $db-prepare(INSERT
Chris wrote:
Here is the code I use:
[snip]
$sql = $db-prepare(INSERT INTO ExitSurveyAnswers (session_id,
Question_id, answer) VALUES ?,?,?);
[snip]
When I execute it I keep recieving and error message stating:
DB Error: syntax error
Not a MSSQL expert, but shouldn't the ?,?,? in your query have
In article [EMAIL PROTECTED], Jason Wong wrote:
On Friday 16 July 2004 08:05, Justin Patrin wrote:
If you're simply trying to get '@email.com' then use strstr().
Of courseI'm just so used to pregs...
Well the advantage of using a regex is that you can perform some form of
On Friday 16 July 2004 16:01, Tim Van Wassenhove wrote:
In article [EMAIL PROTECTED], Jason Wong wrote:
On Friday 16 July 2004 08:05, Justin Patrin wrote:
If you're simply trying to get '@email.com' then use strstr().
Of courseI'm just so used to pregs...
Well the advantage of
On Friday 16 July 2004 08:05, Justin Patrin wrote:
If you're simply trying to get '@email.com' then use strstr().
Of courseI'm just so used to pregs...
Well the advantage of using a regex is that you can perform some form of
validation on the address.
--
Jason Wong - Gremlins
Charles Morris wrote:
Hello all, I have recently been working with OCI and when I use OCILogon
[wethere with example scripts or my own code] I get a PAge cannot be
displayed (like DNS error) when I naviagte to the page. When I comment
out the OCILogon part it works great exept for the oracle part.
Justin Patrin wrote:
Charles Morris wrote:
putenv(ORACLE_SID=PROJ);
putenv(ORACLE_HOME=/home/oracle9);
I have tried putenv myself and it doesn't seem to work for Oracle
connections. Putting those in your shell environment, then restarting
apache. Check to see if the env vars are set
Hello,
I have a page with a button that when clicked loads a pre-determined
text file into my database. The code is posted below.
However, when clicked the button does nothing, just opens up the same
page again. The data does not get loaded into the database. any ideas?
Thanks
Justin
The
]
Subject: Re: [PHP-DB] Load data infile problem
does your server have the post variables set as globals? you might
have to use $_POST['submit'] instead.
On Jun 7, 2004, at 9:17 PM, [EMAIL PROTECTED] wrote:
Hello,
I have a page with a button that when clicked loads a pre-determined
text file
Hi guys
I have a script which pulls a date(date default NULL) and a time (time default NULL)
from a MySQL database, now I would like to display that date and time in a 'pretty'
format.
I've been able to show the date nicely with the help of this:
Hello,
I use SELECT DISTINCT tip, marca, model FROM modele to select
records without duplicates on the field tip. This works ok, BUT if I
use SELECT DISTINCT tip, marca, model, id FROM... (id is
auto_increment and is the table's primary key) my query won't produce
any result. ANyone has a clue?
Very odd. I would think it would return every record seeing as the auto_increment ID
field is different for every record.
I use SELECT DISTINCT tip, marca, model FROM modele to select
records without duplicates on the field tip. This works ok, BUT if I
use SELECT DISTINCT tip, marca, model, id
This wouldn't be posible either, because the argument for Distinct
is tip, so other fields will be ignored. But simply it can't retrieve
id. If i want to retrieve it also, it returns zero fields. Thank you
anyway.
Regards,
Marius Panaitescu
DC Very odd. I would think it would return every
Hello,
First, I use this, and all is ok:
SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC.
Then, I use this:
SELECT * FROM modele WHERE marca='Cagiva' ORDER BY tip ASC
and the records are not ordered ascending by the field tip. In the
first case, the records were ordered. Anyone
- Original message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Sat, 8 May 2004 23:23:05 +0300
Subject: [PHP-DB] another strange MYSQL problem
Hello,
First, I use this, and all is ok:
SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC.
Then, I use
]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Sat, 8 May 2004 23:23:05 +0300
Subject: [PHP-DB] another strange MYSQL problem
Hello,
First, I use this, and all is ok:
SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC.
Then, I use this:
SELECT * FROM modele WHERE marca
if possible.
R
RZ Quoting Marcjon Louwersheimer [EMAIL PROTECTED]:
- Original message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Sat, 8 May 2004 23:23:05 +0300
Subject: [PHP-DB] another strange MYSQL problem
Hello,
First, I use this, and all is ok
Hello Marcjon,
Sunday, May 9, 2004, 12:13:05 AM, you wrote:
ML - Original message -
ML From: [EMAIL PROTECTED]
ML To: [EMAIL PROTECTED] [EMAIL PROTECTED]
ML Date: Sat, 8 May 2004 23:23:05 +0300
ML Subject: [PHP-DB] another strange MYSQL problem
ML Hello,
ML First, I use
Hello Marcjon,
Sunday, May 9, 2004, 12:13:05 AM, you wrote:
ML - Original message -
ML From: [EMAIL PROTECTED]
ML To: [EMAIL PROTECTED] [EMAIL PROTECTED]
ML Date: Sat, 8 May 2004 23:23:05 +0300
ML Subject: [PHP-DB] another strange MYSQL problem
ML Hello,
ML First, I use
db
RZ schema if possible.
R
RZ Quoting Marcjon Louwersheimer [EMAIL PROTECTED]:
- Original message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Sat, 8 May 2004 23:23:05 +0300
Subject: [PHP-DB] another strange MYSQL problem
Hello,
First, I use
[EMAIL PROTECTED] wrote:
First, I use this, and all is ok:
SELECT * FROM modele WHERE marca='Aprilia' ORDER BY tip ASC.
Then, I use this:
SELECT * FROM modele WHERE marca='Cagiva' ORDER BY tip ASC
and the records are not ordered ascending by the field tip. In the
first case, the records were
If your ID is an autoincremented field, try not including it in your
insert statement.
I.E.:
$sql = INSERT INTO underskrifter (type, navn, epost, tid, ip, domain,
sted) . VALUES ('$_POST[type]', '$_POST[navn]', '$_POST[epost]',
'$tid', '$ip', '$host', '$_POST[sted]' );
-Mike Forbes
Thanks Justin,
I found the problem. I am using the OOP with sessions. The idea is use um
object and put it into the session and change it when is necessary. However,
instead of change the information in the object and then change the object
that is in the session, it is adding more information in
Is there any way to destroy the object in PHP?
http://us2.php.net/manual/en/function.unset.php
Chris
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Andre Matos wrote:
Hi List,
Two months ago I developed a project using PHP and MySQL without problem.
Now, I am developing using PHP and MySQL, but using PHP Object Oriented.
My problem is that the access is become slowly after few accesses or if I
perform a reload some times. The unique way
Hi all:
I am trying to create a registration form whereby one of the user input is as
follows: (a drop down menu with values retrieved from DB):
-
td class=lighter width=350Class Code:/td
td class=lighter width=450
Irin,
First of all, you need to do this instead of what you're doing:
while ($row = mysql_fetch_row($sql))
Second, this value should be storable just as any other values.
i.e.
mysql_query(insert into database (table) values(' .
$_POST['class_code'] . '));
I hope this helps you a bit.
Regards,
.
- Original Message -
From: Doug Thompson [EMAIL PROTECTED]
To: Robin 'Sparky' Kopetzky [EMAIL PROTECTED]
Cc: Erwin Kerk [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 27, 2004 1:04 AM
Subject: Re: [PHP-DB] SQL File Import problem (Was: HELP!!!)
On Fri, 27 Feb 2004 01:16:20
Hi all:
I am trying to create a registration form whereby one of the user input is as
follows: (a drop down menu with values retrieved from DB):
-
td class=lighter width=350Class Code:/td
td class=lighter
Try:
OPTION VALUE=\$row['class_code']\ .$row[class_code]. /option;
while ($row = mysql_fetch_array($sql))
{
print OPTION VALUE=\$class_code\ .$row[class_code]. /option;
}
$result = $db-query($sql);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Fri, 27 Feb 2004 01:16:20 +0100, Erwin Kerk wrote:
Robin 'Sparky' Kopetzky wrote:
Good afternoon!
I used SQLYOG to export the tables and data from a Mysql database. Now, when
i try to re-import the data back into a different database, I get an error
stating Error : MySQL server has gone
Thank you to all who helped. I was able using UltraEdit to chop up the sql
file and created all of the individual INSERT statements. Now, I'm up and
running again. Slow but it worked!
Thanks again!
Robin Kopetzky
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Robin 'Sparky' Kopetzky wrote:
Good afternoon!
I used SQLYOG to export the tables and data from a Mysql database. Now, when
i try to re-import the data back into a different database, I get an error
stating Error : MySQL server has gone away. What is happening and how do I
fix this. I NEED this
First check that you are not sending any content before trying to set the
cookie :
It effectively is sending a header, and headers must be sent before any
other content - even a white space before your PHP script which sets your
cookie will send headers so then your cookie will not be set.
Thanks Justin, thats a handy function.
I've been testing my code and found that it works up until I start passing
objects into methods. This is the code I'm using to set up some objects
(they are being passes variables that have been settype()'d):
$sessioniser = new Java('com.SessionManager',
Hi,
I am trying to INSERT into a MSAccess database using PHP 4.3 -
I have a problem when I enter a name like O'Donnell. In mysql I would
normally just backslash the single quote but this doesn't work with
MSAccess.
is there a fix for this??
Thanks in adv.
Jason
--
PHP Database Mailing List
I don't know anything about Java in PHP myself, but here's a function
that will convert an object to an associative array for you.
function objToAssoc($obj) {
if(is_object($obj)) {
$arr = get_object_vars($obj);
} else {
$arr = $obj;
}
if(is_array($arr)) {
foreach($arr as $key
In article [EMAIL PROTECTED], [EMAIL PROTECTED]
says...
*Sorry if this is a duplicate*
Using mySQL db to store my data. Using a select statement on my PHP page.
When it lists out the data it seems to be skipping the first row. Any ideas?
Without seeing your code, I'll have to guess that
Hi there everyone,
Just a note to say i've fixed the CSV import problem, I had to excape the ' character
that was in the array and now it imports all 1081 rows properly.
Now I can relax and pass out LOL :-)
Thanks for all the help, very appreciated.
Chris
Thanks for hijacking my thread - I guess nobody else is having this problem?
I don't understand how I can post to php.db and receive notices and
autoresponders from Italy (2 different guys now).
-Kirk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Ah, I just read Richards note on the same problem. Let's get rid of these
guys, please.
-Kirk
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thu, 2003-10-02 at 22:28, Michael Scappa wrote:
Ruprecht,
Make sure you have PHP pointing to the right location for the
mysql.sock. locate mysql.sock. Sometimes its in the /tmp dir. If it is
in another location you can point to it specifically when you call
mysql_connect (refer to
, not the file
itself, try both).
-Original Message-
From: Ruprecht Helms [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2003 8:15 AM
To: Michael Scappa
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection
in php-script
On Thu, 2003-10-02 at 22:28
Hello everybody,
I need help in order to get the table name of a field in SQL Server 2000.
In order to get the table name of a specific column in a query, I tried to
use mssql_fetch_field function. But column_source is, in fact, the
column name, not the table name how it was supposed to be.
In a
Hi Simon,
On Saturday 13 September 2003 19:01, Simon Stiefel wrote:
On 13 Sep 2003 at 17:26, James Hatridge wrote:
HI gang!
Hi!
I am trying to do a mysql update. I wrote a small bash file that works
fine at the command line. But I would like to have it ran by PHP whenever
I start the
On Thu, 4 Sep 2003, Balaji H. Kasal wrote:
It is usually better not to use persistenc connections.
So drop the pmysql_connect or if you really need to use
them set set max connections higher for mysql.
Which problem it has?
On a really busy site persistent
On Wed, 3 Sep 2003, Merlin wrote:
After doing some research it looks like this is a problem because I am
using pmysql_connect instead of mysql_connect.
It is usually better not to use persistenc connections.
So drop the pmysql_connect or if you really need to use
them
After doing some research it looks like this is a problem because I am
using pmysql_connect instead of mysql_connect.
It is usually better not to use persistenc connections.
So drop the pmysql_connect or if you really need to use
them set set max connections higher
1 - 100 of 215 matches
Mail list logo