I have a situation where a query run from PHP/Zend Framework on a MySQL
database seems to hit the CPU harder than the same query run via the
MySQL command line.
The query is a simple SELECT statement querying 2 tables, 12 columns
with a short WHERE clause that filters the results to less than 100
On Mon, Nov 29, 2010 at 14:35, Don Wieland d...@dwdataconcepts.com wrote:
Hi all,
Is there a list/form to get some help on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is no the
appropriate forum. Thanks ;-)
Yes.
For MySQL queries,
Hello,
i am writing a small login script for a website.
The username and passwort are stored in a database in two separate columns.
I have it like this:
while($dbbenutzer = mysql_fetch_row($sqlbenutzername))
while($dbpasswort = mysql_fetch_row($sqlpasswort)){
echo
Hi,
Maybe try...
$benutzername = $_GET['username'];
$pass = $_GET['password'];
$result = SELECT * FROM usertable WHERE
sqlbenutzername='$benutzername';
while($r = mysql_fetch_row($result)) {
$dbbenutzer = $r[sqlbenutzername];
$dbpasswort = $r[sqlpasswort];
}
On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote:
Hi,
Maybe try...
$benutzername = $_GET['username'];
$pass = $_GET['password'];
$result = SELECT * FROM usertable WHERE sqlbenutzername='$benutzername';
Don't use values from $_GET without sanitizing first. If using
Yes. You are correct. Did not include that part, sry.
Dont forget mysql_real_escape_string.
:)
Karl
On Apr 29, 2010, at 9:37 AM, Peter Lind wrote:
On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote:
Hi,
Maybe try...
$benutzername = $_GET['username'];
$pass =
On 29 April 2010 16:44, Alexander Schunk asch...@gmail.com wrote:
Hello,
i have it now as follows:
while($dbbenutzer = mysql_fetch_assoc($sqlbenutzername))
while($dbpasswort = mysql_fetch_assoc($sqlpasswort)){
You have things very twisted. Check the code posted by Karl - you only
Hello list
Can someone suggest me a php mysql calender, easy configurable for
special needs?
I found some googling but the most of them query records form a specific
table and its impossible to change the sql query.
Thank you in advance
Nikos
Daniel,
Now that is just funny stuff...
Have you tried
http://lmgtfy.com/?q=access+denied+for+user+odbc+localhost
or the newer
http://www.lmbify.com/search.php?s=access+denied+for+user+odbc+localhost
Daniel Brown danbr...@php.net wrote in message
Dear all,
When I try to retrive data from two tables using JOIN OR INNER JOIN it
display error message
given below;
Warning: mysql_query() [function.mysql-query]: Access denied for user
'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\ap_v5\inc\profile.inc.php on line
On Thu, Jun 18, 2009 at 6:03 AM, NADARAJAH SIVASUTHAN
NADARAJAHnsivasut...@live.com wrote:
Dear all,
When I try to retrive data from two tables using JOIN OR INNER JOIN it
display error message
given below;
Warning: mysql_query() [function.mysql-query]: Access denied for user
On Thu, Jun 18, 2009 at 06:03, NADARAJAH SIVASUTHAN
NADARAJAHnsivasut...@live.com wrote:
Warning: mysql_query() [function.mysql-query]: Access denied for user
'ODBC'@'localhost' (using password: NO) in
C:\wamp\www\ap_v5\inc\profile.inc.php on line 285
Which is the fastest driver for this?
ADODB
PDO
mysqli
Anything else?
--
Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Micah Gersten wrote:
Which is the fastest driver for this?
ADODB
PDO
mysqli
Either mysqli or pdo since they'd deal with the mysql client directly.
ADODB is a php library, so it's not going to be as fast because you have
php code overhead.
--
Postgresql php tutorials
How does the default php_mysql.dll compare to these? Is mysqli faster than
mysql?
tia,
Yves
-- Original Message --
Received: Wed, 19 Nov 2008 04:00:46 PM CST
From: Chris [EMAIL PROTECTED]
To: Micah Gersten [EMAIL PROTECTED]Cc: PHP DB php-db@lists.php.net
Subject: Re: [PHP-DB] PHP MySQL
Chris wrote:
Micah Gersten wrote:
Which is the fastest driver for this?
ADODB
PDO
mysqli
Either mysqli or pdo since they'd deal with the mysql client directly.
ADODB is a php library, so it's not going to be as fast because you
have php code overhead.
ADODB is precompiled for PHP5.
Micah Gersten wrote:
Chris wrote:
Micah Gersten wrote:
Which is the fastest driver for this?
ADODB
PDO
mysqli
Either mysqli or pdo since they'd deal with the mysql client directly.
ADODB is a php library, so it's not going to be as fast because you
have php code overhead.
ADODB is
YVES SUCAET wrote:
How does the default php_mysql.dll compare to these? Is mysqli faster than
mysql?
I'd call that a native driver.
No idea about mysqli vs mysql.
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe,
Chris wrote:
Micah Gersten wrote:
Chris wrote:
Micah Gersten wrote:
Which is the fastest driver for this?
ADODB
PDO
mysqli
Either mysqli or pdo since they'd deal with the mysql client directly.
ADODB is a php library, so it's not going to be as fast because you
have php code overhead.
Micah Gersten wrote:
Chris wrote:
Micah Gersten wrote:
Chris wrote:
Micah Gersten wrote:
Which is the fastest driver for this?
ADODB
PDO
mysqli
Either mysqli or pdo since they'd deal with the mysql client directly.
ADODB is a php library, so it's not going to be as fast because you
have
I should've checked the assumption.
A little strange though for a scripting language. I'd say, since
default behaviour of mysql_* functions is to assume the last opened
link when a parameter is not passed, and since default behaviour is to
evaluate null, false and 0 the same, mysql_* functions
My mistake then, it's been a while that I used it that way so some things do
fade away from my mind.
On Thu, Jun 19, 2008 at 1:57 AM, Chris [EMAIL PROTECTED] wrote:
Isaak Malik wrote:
Because then the connection resource isn't stored in the $link variable
and you will be able to use the
Hello Isaak,
You've scored the bulleye! It works!
Also, I tested by including common.php instead of database.php and it
worked too.
This solution is perfect for me as I can keep my code compact and tidy.
I would, definetely, recommend this site to my fellow developers.
Thank you very much,
It's great that you got your problem solved :).
On Thu, Jun 19, 2008 at 12:30 PM, bateivan [EMAIL PROTECTED] wrote:
Hello Isaak,
You've scored the bulleye! It works!
Also, I tested by including common.php instead of database.php and it
worked too.
This solution is perfect for me as I can
:
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
- Original Message -
From: bateivan [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Tuesday, June 17, 2008 11:19 PM
Subject: [PHP-DB] PHP-MySQL connection
[new code]
if (!mysql_connect($a, $b, $c)) return;
if (!mysql_select_db($dbname)) return;
$res = mysql_query(SELECT * FROM manual;, $link);
[/new code]
Isn't going to work because $link is not defined and definitely not a
resource like mysql_query expects.
OR, optionally, to surpress
Because then the connection resource isn't stored in the $link variable and
you will be able to use the mysql functions without passing that variable to
each function.
On Wed, Jun 18, 2008 at 1:51 AM, Chris [EMAIL PROTECTED] wrote:
It means that either your mysql conenction details are not
Thank you, Chris,
I tried your suggestion using regular connection. Unfortunately, I got the
same result.
See my reply to Isaak,s reply where I am going to post portion of my code to
visualize what I am talking about.
Thanx again
chris smith-9 wrote:
It means that either your mysql
Hello,
To answer these qwestions:
1. I am using include in my code.
2. About the $link = mysql_connect('localhost', 'root', 'testing');
variable. I can just include this line before mysql_query function and it
works even without entering into mysql_query the $link variable. (Like the
connection
Pastebin works lots better when you're posting code: www.pastebin.com
I don't see your database.php included in both of these modules. Where
do you include it?
EVert
On Wed, Jun 18, 2008 at 9:38 PM, bateivan [EMAIL PROTECTED] wrote:
Hello,
To answer these qwestions:
1. I am using include
To Evert:
4. I am posting some of my code to compare. Module carmade.php works v.s.
login.php which does not. Also, I am posting my database.php which is
establishing the connection and is included in every page through
layout.php-common.php-database.php.
To bateivan:
I can only guess that the
Isaak Malik wrote:
Because then the connection resource isn't stored in the $link variable
and you will be able to use the mysql functions without passing that
variable to each function.
RTM again.
The link parameter is completely optional.
If you don't specify it, it uses the last
Hello,
First of all, please, have in mind that I am new in this business.
I have a problem connecting with data base in one particular module. That's
right. The rest of the modules can connect to db, update tables with new
info but this one is refusing giving me message like this:
Warning:
If you get an error of this kind:
Warning: mysql_query() [function.mysql-query]: Access denied for user
'ODBC'@'localhost' (using password: NO) in D:\Program Files\Apache Software
Foundation\Apache2.2\htdocs\login.php on line 17
Warning: mysql_query() [function.mysql-query]: A link to the server
http://myprojects.srhost.info
eric{at}myprojects{dot}srhost{dot}info
- Original Message -
From: bateivan [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Tuesday, June 17, 2008 11:19 PM
Subject: [PHP-DB] PHP-MySQL connection
It means that either your mysql conenction details are not correctly set or
the connection resource isn't accessible for your mysql functions. I suggest
you first try by replacing:
$link = mysql_pconnect('localhost', 'root', 'testing');
into:
mysql_pconnect('localhost', 'root',
excuseme but, you can access by terminal? [shell]
ODBC is the user? or is a ODBC database?
Please answer me and i can help you.
**Excuse me my english is bad. :(
El 17/06/2008, a las 06:51 p.m., Chris escribió:
It means that either your mysql conenction details are not
correctly set or
Hi,
try this,
$carpeta = $_SERVER['DOCUMENT_ROOT']./subidos; // nombre de la carpeta ya
creada. chmool 777 (todos los permisos)
copy($_FILES['file']['tmp_name'] , $carpeta . $_FILE['file']['name']);
Regards,
Tacio Vilela
2008/4/2 Chris [EMAIL PROTECTED]:
$carpeta = subidos; //
Hello
I have the next code:
-- archive_a_subir.php --
form action=archivo_subir.php method=post
enctype=multipart/form-data
input type=file name=file
input type=submit value=ADJUNTAR ARCHIVO
/form
In archive_subir.php:
?
$carpeta = subidos; // nombre de
$carpeta = subidos; // nombre de la carpeta ya creada. chmool 777
(todos los permisos)
copy($_FILES['file']['tmp_name'] , $carpeta . '/' . $_FILE
['file']['name']);
It's $_FILES not $_FILE (an 's' on the end).
It's always worth using error_reporting(E_ALL) and
On Wed, Feb 27, 2008 at 9:52 AM, Tobias Franzén [EMAIL PROTECTED] wrote:
Consider this, if you have not already:
What if two users happen to have the same password?
It is wrong to assume that no two users will never have the same
password. Doing an update like that, just based on the
Daniel Brown wrote:
On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton [EMAIL PROTECTED] wrote:
Hi everyone,
I'm just getting into PHP at the moment and was wondering; what code would I
need to look at a field value entered in a form, then if that value is found
in my table, enter all the
Hi everyone,
I'm just getting into PHP at the moment and was wondering; what code would I
need to look at a field value entered in a form, then if that value is found
in my table, enter all the other information entered in the form, to the
other fields on that record.
Basically, what I'm trying
On Feb 26, 2008, at 8:55 AM, Henry Felton wrote:
Hi everyone,
I'm just getting into PHP at the moment and was wondering; what code
would I
need to look at a field value entered in a form, then if that value
is found
in my table, enter all the other information entered in the form, to
@lists.php.net
Assunto: [PHP-DB] PHP, MySQL and Lookups
Hi everyone,
I'm just getting into PHP at the moment and was wondering; what code would I
need to look at a field value entered in a form, then if that value is found
in my table, enter all the other information entered in the form, to the
other fields
On Tue, Feb 26, 2008 at 8:55 AM, Henry Felton [EMAIL PROTECTED] wrote:
Hi everyone,
I'm just getting into PHP at the moment and was wondering; what code would I
need to look at a field value entered in a form, then if that value is found
in my table, enter all the other information entered
Hi,
I am developing a web site where I have a photos table, several records from
the photos table can be linked to a different table referentially. When I do
a SELECT to all photos records I can get multiple records, I do not have any
problems doing this, the problem is all the procedure after
When I get all the records from the photos table, I am using a web page to
display only the first record, then, if the user hits a next link then the
user should be able to see the next record (next picture) and so on, I do
not want to do a select every time the user hits next or back to get
Hi Chris
How do I save the matrix in the session ?
Actually, my first question is, what do you mean by a session ?
Regards
Eduardo
Chris [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
When I get all the records from the photos table, I am using a web page
to display only
Eduardo Vizcarra wrote:
Hi Chris
How do I save the matrix in the session ?
Actually, my first question is, what do you mean by a session ?
http://www.php.net/session
Look under the examples.
--
Postgresql php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List
I just can't figure it out and Google yielded no help. I have a table named
'settings' which contains two fields, 'item' and 'content'. What I would
like to do is grab that data and use the 'item' field as the name, and use
the respective 'content' as the value in an array. For Example:
Array
On 7/18/07, Dan Maret [EMAIL PROTECTED] wrote:
I just can't figure it out and Google yielded no help. I have a table named
'settings' which contains two fields, 'item' and 'content'. What I would
like to do is grab that data and use the 'item' field as the name, and use
the respective 'content'
Charles Sheinin napsal(a):
Ok, so I have a fully UTF-8 MySQL database with a fully UTF-8 table. I
have a php page which has meta http-equiv=content-type
content=application/xhtml+xml; charset=utf-8 / at the top of the
html section and mysql_set_charset(utf8); after my connection
(it's php
On Jul 12, 2007, at 9:50 PM, Austin C wrote:
Hello, I dont get any errors. Just a blank page. But, I go to the
database,
and it did what I told it to with the header table, but not with the
circulation table.
Check your error log or add this as the first line in your script.
On Jul 12, 2007, at 9:50 PM, Austin C wrote:
Hello, I dont get any errors. Just a blank page. But, I go to the
database,
and it did what I told it to with the header table, but not with the
circulation table.
After you built the SQL for the circulation table, you did not
execute it [with
Ok, so I have a fully UTF-8 MySQL database with a fully UTF-8 table. I have
a php page which has meta http-equiv=content-type
content=application/xhtml+xml; charset=utf-8 / at the top of the html
section and mysql_set_charset(utf8); after my connection (it's php
2.2.3, so that's more or less
Hi
What functions are you using? Many of PHP's functions are not multibyte
aware and default to ASCII. I had this problems myself end of last year.
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello everyone, im trying to use PHP to create 2 tables in a database and
populate them with tables, however, it just wont work. Here is my full code:
?php
$hostname = $_GET['hostname'];
$dbname = $_GET['dbname'];
$dbusername = $_GET['dbusername'];
$dbpassword = $_GET['dbpassword'];
$dbprefix =
Hello, I dont get any errors. Just a blank page. But, I go to the database,
and it did what I told it to with the header table, but not with the
circulation table.
On 7/12/07, Niel [EMAIL PROTECTED] wrote:
Hi
Give us a clue? What's the error(s) you get returned?
--
Niel Archer
--
PHP
- Original Message -
From: Austin C [EMAIL PROTECTED]
To: php-db@lists.php.net
Sent: Friday, July 13, 2007 8:41 AM
Subject: [PHP-DB] PHP MySQL Issue!
Hello everyone, im trying to use PHP to create 2 tables in a database and
populate them with tables, however, it just wont work. Here
Hi
Give us a clue? What's the error(s) you get returned?
--
Niel Archer
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Austin C wrote:
Hello everyone, im trying to use PHP to create 2 tables in a database and
populate them with tables, however, it just wont work.
Where does it stop working? Looks fine from what you've shown us but you
need to track down the problem a bit further.
--
Postgresql php
If anyone is interested in some VERY good webhosting that has support for
PHP and MySQL, please take a look at the following link:
http://www.sturdyhosting.com/idevaffiliate/idevaffiliate.php?id=100
They offer domain names for $8.95 and also webhositng solutions for as low
as $2.95 per month.
If anyone is interested in some VERY good webhosting that has support for
PHP and MySQL, please take a look at the following link:
http://www.sturdyhosting.com/idevaffiliate/idevaffiliate.php?id=100
They offer domain names for $8.95 and also webhositng solutions for as low
as $2.95 per month.
Does anyone know of a program that can generate a good Content Management
System? For example, it would ask which fields to add to a database table,
the types of the fields, etc and create the database in MySQL and php's to
manage the data. I did find a few such programs already (AppGini,
Hello,
Please be patient and assist meI am building a web application where a
search function is required. I have a number of drop down lists from which a
user has to select what they are searching for..they may choose to do a
multi-fields search or search only one.
Are there any resources
CREATIVITY is what you are looking for.
-Original Message-
From: Eustace [mailto:[EMAIL PROTECTED]
Sent: Lunes, 22 de Mayo de 2006 07:59 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] PHP/Mysql search
Hello,
Please be patient and assist meI am building a web application where
http://www.weberdev.com/get_example-4236.html is an example that I wrote
that does this
bastien
From: Eustace [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] PHP/Mysql search
Date: Mon, 22 May 2006 14:58:59 +0200
Hello,
Please be patient and assist
Miguel Guirao wrote:
CREATIVITY is what you are looking for.
What do you mean by CREATIVITY?
-J
-Original Message-
From: Eustace [mailto:[EMAIL PROTECTED]
Sent: Lunes, 22 de Mayo de 2006 07:59 a.m.
To: php-db@lists.php.net
Subject: [PHP-DB] PHP/Mysql search
Hello,
Please
Thanks, I have somewhere to start!
Eustace
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
Sent: Monday, May 22, 2006 4:10 PM
To: [EMAIL PROTECTED]; php-db@lists.php.net
Subject: RE: [PHP-DB] PHP/Mysql search
http://www.weberdev.com/get_example-4236.html is an example
Hello,
We're looking for a PHP developer to work on-site in Long Beach to
start immediately. Job description is below.
Thanks,
Christian
Internet Transaction Services, Inc. - An Internet Paymenet Processing
company located in Long Beach, CA is looking to hire a contract PHP
developer
Hi all,
I intend to create a database to be accessed from a voice application. I
plan to use MySQL as a database engine and PHP as a scripting language to
generate dynamic VoiceXML documents. However, I have two questions I could
not get answers to:
1. Do I need to install Apache to work with
@lists.php.net
Subject: [PHP-DB] PHP, MySQL and Apache
Hi all,
I intend to create a database to be accessed from a voice application. I
plan to use MySQL as a database engine and PHP as a scripting language to
generate dynamic VoiceXML documents. However, I have two questions I could
not get answers
Hi kinfe,
To connect to myql from php you only need build your php with mysql
support.
Now, for render vxml documents you are using apache o IIS ?
I recommend LAMP (Linux+Apache+Myql+Php)
Regards,
Luis Morales
On Mon, 2006-02-27 at 16:07 +0100, Kinfe Tadesse wrote:
Hi all,
I intend
hi guys,
any recommendation on good books or resources for me? I'm totally clueless
about XML but would love to pick it up now. Any one can give me titles of good
books?
thanks!!
look forward to hear from you,
hwee
Hi friends,
I am using one perfect function for my queries for PHP+Oracle pages, this is
below
==
function sorgu($sql)
{
global $baglanti;
$stmt=ociparse($baglanti,$sql);
$sonuc=ociexecute($stmt,OCI_DEFAULT);
$erra=OCIError();
, $conn);
if (!$result){
echo database query failed: . mysql_error();
}else{
return $result;
}//end if
}//end function
?
bastien
From: Rasim ÞEN [EMAIL PROTECTED]
Reply-To: Rasim ÞEN [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB
Hi there everyone,
Just a quick question, I have a login system that stores whether you are
logged in or not with a PHP Session. However, I need it so when people
submit a form to add an item to their cart that Javascript can pickup the
PHP Value of whether people are logged in or not. I
You can have PHP generate a small javascript section where you define the
variables or you can use cookies.
- Frank
Hi there everyone,
Just a quick question, I have a login system that stores whether you
are
logged in or not with a PHP Session. However, I need it so when people
you can supply the value to js as a hidden variable in the form
bastien
From: Chris Payne [EMAIL PROTECTED]
To: php-db@lists.php.net
Subject: [PHP-DB] PHP/MySQL with Javascript
Date: Wed, 15 Jun 2005 16:55:32 -0400
Hi there everyone,
Just a quick question, I have a login system
Everybody's favorite problem but this one is strange. I can connect to my mysql
4.1.7 database fine from the command line, but php won't connect no matter what
I try, I always get the same error.
Here is the script
?php
$link = mysql_connect(localhost:3306, xoops, notmypassword );
/* check
I am running MySQL 3.23.49 under Windows NT (XP Home). I also run PHP 4.3.9 on
the same server, and use phpMyAdmin 2.6.0-pl2 for admin to my databases. I
cannot upgrade to MySQL 4.x becuase apparently the MySQL API included with my
PHP distro is not up to date enough to work with the revised
the folders from the v3 db to the data folder in
the v4 db)
hth
bastien
From: Mark Benson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP, MySQL and phpMyAdmin versions...
Date: Fri, 17 Dec 2004 15:58:08 +
I am running MySQL 3.23.49 under Windows NT (XP Home). I also run PHP 4.3.9
-Original Message-
From: Bastien Koert [mailto:[EMAIL PROTECTED]
huh? you can and should be able to upgrade to 4.0.x without too many
problems. PHP 4.3.9 has no problems with that, nor will PHPMyAdmin.
Moving
to mySQL 4.1 will involve more pain as the protocols are vastly
different
Hi all, currently I have a form which prompts for the user to choose a
date. The dropdown lists are stored into variables:
$month//e.g. January, February, ...
$day //e.g 1 - 31
$year //e.g. 2004 (four digits)
then combined into
$articleDate
How can I
Sure I understand Y-m-d. But won't the database cry because the Month
is in text format? (January, february)? Thanks again.
Subject: Re: [PHP-DB] php mysql dates
On Wed, 28 Jul 2004 14:30:24 -0700, Irm Jr [EMAIL PROTECTED] wrote:
Hi all, currently I have a form which prompts
, is strtotime and date.
$mysqlDate = date('Y-m-d', strtotime($month.' '.$day.', '.$year));
If you're using dates far in the past or future, though, this won't
work. Better to use a date handling class, such as:
http://pear.php.net/package/Date
Subject: Re: [PHP-DB] php mysql dates
On Wed
to the database.
--Nicole
---
Nicole Swan
Web Programming Specialist
Carroll College CCIT
(406)447-4310
-Original Message-
From: Justin Patrin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 3:44 PM
To: Irm Jr
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] php mysql
Thanks for the replies. I believe I have two solutions now!
Take care. Much apprecitated.
-Original Message-
From: Swan, Nicole [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 28, 2004 2:48 PM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] php mysql dates
I would suggest creating
Dear Irm Jr,
Here are two functions::
http::/www.php.net/strtotime
http::/www.php.net/mktime
using these functions togethor you can do the need
full.
BTW why not store just unix time stamp in mysql
database. Most People use a string field in mysql
database to store timestamp, it simply work
I am getting a weird error on one of my servers that says something
about query requires full tablescan. I was not getting this error
until today that I noticed. I Googled for a minute and saw where a ton
of other sites had the same problem but no reason why. I did find one
board that said to
Dear Phpers,
I have the following part of a script that retrieve an URL site. I'd like
to count the clicks for every URL. I have added to mysql table a column
hit. May anybody tell me how to insert into an sql selection also an
update, referring to the HIT variable (i.e. to realize a select and
Hi everyone!
In trying to learn PHP and MySQL, I'm trying to create a web-based database
application that will keep track of my movies. I have five tables (shown in
the graphic). I'm trying to be able to display the results of the tables
with one movie title, all of the actors associated with
Hi All,
This is just a request to all you programmers out there,
I have been programming using PHP/MySql for approx 5 years now.
I was involved in a motor car accident last year October and I broke my
back in 3 places, this has left me paralyzed from the waist down but
luckily my I can still
have redhat 9.0 and Server version: Apache/2.0.40.
i have installed rpms php-4.2.2-17.2.i386.rpm
php-mysql-4.2.2-17.2.i386.rpm
After i create a database called mydb and serveral tables in mysql,
I tried to run following testdb.php script
hello,
did you load the mysql module in your php.ini configuration file?
i.e. is the following line there:
extension=mysql.so
regards
On Thu, 13 May 2004 11:47:41 -0400
Jianping Zhu [EMAIL PROTECTED] wrote:
have redhat 9.0 and Server version: Apache/2.0.40.
i have installed rpms
Hi,
I have a php, mysql security question.
You know how there is a way to enable/disable hot
linking to your images via CPanel to allow/disallow
people to link to your images from an external site?
Well is there a way to allow/disable external sites
connecting to a mysql via PHP?
So is
JeRRy wrote:
You know how there is a way to enable/disable hot
linking to your images via CPanel to allow/disallow
people to link to your images from an external site?
Well is there a way to allow/disable external sites
connecting to a mysql via PHP?
So is there a way to allow only localhost
JeRRy wrote:
Hi,
I have a php, mysql security question.
You know how there is a way to enable/disable hot
linking to your images via CPanel to allow/disallow
people to link to your images from an external site?
Well is there a way to allow/disable external sites
connecting to a mysql via
Oops. For some reason my filter concluded your email was spam and it modifies the
subject line. I missed cleaning the subject line on the first reply. Here is is
again in case others filter on that keyword. I apologize for the double post and
possible confusion.
\Doug
JeRRy wrote:
Hi,
I
1 - 100 of 266 matches
Mail list logo