The easiest way to do this is to use phpMyAdmin.
Go to the mysql database on your server
Insert a record into the table called 'user'
* enter appropriate value for host (localhost or %)
* fill in user name
* when entering password, select the PASSWORD function
from the pulldown and enter the p
One problem is that you are only checking the first booking.
select * from booking where room='room'
gives ALL bookings, and you look like you are just testing
the FIRST one.
why not turn it round and do:
select * from booking where
('$start'>=startdate and '$start'<=enddate) or
('$en
aranteed safe, as you can end up
with double bookings in the pico seconds between the select
and the insert - but hey, how many hits a second do you expect.
Regards
Jeff's Granny
-Original Message-----
From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 20, 2001 5:08
I agree with Phill, don't make all your HTML into PHP
unless you aint got much - but hey if you aint got much then
you can fix the real problem!
soapbox: {
The issue here seems to derive from the fact that all
the internal HREFs point to xxx.html
This is exactly why http://www.w3.org recommen
Matt,
> put two sets of data in the same while loop...
If there is some logical relationship between the sets of
records then consider adding a join:
$sql = "select club_full_name,message,messate_title "
" from clubs,noticeboard "
" where clubs.club_name = noticeboard.club_na
Apologies for the long post.
I use this approach: (simplified) at the top of every page,
before any HTML. Pop it into an include right at the top.
I have not included all the util function e.g. LogQuietAlert()
regards
Jeff
");
gotoPage("/login");
}
}
#===
curious of Hither Green writes:
> printf("(DELETE)",
$PHP_SELF, $myrow["id"]);
Is there a reason why you're not using interpolation?
This looks simpler to me, and I thought that a lot of effort
went into optimising PHP interpolation.
echo "Delete $myrow[id]";
cheers,
Jeff
-Original M
Why not just set the session start time in a session variable
and then test against that? Something like:
session_start();
# This array contains all the session items
if (!isset($sesh)) {
$sesh = array();
session_register('sesh');
$sesh[start] = time();
}
if ( $PHP_SELF == '/login') {
if
You have a hidden issue with the extra trailing comma.
When I want a list of things, I prefer this approach:
$db = mysql_select_db("tkenet_db");
$query = "SELECT app_name,status FROM approval_list where doc_no='6'";
$result = mysql_query($query,$db);
$ccs=array();
while( $data = mysql_fetch_row(
Jon, not sure if I agree with you:
locking - almost always a bad idea, atomicity is
much faster and safer and usually indicates a better
relational design. SQL is fundamentally set oriented,
but newbies are almost always row oriented.
mySQL locks table automagically, but it doesn't do ro
: Jeff Armstrong
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] files with html extension
Jeff Armstrong wrote:
> This is exactly why http://www.w3.org recommend that you DONT
> SPECIFY A FILE TYPE TYPE in your HREFs.
But doth that actually work - how many web servers are able to handle this
t
Instead of using a HIDDEN form field (I assume you don't
use this in any client side javascript), why not just use
a session variable. Add this to the top of the relevant
pages using include:
You can then use $sesh[url] in any php block to find
what this value was set to on the first page.
Reg
I have tried you code and cannot see any real problem?
This is what I see happening:
1 one.php creates a session and sets the value of $a to 'a'
2 click on 2 and you get to two.php with the value set to 'a'
3 click on OFF and you get to off.php where the value is unset
4 click back and y
Not sure what you are trying to do?
Not sure what a Persal is (maybe an Arial?)
Perhaps you want:
select
E.empname
from employer E, badclient B
where E.employercode = B.employercode
and E.pesal='$Persal'
Note there are two tables given aliases of E and B
that are JOINED by the first c
Do it in MySQL = Fast
Don't fiddle in PHP = waste of your time.
Look into the following:
select
UNIX_TIMESTAMP(date1)-UNIX_TIMESTAMP(date1) as diff_secs,
TO_DAYS(date1)-TO_DAYS(date1) as diff_days,
PERIOD_DIFF(date1,date2)as diff_months,
YEAR(dat
how about something like
select distinct
name,
date_format(time, "%W %D %M %Y") as login
from
users, user_logins
where
user_logins.user_id = users.id
order by name,time
-Original Message-
From: Jordan Elver [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 20
PHP appears to no longer be logging errors:
My php.ini is unchanged:
error_reporting = E_ALL
display_errors = On
display_startup_errors = On
log_errors = On
error_log = /var/log/apache/php.log
Over the last few days, whenever I had a syntax error in my scripts,
I was getting segmentat
Little Bo jeff has lost his logs,
and doesn't know where to find them!
Fix up the conf
and they will come home
dragging their hints behind them!
I moved some php config values into httpd.conf so that I could
manage my virtual sites better (e.g. phpMyAdmin needs globals)
and assumed that
18 matches
Mail list logo
