/php.d/pdo_mysql.ini
Is there something wrong with the installation of PHP/MySQL?
Any help would be greatly appreciated. Thanks,
Ben Miller
extension for newer versions, so
am trying to rewrite the code to use mysqli_connect. For what it's worth,
mysqli_init() also produces Call to undefined function mysqli_init() in my
error logs.
Thanks again,
Ben Miller
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
stated that join queries in phpMyAdmin were a security hazard.
Do you know if such a security hazard exists?
Regards,
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
from what it doesn't
support.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
(apparently it's
not part of the sql-spec).
I think I've even seen MySQL reject it in some cases.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
this syntax:
$row['column']
As opposed to:
$row-column
If you prefer the latter syntax, you can use mysql_fetch_object().
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
/946214/one-sql-query-or-many-in-a-loop
The user whose answer is marked as the correct one (Quassnoi) also writes a
helpful blog on SQL. You should be able to find the blog by clicking on the
username.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
/9780596520830/?CMP=AFC-ak_bookATT=Learning+SQL%2c+Second+Edition%2c
Someone else here might know of some good online resources. I've not seen any,
but then I haven't spent a whole lot of time looking. The parts of Learning
SQL that I've seen are excellent.
Ben
--
PHP Database Mailing List (http
INTO customers (`cust_first`,`cust_last`)
VALUES ('$firstName','$lastName'));
Ben Miller
I'm looking for a quick and simple way to query a MySQL database by date, or
more specifically, by day of the week. My dates are stored in the DB in
-MM-DD HH:MM:SS format. Question, is there a built-in for PHP or MySQL
that will take this column and return only Saturdays, for example,
-Original Message-
From: Ben Miller [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 05, 2008 8:10 PM
To: PHP. DB Mail List
Subject: [PHP-DB] Date Translation in MySQL
I'm looking for a quick and simple way to query a MySQL database by date, or
more specifically, by day of the week. My dates
, so I
appreciate help towards the right direction.
Cheers,
Ben Stones.
(PS: The PHP code is below)
$con = mysql_connect(localhost, ben_test, removed) or
die(mysql_error());
$db = mysql_select_db(ben_test) or die(mysql_error());
$user = $_POST['username'];
$pass = $_POST['password'];
$select_sql
Hello,
Thank you for your help previously everyone, I was able to fix that problem.
The thing now, is that I want to add smileys to the messages; i.e. :) would
equal to a smiley image when posting a message.
$con = mysql_connect(localhost,removed,removed) or die(con);
$db =
Hello, my name is Ben Stones. I am quite a beginner to PHP, and as a new
years resolution I am going to learn PHP (finally!)
Cut to the chase I have created a basic looping script that would display
anything submitted in a form, on seperate lines; here is the PHP code:
$con = mysql_connect
added as before or something.
Any help once again is appreciated.
Thank you,
Ben Stones.
On Jan 3, 2008 3:16 AM, Benjamin Darwin [EMAIL PROTECTED] wrote:
Ben:
First, using a $_POST value directly into a MySQL query is EXTREMELY
unsafe. Always filter data from any source to make sure it's what
I believe this does exactly what you want.
http://us3.php.net/extract
Ben Hatfield
Programmer
[EMAIL PROTECTED]
Soapbox Studio, Inc.
469 N. Lake Street
Mundelein, IL 60060
P: +1.847.566.0666 x6#
www.soapboxstudio.com
On Jul 26, 2006, at 12:14 pm, z wrote:
Hi,
I have a table with about 50
if im wrong I would like to know the reason also :)
Thanks in advance,
Ben-Nes Yonatan
Louie,
Try reading through this guide on Unicode. Its going to take a lot more
than what your doing to get it to work correctly.
http://www.phpwact.org/php/i18n/charsets?s=utf8
-Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
before header() is called. The same problem
exists when using a single PHP/HTML file.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello all,
As a beginner I have been trying to send two attachments from my HTML form.
Below is the code I have been using. The problem is, I seem to only be able
to send one or the other, when I send both, although they go through, the
text I want displayed tags 6110 etc, is also sent as an
All,
I am needing to send two attachments from my form. Both fields are called
'fileatt' and 'fileatt1'. Below is the script i wrote to attach 'fileatt'
but i am unsure on how to attach 'fileatt1'. Can I just add fileatt1 or do I
need to rethink how I do it?
Many thanks
// Obtain file upload
Hi all,
When I submit my forms, if any textfield contains a ' the result comes back
with /'
Is there anyway of stopping this?
Thanks
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
}--\n;
Many thanks
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
that would reject and email that has tags eg '1010: '
Many thanks in advance
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
:04
To: [EMAIL PROTECTED]
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] New to the Mailing List
Try using the if statement.
Ben wrote:
Morning all.
I attach a document, which is used to send an email with attachments.
What I need to do though, is if a form field is left blank, then that
tag
Hi,
My DBA's preferred authentication method is to set up a UNIX user
account (i.e. userA) and let them login without using plaintext password
authentication, ie. The user has to be logged in, they can then run (for
example) sqlplus / and that will log them into the correct database.
This
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 04 October 2004 15:48
To: Ben Gill
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP Oracle Authentication using UNIX user account
A couple notes / assumptions ..
(1) The web server is on a different machine then database
(2) The DB is not allowing remote
referring to the additional time it would take
the script to run or to a security issue or something else?
Thanks, Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, `mytable`);
which, too, didn't work.
Would appreciate any advice,
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
this code
runs, are the dollar signs before mysql_connect(), mysql_select_db()
and mysql_query() are not needed.
You're right. It doesn't run. I retyped instead of copy-and-paste'd;
that's a typo.
Cheers,
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
My last email shows on the archive but it also bounced back to me so I
am reposting it. Sorry of this is a double-post.
Also, I am adding this time the source code down below which I should
have probably done last time around.
Any help is much appreciated, Ben.
repost
Hello guys,
I have
(db, server) in a danger with this script?
Cheers,
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
in the tuchus for listservs and the like, unless the person
running the program sets the parameters correctly to allow email addressed
to the list to get through, otherwise, each person on the list has to go
through the challenge and response procedure.
HTH,
-Ben
At 02:13 PM 8/5/2004, Mark wrote
- http://www.tgpwizards.com - leads me to
believe something else is happening that ain't so legit.
This should be forwarded to the list admin...
-Ben
At 02:39 PM 8/5/2004, Ben Riddell wrote:
Spamcease is whitelist software for controlling Spam. It maintains a list
of people from whom
On Thu, 2003-10-09 at 17:35, pete M wrote:
http://www.php.net/manual/en/function.mysql-error.php
Ben Edwards wrote:
On Thu, 2003-10-09 at 16:33, pete M wrote:
$new_id = mysql_query('select last_insert_id()');
your can also user it within a query - eg
$sql = ' insert into related
message, i.e.
$new_id = mysql_query('select error()');
I currently am trying to solve the problem or mysql_error() returning
nothing after an error. It may be something to do with globals and
something like the above may help.
Ben
of problems.
Are they any other ways of getting the error?
Ben
function query_db( $sql, $db ) {
$result = mysql_query( $sql, $db ) or
error_db( $sql, $db );
return $result;
}
function error_db( $sql, $db ) {
global $SERVER_NAME, $SCRIPT_NAME;
table_top( Database Error
Don't think globals are off on our server, not having to use $_GET etc.
If they were turned of how would I access the MySQL error message?
Ben
On Wed, 2003-10-08 at 15:59, mike karthauser wrote:
on 8/10/03 3:04 pm, Ben Edwards at [EMAIL PROTECTED] wrote:
Any help would be greatly
Hehe, ok, that was bad there for a second :)
Ben
-Original Message-
From: Brian Dailey [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 3:24 PM
To: Ben Lake; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] SELECT FROM 2 or more tables
No, he meant rarely want to join entire tables
PHP 5.0 doesn't come with mysql support... You have to get the libraries
yourself... I think u can get them from mysql.com
Might have to pay? I haven't totally figure out the implications of the
no mysql in PHP 5.0 yet, but I know its not there.
Ben
-Original Message-
From: Kai [mailto
You cannot write anything out before the session_start() call.
The error tells you that you have written something at:
output started at c:\inetpub\wwwroot\ads4u\data_valid_fns.php:25
Check for any echo, print or html output before session_start()
Hope that helps,
Ben
Ahmed Abdelaliem [EMAIL
http://www.mysql.com/doc/en/mysqldump.html
www.mysql.com - Documentation - search = answers
Ben
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Friday, July 04, 2003 4:02 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Backing up entire database...
I wanna back
WTF does To unsubscribe, visit: http://www.php.net/unsub.php; at the
bottom of every e-mail mean to you idgit?
Ben
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 01, 2003 4:38 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] hmmm
YOU FUCKING SHIT
to be used that is
causing all of the fuss?
Correct me if I'm wrong, just trying to figure out what's going to
happen to some legacy stuff when 5 hits the fan!
Thanks,
Ben Lake
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am using the below function (error_db) witch is called thus:-
function query_db( $sql, $db ) {
$result = mysql_query( $sql, $db ) or
error_db( $sql, $db );
return $result;
}
But $sqlerr is always blank (it is set with '$sqlerr = mysql_error( $db
);'). Any idea why?
Ben
from MySQL to
Postgress.
Proples general experiences/comments also welcome.
Beb
* Ben Edwards +44 (0)117 968 2602 *
* Critical Site Builderhttp://www.criticaldistribution.com *
* online collaborative
-
From: Ben Edwards [mailto:[EMAIL PROTECTED]
Sent: maandag 24 maart 2003 12:03
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL or Postgres
Could someone please point me in the correct direction for a decent
comparison of the two in respect of:-
Reliability
Scalability
Speed
Functionality
either 1 or 2 as the value for Test.
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 11, 2003 2:43 PM
To: Ben Walling; '[EMAIL PROTECTED]'
Subject: RE: Stumped again...
I don't really understand this suggestion. Could someone possibly
Couldn't you use the 'for each' method on $_POST instead?
.b
-Original Message-
From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 16:44
To: 'Fred Wright'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: Undefined index and variables
Fred,
I don't have
Check the PHP-DB archives ;-)
http://news.php.net/article.php?group=php.dbarticle=22433
Hatem
- Original Message -
From: Rich Hutchins [EMAIL PROTECTED]
To: Seabird [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 12:24 AM
Subject: RE: [PHP-DB] small database
As
Hi all!
Does anyone know where can i find some information about displaying flash from a db?
I'm breaking my head over it, searching at newsgroups, searching at the net,
addressing newsgroups but still nothing!
Help b4 im cutting my hands off!!!
With hopes to be saved :P
Yonatan Ben-Nes
itself!
can anyone help me with this or just give me a link to related info?
Thanks in advance,
Ben-Nes Yonatan
p.s
first time that i use newsgroups for such things... so.. if i did something wrong just
notify me :P
hello,
you can do it this way (using mysql):
?php
/*
create table images(
img_id int(4) NOT NULL auto_increment,
img_name varchar(60),
img_file_type varchar(10),
img_content blob,
PRIMARY KEY (img_id)
) TYPE=MyISAM;
*/
if (empty($imgfile) or $go!==uploadimg)
{
// Generate the form to upload the
Oops sorry for never testing before sending :P the script works fine
but there is a little change, there is a hiddent should be changed to hidden
in the form ;)
that's all,
enjoy
- Original Message -
From: Hatem Ben [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002
i was trying to do it with preg_replace, but this is much better
thanks a lot,
Hatem
- Original Message -
From: Rasmus Lerdorf [EMAIL PROTECTED]
To: Hatem Ben [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, October 06, 2002 3:09 AM
Subject: Re: [PHP-DB] Some data manipulation
hey all
i have a database of arrays like this :
Array
(
[0] = 2-
[1] = 8b2
[2] = 8#c3
[3] = 8b2
[4] = 8#f2
[5] = 4a2
[6] = 8a1
[7] = 8a2
[8] = 4a2
[9] = 4a2
[10] = 4a2
)
i just need to change in every string the last value when it is equal to 1,2
$_REQUEST is an associative array consisting of the contents of $_GET,
$_POST, $_COOKIE, and $_FILES
http://www.php.net/manual/en/reserved.variables.php
- Original Message -
From: Shoulder to Shoulder Farm [EMAIL PROTECTED]
To: PHP Database List [EMAIL PROTECTED]
Sent: Sunday, October
i've check it, and also try it, code generated for a sample database won't
run okay, most pages return errors !
if it will support others database, it will be a great tool
Best regards,
Hatem
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'johnny1b1g' [EMAIL
a php/mysql already exist : http://www.bigprof.com/appgini/
- Original Message -
From: John W. Holmes [EMAIL PROTECTED]
To: 'johnny1b1g' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, September 29, 2002 4:19 PM
Subject: RE: [PHP-DB] Very cool -= Code Generator =- !!!
Use Codejay
both tools don't work okay for me, i'm just using the export tool in
MsAccess then convert database to xml, and thanks to PHP, i convert that to
mysql queries.
Just one problem when i want to convert binary data (pict or others), still
haven't find a suitable solution for that.
Best regards,
? Or am I completely wrong about that? All suggestions and help
appreciated.
Thanks, Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
How do you get the date that is 14 days from today's date.
I am using PHP4 and MySQL. I can get that date with MySQL monitor but php. I
have tried many things but nothing works.
Does anyone give me a help?
Thank you.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e
How do you get the date that is 14 days from today's date?
I can get that date with mysql monitor but PHP. I am using PHP4 and MySQL. I
have tried many things but nothing works.
Does anyone give me a help?
Thank you.
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e
you should look things up in the manual, there is a
PDF and web searchable version for both MySQL and PHP. Search for
AUTO_INCREMENT.
Although I am impressed you are using db list not general one ;)
Ben
At 07:15 P 21/10/01, Brett Conrad wrote:
Hi.
I'm creating a class mapped to the functions
afford our own box.
The latest documentation categorically states there is no other way of
changing this.
**
* Ben Edwards+352 091 429995 *
* Homepagehttp://www.gifford.co.uk/~bedwards
a alternative fullsearch method.
Ben
**
* Ben Edwards+352 091 429995 *
* Homepagehttp://www.gifford.co.uk/~bedwards *
* i-Contact Progressive Videohttp://www.videonetwork.org *
* Smashing
it will work. I'm hesitant to
try it, because I can't create a new database, and I don't want to try it
on live data.
So, can anyone see a problem with this, aside from the old why do you
want to do that? crap?
Thanks,
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
be that difficult... but would probably slow the
application down... I fear that, because of the relationships I have, if
I ever decide to compact the database later, it will be an extremely
trying task.
Thanks,
Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL
?php
$date = 2001-07-19; // as if it just came from the db
$date_array = explode('-',$date);
$date = $date_array[1] . - . $date_array[2] . - .
$date_array[0];
?
That should do it =
Good luck!
Ben
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
You could split the string on the slashes with explode('/',$string) and
then manipulate the array elements you get back.
Good luck,
Ben
-Original Message-
From: Dennis Kaandorp [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 9:21 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB
Sure he is. Right here:
$queryResult = mysql_query($sql);
what exact error is occurring?
-Original Message-
From: Matthew Loff [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 5:00 PM
To: 'Mark Gordon'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Dynamic SQL + result resource error
Guess I'm just a big dumbass then, aren't I =P
Oops.
I suppose that would cause it to fail then, wouldn't it?
= Ben
-Original Message-
From: Matthew Loff [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 5:10 PM
To: 'Ben Bleything'; 'Mark Gordon'; [EMAIL PROTECTED]
Subject: RE
It works for me... except that you need a semi-colon after 'return
$returned_string' and it sticks the word OR at the end of the whole
string, which you may not want.
Does that help, or did I miss the point?
Ben
-Original Message-
From: Brad Lipovsky [mailto:[EMAIL PROTECTED]]
Sent
of the statement. But I cant see what...
Pls help.
Thanks in advance.
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web: http://www.intasept.com
MAKING sense of
the INFORMATION
TECHNOLOGY age
@ WORK..
--
PHP Database Mailing
files
go where etc...
Thanks.
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web: http://www.intasept.com
"MAKING sense of
the INFORMATION
TECHNOLOGY age
@ WORK.."
--
PHP Database Mailing List (http://w
Closing a MySQL connection is a good habit to get into,
However, what you describe, doesn't sound like a PHP error, it may just be one
of the many errors with msie rearing its head.
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL
What is the best field type to use for an Auto_Increment field?
i am using int at the moment, is there a better one?
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web: http://www.intasept.com
"MAKING
tatus = \"deceased\"";
--
Ben
History is curious stuff You'd think by now we had enough Yet the fact
remains I fear They make more of it every year.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL P
, definitely worth trying http://www.irt.org I would be
very supprised if there wasn't an FAQ specifically about this (its actually
very easy to do in Javascript).
Have fun,
Ben Stoneham
Technical Director - FCP Internet LTD
___
FCP
as variables inside a separate
script that is then called via and 'include' statement (which should then be
read-only to 'root' if memory server me right -its been a long time since I
ran PHP this way!).
Ben Stoneham
Technical Director - FCP Internet LTD
If was to create a table in a database with 19 Fields, and define them all
as a BLOB, even though some of them may only hold a max of 10 characters.
What would be the implications of this?
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail
81 matches
Mail list logo