the returned data.
Is there an option I'm missing to assign a field as the output array index from
a PHP based query?
Thanks,
--
Richard Scotford
Mysql 8 is already the stable version and has been for a while. I for
development use it on windows and its v8
-Original Message-
From: Ruprecht Helms
Sent: 08 September 2021 16:02
To: php-db@lists.php.net
Subject: Re: [PHP-DB] MySQLnd support for ed25519
Hi Dimi,
I think mysql 8
I have made multiple attempts to get PDO-OCI to work in PHP 7. Sometimes it
fails to compile at all, other times appears to compile correctly, but I
can't connect to any Oracle databases. Thus far, this has kept me stuck on
PHP 5.x.
The relevant part of my configure statement is:
./configure
Hi! This is the ezmlm program. I'm managing the
php-db@lists.php.net mailing list.
I'm working for my owner, who can be reached
at php-db-ow...@lists.php.net.
To confirm that you would like
arch...@mail-archive.com
added to the php-db mailing list, please send
an empty reply to this address
Running PHP 5.3.5 on FreeBSD 8.2 connecting to a MySQL 5.1.55
server.
Why does this code (below) run out of memory? It queries
test_table for all rows, all fields and sorts them by the numeric
'contract' field. It then iterates through the rows, and tallies
the number of rows per contract
,
and was surprised to find that the routine ran out of memory.
This simple counting exercise is merely a test of the loop
algorithm so that I can do a 'cmp' or 'diff' comparison of the
output of the PHP versus the output of the SQL to verify that in
fact the PHP algorithm is indeed finding and processing each
you are ordering by contract as in the example select.
Thanks for that suggestion, also.
Something more fundamental is going on.
Here is simpler code which still reproduces the problem.
?php
require_once( '../include/mysql_funcs.php' );
$test_db_host = localhost;
$test_db_user = msm
On Thu, Oct 27, 2011 at 10:43:48PM -0500, Karl DeSaulniers wrote:
Maybe this..
HTH,
?php
...
$result = mysql_query( $qry, $db_conn ) or die( mysql_error() . \n );
$num_rows = mysql_numrows($result);
if(!$result || ($num_rows = 0)){
echo Error displaying info;
}
else
icon
again, move to Apache, then Service, and then click on Test port 80, then
you should get something like
--
Your port 80 is actually used by :
Server: Apache/2.2.11 (Win32) PHP/5.2.8
Press Enter to exit
notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the
following keys:
$array['MIN(id)'] and $array['MAX(id)']
Just something I figured out recently :)
Matt
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
___
Sent by ePrompter
by title but listing out all the Cats products
first. Any way to do that without having separate statements?
Thanks...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
___
Sent
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Assuming you're using MySQL, try MONTH(). As in:
SELECT MONTH(SomeDateField) FROM SomeTable
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
If this isn't a database question, but a general PHP question, try this:
// For numeric month without leading zero, use n
echo date
Try this as your SQL. It should give you all the results, then you can use PHP
to sort it all out.
SELECT * FROM egw_cal WHERE cal_category='501' and cal_id in (SELECT cal_id
FROM egw_cal_dates where cal_start $tstamp)
-TG
= = = Original message = = =
Hello Everyone
Got a simple
Not sure if this is exactly what you're looking for, Matt, but I think it is.
?php
$query = SELECT t1.NAME, t1.BUSINESS, t1.ADDRESS, t1.CITY, t1.PHONE,
t2.CONTACT_NAME, t2.CONTACT_VALUE FROM Table1 as t1, Table2 as t2 WHERE t1.ID =
t2.CONTACT_ID
$result = mysql_query($query);
while ($row
they are linked to the first table
thanks...
Matt
- Original Message -
From: [EMAIL PROTECTED]
To: php-db@lists.php.net
Cc: [EMAIL PROTECTED]
Sent: Friday, January 12, 2007 4:26 PM
Subject: Re: [PHP-DB] 2 queries -- 1 array
Not sure if this is exactly what you're looking for, Matt, but I think
Pennsylvania.
This current process gives me four different PA links on my page.
I need a statement that says...if its already printed...don't print it...
Thanks...
Here is my code:
html
body
?php
$db = mysql_connect(HOST, USERNAME, PASSWORD);
mysql_select_db(DATABASE,$db);
if ($_GET
I am wondering what the mySQL commands are to display the next 10
records / previous 10 records.
I am wondering how you pass a variable through a PHP script so the
script knows which next or previous 10 entries to display. (Especially
since this is all variable driven) Would you do something
I would normally just pass the offset through the get var.
I understand what you are saying in concept ... but what would a sample
command be like?
a href=http://www.host.com/script.php?next=21;Next Link/a
a href=http://www.host.com/script.php?previous=1;Previous Link/a
Ron
: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http
: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http
College
www.wncc.edu
775-445-3326
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
the following connection string:
php:
--
$connection = mssql_connect http://php.net/mssql_connect('server','user',
'password') or die ('server connection failed');
$database = mssql_select_db http://php.net/mssql_select_db(database_name
, $connection) or die ('DB selection failed
~table width='100%' id='table1' cellspacing=0theadtr
th scope=colShop name/th
/tr/theadtbody
?php
// database information
$host = 'xxx';
$user = 'xxx';
$password = 'xxx';
$dbName = 'xxx';
mysql_connect(localhost,$user,$password);
@mysql_select_db($dbName ) or die( Sorry
Is it possible to do an ORDER BY column_a column_b ASC ? IE Can you
specify two columns to cause the output to be displayed in a specific
order? Ron
If I give this command through PHP to mySQL
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( Unable to select database);
$query = UPDATE `table` SET `last_activity_field` = '$current_date'
WHERE `reference` = '$account_reference' LIMIT 1;;
mysql_query($query
Is there a slick and easy way to convert January to 01 ? (and February
to 02, etc) Ron
I have completely missed it and need to try again.
The way my web hosting server was configured is that files uploaded
through a web form to be processed by PHP are owned by 'www'. I am
wondering if I am able to change the owner of the file to my ftp user
name before I use the move_uploaded_file command to the directory I need
the file to move
In one of my scripts I have
input type=text name=message_title size=40 maxlength=80 value=?echo
$saved_message_title;?
where
$saved_message_title is 1 Peter 5:7 Cast all your cares on Him for He
cares about you
--- note the
When this is displayed on the screen it reads
1 Peter 5:7
I am
I am wondering if someone would help me write a SELECT date query ...
Weekly mailings go out every Wednesday. I am setting up an
administration function and table to store the mailing name, PDF to be
contained within the mailing and the date for it to be used.
The SELECT query I want to create
and in a MySQL database.
___
Shaun Riches
Computer Science Student
-Original Message-
From: Ron Piggott (PHP) [mailto:[EMAIL PROTECTED]
Sent: Thu 28/09/2006 03:44
To: PHP DB
Subject: [PHP-DB] Search engine
___
Shaun Riches
Computer Science
I have been playing tonight for a few minutes.
The following code:
?
$lineArray = file(/home/actsmin/www/home_page.html);
// make an empty variable first
$content = ;
// concat all array element
foreach($lineArray as $eachLine) {
if ( eregi(a href= , $eachLine) == 1 ) {
#line contains a
Where '$eachLine' is a line of HTML code the following command
echo str_replace(a href=\, , trim(stristr($eachLine, a
href=))) . \r\n;
give me this result:
http://www.actsministrieschristianevangelism.org/christianliving/quiet_time_quotations_and_reflection_topics.html;here.
I want to get rid
Is there a predefined variable that will tell me the resolution of the
browser that is looking at my site?
EXAMPLE 1024 X 768 OR 800 X 600
Ron
Has anyone wrote a search engine for the web site? I am wondering if
someone has the time to help me walk through doing this. Ron
the javascript open the result page after the update is complete. I do this on
several of my webpages and it works great.
Tamkhane, Pravin wrote:
Hi All,
I am a PHP newbie. I am using HTTP POST request to send some data to
Apache and then using MySql to store that information. Once information
I realized this is off topic; I am not sure where I would look online.
Today I purchased a VX724 LCD monitor for my computer. I am running
Fedora Core (Linux). I am not sure where I would find a driver for my
monitor. ViewSonic's tech support told me they don't support the
monitor directly
I am creating a submit button on the fly. The purpose of this is to
open up a new browser window and then display the contents of a PDF
file.
The code for this button reads:
input type='button' value='Psalm 91'
You know forms which have a security field where the user reads back the
letters that are displayed? I am wondering if someone has the time to
coach me in writing this --- or if you know of a web page that shows how
to create this feature. I have already created a set of graphical
letters. Ron
cron or Windows Task Manager would work if you want to check the status of the
data periodically, but I believe you can also use Access to hit a web address
(it doesn't have to display anything) so you could, at time of insert, have
Access activate a PHP script on your web server that does
You may get duplicate messages sometimes when someone responds directly to you
as well as copying the message to the main mailing list. Like in this ccase,
my To: field is the PHP DB list, and my CC: field is your personal email
address.
If that's not the issue, then try what Dave suggested
Here are some thoughts on the couple of methods shown:
1.
SELECT count(*) as MyCount FROM aTable # Fast query done on server size
SELECT * FROM aTable LIMIT 5 # Fast limited data return query done server side
2.
SELECT * FROM aTable # Potentially slow query, lots of data stored in PHP
' command works within the context of a php script when
activated by a user on the web site.
Is there another file deletion command within PHP other than unlink?
Here is the error message I am e-mailed by the cron when it doesn't
successfully delete a session file:
Warning: unlink(/path
Every now and then the following command fails --- the FTP connection is
refused by the server:
$conn_id = ftp_connect($ftp_server);
Is there a way to delete a file within PHP without having to FTP to the
server?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
Thank you for the thought, however, I don't have a shell that I can run in,
hence, I have to rely on help from others.
JupiterHost.Net [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Grae Wolfe - PHP wrote:
Sorry I have been out of touch... I thought I had this problem beat
.
If users can update their own data, should you not have a log in process
to ensure that only the original user can update his data? Them once he
has logged in, you can populate all fields with data from the DB.
Jeffrey
Grae Wolfe - PHP wrote:
That was the first thing that I was going to do
',
registration_comments='$registration_comments',
date_registered='$today'
WHERE first_name='$first_name' AND last_name='$last_name';
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
in message
news:[EMAIL PROTECTED]
Why don't you try populating the fields the user intends to modify
with the information you already have?
Alex T
On 6/17/06, Grae Wolfe - PHP [EMAIL PROTECTED] wrote:
Good day!
I have been working on this little free project for a while, and now
I
have
is if there is a way to join the letters together
instead of having 6 different images displayed.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
/;
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
list as I'm not sure
whether this is something that I'd need to do with the php or mysql.
Basically, I am making an add-on to my small website which is a mini online
game. Every user will have gold, and every 30mins I'd like their amount of
gold to go up by 1 (or say a variable say $goldupdateamount
'];
$fname = $row['first_name'];
$lname = $row['last_name'];
$option_block .= option value=\$id\$lname, $fname/option;
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
the DB create an auto-incrementing ID
number. Hmmm...
Thanks!!
Brad Bonkoski [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Grae Wolfe - PHP wrote:
Good Day!
I am trying to use my limited knowledge to create a VERY simple process
to display some of the information in my table
Again, my many thanks - I didn't know about the 'explode' function - that
may be a huge help.
Hopefully, I am on the right track now... thanks!
Brad Bonkoski [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Grae Wolfe - PHP wrote:
Thank you Brad - That is what I was looking
');
mysql_query($query);
mysql_close();
}
Is there any way to create a loop to check all three instead of me
repeating this code twice more changing $suggested_category_1 to _2 and
_3 ?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
replacing references to the
$suggested_category_1 var with $val
}
Incidentally, I do hope that code was simplified for brevity. There
should be extensive use of mysql_real_escape_string in there.
-Stut
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
= = =
Hello, all. I don't know if this is a php-mysql question or just a
mysql, but here goes:
I have a list of DVDs that my library loans out, and I'd like to allow
people to add comments to each item. Since this list gets regenerated
periodically (it's extracted from another system
guessing
it's not going to really be feasible for you to do this... not easily at least.
-TG
= = = Original message = = =
Hi all,
I am developing the site using php and mysql. I have to add the url at
google site through php code.
If any one have idea about it, please help me.
Regards
Manoj
\, \$registration_comments\, \$today\)
;
$result = @mysql_query($sql,$connection) or die(Couldn't Execute Query.);
===--- END SNIPPET ---===
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
.. in this case, it would
simplify your PHP SQL statement by removing the necessity to escape all the
double quotes \
If you echo the SQL and it looks ok, try running it manually through mysql's
command line or via a program like WinSQL Lite on Windows to try to isolate if
it's the query or your
Does any one know how to send a file attachment using PHP?
I have been using the mail() command to send e-mail in various scripts,
but have spotted a file attachment syntax to use on the php web page.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
How do I change the auto_increment / auto_index value? Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am using mySQL
On Mon, 2006-05-01 at 13:21 +, replies-lists-
[EMAIL PROTECTED] wrote:
Original Message
Date: Monday, May 01, 2006 09:14:36 AM -0400
From: Ron Piggott (PHP) [EMAIL PROTECTED]
Subject: [PHP-DB] auto_increment
How do I change
--- containing the
component reference number from the component table (described above)
and also the member reference number.
Essentially if you are logged in your reference number is in a session
variable and using PHP mySQL the script is checking to see which
components to allow you access
Is there a command in PHP that is equal to the search replace function
in a word processor?
If I want to search for 'this' and replace it with 'that' what would the
syntax be?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I am wondering if
form method=POST
causes the
session_id();
to change or be reset.
Some how my $_SESSION[''] variables are dumping when I use the POST
command above.
More importantly I am not sure what to do about it.
Any ideas?
Ron
--
PHP Database Mailing List (http://www.php.net
The other response is half correct.. I havn't seen anything to read data from
Excel with PHP (although it's technically possible, just kind of complicated)
so the easiest solution is to use Excel and just have it load the file and save
it in CSV format.
The part that's not entirely correct
Is there a way to unescape a string once the command
mysql_real_escape_string($variable);
has been used on it? (This is to display it to the screen, instead of
sending it to the database.)
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net
Is there a way to re-name a table once you have created it? Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
went through:
PHP Version: 5.1.2
Apache Version: 2.0.55
MySQL Version: 5.0.18
Windows XP Pro
1. launch the go-pear batch file
2. select system-wide installation
3. use default install directories: (Seems fine to me since PHP is installed
into C:\PHP)
Installation Base ($prefix) C:\PHP
.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
whatsoever.
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I wonder if someone would tell me the command in PHP that allows me to
write to a file --- for example test.txt Just for this example I
would like the word apple to be the contents of test.txt
Now if I want to re-create test.txt --- erasing all the contents and
start over and this time have
Is there a command within PHP that would convert numbers to words:
echo 1;
# 1 appears on screen
echo command('1');
# one appears on screen --- what would the command be?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I did some searching and found the function on the PHP web site. Ron
?
/**
* convert long integer into American English words.
* e.g. -12345 - minus twelve thousand forty-five
* Handles negative and positive integers
* on range -Long.MAX_VALUE .. Long.MAX_VALUE;
* It cannot handle Long.MIN_VALUE
Or you can have a page which detects resolution by javascript and redirects
to another PHP page with the resolution data
On 2/4/06, Bastien Koert [EMAIL PROTECTED] wrote:
As the other poster mentioned you need JS to detect the screen
widththe
usual approach is to use js to detect
did you turn on display_errors and set error reporting to E_ALL in php.ini?
if not you should
On 1/20/06, Allen Schultz [EMAIL PROTECTED] wrote:
Sorry, I was in a rush to work guys.
All these were downloaded pre-compliled for Win32.
Apache 2.0.55
PHP 5.1.1 w/php_mysqli.dll (improved mysql
INTO query is issued?
Thanks.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
That is the function I was looking for. Thanks. Ron
On Sat, 2006-01-21 at 23:47 -0500, [EMAIL PROTECTED] wrote:
Try:
?php
mysql_query(INSERT INTO table VALUES ('$variable_1', '$variable_2'););
$auto_increment_variable = mysql_insert_id();
?
-TG
= = = Original message
for my web site using mySQL and a cron.
The select statement I quoted above is part of the cron.)
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Is there a way I may find out how many characters
$variable
is long after it has been submitted through a web form?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
earlier is a day before. Thanks. Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
H:i:s, mktime($hour, $minute - 90, $second, $month, $day,
$year));
It will even adjust for leap years I believe. You can add/subtract/etc any of
those items and it's smart enough to figure out what the correct resulting
date/time would be.
-TG
= = = Original message = = =
?php
echo date(Y-m
was performed. I remember doing it
manually, not even through PHP, using absolutely no math functions, just a
totally straight:
UPDATE SomeTable SET AmtOwed = 10.74
Someone made a recommendation of never use SOMETYPE for money.. you should use
SOMEOTHERTYPE instead.
I've spent the better part
.
It's for a PHP site using MySQL. I am considering having the slogans in a
database this time rather than just a text file.
J
Julien Bonastre [EMAIL PROTECTED] wrote:
Yes I can help you there..
There is a technique you can use which is actually more browser
friendly
I am wondering if I may delete a file by FTPing within PHP.
I found the followed on the PHP web site:
fopen(ftp://user:[EMAIL PROTECTED]/somefile.txt, w);
Is there a way for me to delete somefile.txt ?
The FTP program on my computer gives the command
DELE /path/somefile.txt
Is there a way
. You can
also add ASC or DESC for Ascending or Dscending as desired.
N.B. the ORDER BY statement must be the last part of you query!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 17 January 2006 16:42
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL date
, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
What? Nobody said This has nothing to do with PHP and databases? Sheesh...
someone must be sleeping. :) Ok, so it sorta does relate..
But yeah... no2br() will do it for you. Textarea input types DO send a newline
and/or carriage return (didn't test and might be system specific), so if you
Hi,
just to tell you scrolling text boxes are javascript, PHP is server side not
client side, PHP can only get the data from the table and javascript will
display it
On 12/22/05, Alex Major [EMAIL PROTECTED] wrote:
Hi there.
I'm trying to make a scrolling news box for my website. Basically I
this?
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
, but I have three date fields to
modify and it would be easier to do it in PHP
Any pointers would be appreciated.
Mark Bomgardner
Technology Specialist
KLETC
___
Sent by ePrompter, the premier email notification software.
Free download
This isn't really a MySQL error (sorta), it's a PHP error. You probably forgot
to update a variable name when you updated everything else.
Here's an example sequence for querying using PHP/MySQL:
$TestQY = SELECT * from SomeTable;
$TestRS = mysql_query($TestQY) or die(Error executing query
artist, so I want get rid off
that duplicate. any help
___
Sent by ePrompter, the premier email notification software.
Free download at http://www.ePrompter.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
I have specified a directory for the session files to be stored in. But
by doing so the garbage collection function isn't automatically deleting
them. Is there a way I can do so --- Either with a cron or something
like this? Ron
--
PHP Database Mailing List (http://www.php.net
;
$response_created_by = mysql_result($result,$i,response_created_by);
My ideal is that if users 1, 2, 4 5 are in dialogue with each other
the above SELECT $query will only give the results of their identity
once with the mysql_request() function
Thanks for your help.
Ron
--
PHP Database Mailing List (http
button which closes the
session off.
Ron
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
1 - 100 of 179 matches
Mail list logo