Can we kill this thread? Or can you guys continue the conversation between
yourselves. We now have 8 emails pertaining to the technical question, and
8 emails ranting about him asking it.
I understand that some people do not believe this is the appropriate forum
for that question - but personal
On 6/18/2014 2:16 PM, Aziz Saleh wrote:
On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers
wrote:
Sent from losPhone
On Jun 18, 2014, at 7:56 AM, Jim Giner
wrote:
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
Hi Ethan,
Here are
On Wed, Jun 18, 2014 at 2:13 PM, Karl DeSaulniers
wrote:
>
>
> Sent from losPhone
>
> > On Jun 18, 2014, at 7:56 AM, Jim Giner
> wrote:
> >
> >> On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
> >>> On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
> >>> Hi Ethan,
> >>>
> >>> Here are some
Sent from losPhone
> On Jun 18, 2014, at 7:56 AM, Jim Giner wrote:
>
>> On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
>>> On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
>>> Hi Ethan,
>>>
>>> Here are some things to clean up your code:
>>>
>>> Your line:
>>>
>>> $phn = $_POST[phone
On 6/18/2014 12:31 AM, Ethan Rosenberg, PhD wrote:
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
Hi Ethan,
Here are some things to clean up your code:
Your line:
$phn = $_POST[phone];
should use quotations as follows:
$phn = $_POST['phone'];
Your line:
$sql1 ='select Lname, Fname fr
On 06/17/2014 12:02 PM, onatawah...@yahoo.ca wrote:
Hi Ethan,
Here are some things to clean up your code:
Your line:
$phn = $_POST[phone];
should use quotations as follows:
$phn = $_POST['phone'];
Your line:
$sql1 ='select Lname, Fname from Customers where Phone = $Phn ';
Should use doubl
Hi Ethan,
Here are some things to clean up your code:
Your line:
$phn = $_POST[phone];
should use quotations as follows:
$phn = $_POST['phone'];
Your line:
$sql1 ='select Lname, Fname from Customers where Phone = $Phn ';
Should use double quotes if you need the variable to be interpreted:
Oh a few quick things.
First, you can use substr to break up the phone instead of grabbing characters-
might be a little easier to read long term.
Secondly, mysql_real_escape_string will return the cleaned string, but doesn't
change the original variable. So you'll need $phn =
mysql_real_esc
On Jun 16, 2014, at 10:05 PM, Karl DeSaulniers wrote:
> On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg
> wrote:
>
>> Dear List -
>>
>> I have the following code:
>>
>> The input from the form is a 10 digit string [1234567890] which is converted
>> to phone number format [123-456-7890]
>>
>>
On Mon, Jun 16, 2014 at 10:58 PM, Ethan Rosenberg <
erosenb...@hygeiabiomedical.com> wrote:
> Dear List -
>
> I have the following code:
>
> The input from the form is a 10 digit string [1234567890] which is
> converted to phone number format [123-456-7890]
>
> $phn = $_POST[phone];
> $phn = (str
On Jun 16, 2014, at 9:58 PM, Ethan Rosenberg
wrote:
> Dear List -
>
> I have the following code:
>
> The input from the form is a 10 digit string [1234567890] which is converted
> to phone number format [123-456-7890]
>
> $phn = $_POST[phone];
> $phn = (string)$phn;
> $dsh = '-';
> $Phn =
>
When I switch back to user root with empty password and use
mysql_connect("localhost", "root") it works.
I just found out when I set the permission for "myuser" to "localhost"
instead of "any" it works also for "myuser".
Now I have to check out why I canÂt use passwords. Maybe the PHP Version
IÂm
You're right:
if you use mysql_connect("localhost", "root","");
you''ll get "acces denied for user [EMAIL PROTECTED]
if you use mysql_connect("localhost");
you'll get "Access denied for user @localhost"
I'll google for a while... but.. to solve YOUR problem, just use:
mysql_connect("localhost","us
I have chosen an empty password. I know that this is a security problem.
IÂm using it for testing at the moment only. I use it because there also
seems to be an issue with php connecting to mysql servers with verions >
4.1.
When trying to connect with password I get this:
Connect failed : Client
Hi
try $db = mysql_connect("localhost", "myuser","mypassword") - without it you are not
submitting a password
Peter
> -Original Message-
> From: Christian Schlaefcke [mailto:[EMAIL PROTECTED]
> Sent: 24 September 2004 13:31
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Newbie Question
This might be a stupid idea, but did you remember to issue the Flush Privelages;
command to the mysql database after granting your user all the rights?
--John
Christian Schlaefcke <[EMAIL PROTECTED]> wrote:
Hi Folks,
I want to do something like the following:
$db = mysql_connect("localhost",
Try:
> -Original Message-
> From: Gajo Csaba [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 24, 2004 4:10 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Newbie question
>
>
> Hi!
> I'm new to PHP, so this may be an easy question. I tried to make a
> simple form-page, where the u
On Fri, 13 Feb 2004, t wrote:
> hi,
>
> i am relatively new to php and new to this email list.
>
> i have what i think are fairly simple questions about using mysql and
> php. i have done some research and can't seem to find the answer i
> need.
>
> # 1. i want to set the date format to display da
From: "Joffrey Leevy" <[EMAIL PROTECTED]>
> Curious as to what happens after data is repeatedly
> selected from a mysql table overtime. Does it
> accumulate as junk data, stored at some location and
> eventually slow down the database/program/server?
> Does any purging have to take place?
I woul
//Place your request into a variable:
$result = odbc_do($connection,"select * from events where id=$id");
$var = odbc_fetch_row($result);
// Now you have an array to work on
foreach($var as $line){
//Do your formatting thusly:
echo '
' . $line[0] . '
$cnx = odbc_connect( 'DSN' , 'USER', 'PASS' );
if (!$cnx) {
?>Could not connect to ODBCmailto:[EMAIL PROTECTED]]
Sent: Sunday, February 16, 2003 4:01 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Newbie Question - PHP and MSACCESS
Hi,
Am using php to open a customer's msaccess file.
Fi
great!
@ryan & josh: thank you for the quick answers! :-)
marcus
--
^v^
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
It suppresses error messages and warnings when you call a function,
regardless of your level of error reporting.
So yeah, it is like batch programming :)
-- Josh
-Original Message-
From: Marcus Fleige [mailto:marcus.fleige@;gmx.de]
Sent: Wednesday, October 30, 2002 7:05 PM
To: PHP-Mail
Well the only difference I see is the ? ... hehe... but if you are refering to the @
symbol then you are correct ... ignore errors... :-)
<>< Ryan
-Original Message-
From: Marcus Fleige [mailto:marcus.fleige@;gmx.de]
Sent: Wednesday, October 30, 2002 5:05 PM
To: PHP-Mailinglist
Subject:
ok, thnx
> No, but SQL is your friend
*lol*
greez
daniel
--
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]
No, but SQL is your friend, and is actually easier than messing around with
recordsets, once you get the hang of it.
The exact form of your INSERT statement will depend a bit on the database
are you using, but the following is typical. This is MySQL syntax, I
believe PostgresSQL is similar.
I
>>Hi Kodrik:
I just looked at your function and would like to use it myself, but shouldn't
the ampersand line:
$copy=eregi_replace ("&", "&", $copy);
look like this instead? So it matches the other lines that have a symbol
replaced by HTML??
$copy=eregi_replace ("&", "&", $copy);
Cheers.
Russ<<
Yes there is:
Using a php function called: nl2br()
When the data is called from the db and printed to the page use $textdata =
nl2br($textdata)
This will preserve the enter button being pressed.
Regards:
Russ
On Thu, 08 Nov 2001 09:54:16 -0600 Jay Fitzgerald <[EMAIL PROTECTED]> wrote:
> Ok, I
5 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE
statement in mysql
No, I am not trying to delete with a select statement. That was just there
to show my tables, fields, etc.
So if I understand what you are saying I can not do a delete statement with
a join in i
Hi!
In MySQL-4.0.0 you can delete from several tables in a join:
DELETE t1, t2 FROM t1, t2, t3 WHERE ...;
But 4.0.0 is still alpha, and it will take some months for it to
stabilize. No compact or defrag is normally needed with
MySQL.
Regards,
Heikki
http://www.innodb.com
Shaun Honsvick wrote
No, I am not trying to delete with a select statement. That was just there
to show my tables, fields, etc.
So if I understand what you are saying I can not do a delete statement with
a join in it. I would have to query each individual row for the ID that need
to be deleted, delete the row in the
EXACTLY what I was looking for...
Thanks!
http://www.bustdustr.net
Home of Radio Free Bd
- Original Message -
From: CC Zona <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 1:42 PM
Subject: Re: [PHP-DB] Newbie question
> In article <034
In article <034101c0d3f3$0dd747e0$41041dd8@winbox>,
[EMAIL PROTECTED] ("~BD~") wrote:
> at the end of my script, I run a set of closing and clean-up procedures..
> what I would like to be able to do is that when a user bails out of the
> script by closing the browser or leaving the site/page, de
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
At 25.03.2001 22:36, you wrote:
>Hello boys that's ok?? well
>I have this question
>I connect to a database (on interbase 6) and retrive some datas from a
>table...
>now i want to create a form where the input field show old datas into
]>
Sent: Monday, February 05, 2001 9:49 AM
Subject: Re: [PHP-DB] newbie question
> Hi Lisa,
>
> >Can search engines index any HTML pages that have .php as its extension
(any
> >.php pages without a '?' or '&' in the URL) ? For example:
> >http://
Hi Lisa,
>Can search engines index any HTML pages that have .php as its extension (any
>.php pages without a '?' or '&' in the URL) ? For example:
>http://www.blablabla.com/blabla.php
>
>Thanks,
>Lisa E
yes they can, but my experience is, that most search engine robots do _not_
index pages endi
Yes,
It will index the page as any html page
At 10:58 PM 1/27/01 +0700, Lisa Elita wrote:
>Can search engines index any HTML pages that have .php as its extension (any
>.php pages without a '?' or '&' in the URL) ? For example:
>http://www.blablabla.com/blabla.php
>
>Thanks,
>Lisa E
>
>
>
>
>--
37 matches
Mail list logo
