I don't know Postgresql, but all databases I've dealt with increments
auto-increment fields only on committing insert commands. I think you can
catch the last id number (MySQL do it) and show the number + 1 on the user
screen.
HTH
Jayme.
-Mensagem Original-
De: Julio Cuz, Jr. [EMAIL
You've misplaced a "$date" variable instead of $datum, $date has no value .
HTH
Jayme.
-Mensagem Original-
De: Florian Poppele [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: domingo, 25 de maro de 2001 10:26
Assunto: [PHP-DB] problem with writing date/time into db
Just
Look for "AddType application/x-httpd-php4" on your Apache configuration
file and add the types you want PHP4 be responsible for.
Here are my own :
AddType application/x-httpd-php4 .php
AddType application/x-httpd-php4 .php3
AddType application/x-httpd-php4 .html
HTH
Jayme.
Remember it only works on PHP4.0 !
HTH.
Jayme.
-Mensagem Original-
De: olinux [EMAIL PROTECTED]
Para: PHP-DB [EMAIL PROTECTED]
Enviada em: sexta-feira, 23 de maro de 2001 23:38
Assunto: Re: [PHP-DB] comparison table script
Cool!
Just came across this, looks like PHP will make life
Use persistent connections it's a matter of performance of your script.
When you use persistent connections the next call to mysql_pconnect will
catch a opened connection if available. The mysql_connect command always
open a new connection which slower than get an opened one. Anyway you can't
use
A good advice is put an error checker after every mysql command, this way
you can track errors :
?php file://view jobs script
include("../includes/connect.inc.php"); file://connect to the
database
$query = "SELECT m_sender, m_date, m_subject FROM messages WHERE m_id =
'$m_id'";
I don't know if you need a special class to send an email, the php mail
function do this in a way you can read it on every browser or email program
.
HTH
Jayme.
-Mensagem Original-
De: Xsarus Internetdiensten [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: sexta-feira, 23 de maro
Congratulations !! Very good solution ! Simple and efficient !
Cheers,
Jayme.
-Mensagem Original-
De: Michael Rudel [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]; 'PHP-DB mailinglist' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Enviada em: sexta-feira, 23 de maro de 2001 08:29
Assunto: RE:
As you can only navigate record by record through the database table I think
the only way, as far as I know, is to store the record values into array
variables and print it to the page after you'd reached the last record.
HTH
Jayme.
-Mensagem Original-
De: olinux [EMAIL PROTECTED]
this-field = $row['$this-field'];
}
}
else $this-error = mysql_error();
return;
}
HTH
Jayme.
www.conex.com.br/jjeffman/antispam.html
-Mensagem Original-
De: bryan [EMAIL PROTECTED]
Para: db [EMAIL PROTECTED]
Enviada em: tera-feira, 20 de maro de 2001 16:21
Assunto
If you are using MySQL you can use the "mysql_list_fields" to get the fields
names from a table.
HTH
Jayme.
-Mensagem Original-
De: Martin E. Koss [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 20 de maro de 2001 12:02
Assunto: [PHP-DB] Dynamically build a form from
Have a look on Sessions. You can also write to a database every time a new
visitor runs into your site and check if the other are still connected.
You have to create a script that tracks every movement of the visitor. It is
not a simple script. As far as I know the web server doesn't give you
Try the "empty($variable)" function.
HTH
Jayme.
-Mensagem Original-
De: Michael Gerholdt [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: sbado, 17 de maro de 2001 23:12
Assunto: [PHP-DB] if () and () - newbie Q
Why won't this work for me?
if (($rectype == 'events') and
Use mysql_function(...) or die( mysql_error()) on every mysql function
or command you're performing, this will tell you what is going wrong .
HTH
Jayme.
-Mensagem Original-
De: [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Enviada em: quarta-feira, 14 de maro de
If the tables have a one to many relationship you can use nested while
loops:
while(1st loop){
// display header - master table
while(2nd loop){
// display features - detail table
}
}
HTH
Jayme.
-Mensagem Original-
De: olinux [EMAIL PROTECTED]
Para: PHP-DB
If you have a way to decide which checkboxes have to be checked, just set
its attribute like the line bellow:
INPUT TYPE="checkbox" NAME="" ?PHP if($condition) echo("CHECKED");?
HTH
Jayme.
-Mensagem Original-
De: jester [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em:
I'm not sure but I think you must have a smtp server program running to
configure as your smtp server.
HTH.
Jayme.
-Mensagem Original-
De: Free Beachler [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: quarta-feira, 7 de maro de 2001 14:48
Assunto: [PHP-DB] mail server
hi all,
Try this changes:
$con_id = mysql_connect("localhost", "myusername", "mypassword");
if($con_id){
mysql_db_query("DocCountry", "INSERT INTO projects (idCreator, name,
comment) VALUES (0, 'sysmsg9.txt', 'Some file')");
mysql_db_query("DocCountry", "INSERT INTO files (idProject, name,
I've never used but there is a php function "get_browser()" which might do
the work.
I think the best way is set the cookie and try to get it again, if you can
get it the user has cookies enabled.
setcookie("name",value,$cookieLifeTime,$cookiePath);
if($name) echo("Cookie is enabled");
HTH
You must use a loop to show each row of your query.
"mysql_fetch_array($result)" only get the current row.
while($row = mysql_fetch_array($result) ){
// do something
}
The "mysql_fetch_array" function returns an associative array where you can
use the field names to have access to its
Have you put an echo with mysql_error() after performing each query ?
Jayme.
-Mensagem Original-
De: Chris [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: segunda-feira, 5 de maro de 2001 05:04
Assunto: [PHP-DB] MySQL - Problem with multiple INSERTs?
Howdy,
I'm getting weird
Look for "load in file" on MySQL manual.
HTH.
Jayme.
-Mensagem Original-
De: Pedro M. S. Oliveira [EMAIL PROTECTED]
Para: PHP db [EMAIL PROTECTED]
Enviada em: sbado, 3 de maro de 2001 18:03
Assunto: [PHP-DB] Insert a file in a mysql database!
Hi all...
Here i am once again asking
Use the "selected" attribute of the option tag when you load the second
page, marking the place the user had chosen :
option .
option ...
option selected value="g"City G
option...
HTH
Jayme.
-Mensagem Original-
De: Dave Carrera [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada
David Siegel in "Creating Killer Web Sites" 1st edition said frames are good
only for show details of a list of objects like recipes, products or in your
case news!
You can have a frameset with three frames say top, left and main (center).
Put some ad on the top , the headlines of your news on
The event "OnChange" only happens when the user open the drop down list and
change ( select ) a new value, this is not "just looking" .
I don't like this kind of solution. If I have to put a button on the page I
think the selection list must disappear. Why not give the user a interface
with less
Are you trying to tell Rudi Ahlers is possible to call php scripts from a
browse event ? The statement "form.submit()" belongs to JavaScript not to
php.
Can you imagine how boring is have to submit forms and reload pages every
time the user make changes on a drop down menu?
I know you're right
Remember, php is server side while JavaScript is client side. You can't use
php client side. You can use some client side events to call php scripts
which will run on the server and send data to the browser. Events are client
side, so try JavaScript you'll enjoy it too.
HTH
Jayme.
-Mensagem
Look for "nl2br()" on the php manual. There is more information there.
Any way you can store text fields as the user has typed it in, when you are
about to show them what they wrote you get text from database and apply the
function on the result before put it in a html tag.
select * ...
...
urrent = $row["field"] ;
// for next row
$query = "select * from table where field_name '$current' limit 1";
// for previous row
$query = "select * from table where field_name '$current' limit 1";
HTH
Jayme.
www.conex.com.br/jjeffman/antispam.html
-Mensagem Or
As far as I know, if you do not set any special order, the table is ordered
by primary key, isn't it ?
Jayme.
-Mensagem Original-
De: Chris Book [EMAIL PROTECTED]
Para: JJeffman [EMAIL PROTECTED]; Adv. Systems Design
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Enviada em: quarta-feira, 21 de
, you wrote:
Perhaps it is ordered that way, perhaps not, but live by the creed
"Expect
nothing and you will never be disappointed."
Go ahead and specify the order you demand.
-Original Message-
From: JJeffman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February
"SELECT * FROM Table WHERE Rec_id $recid LIMIT 1" always bring you the
next record no matter the Rec_id is.
HTH
Jayme.
-Mensagem Original-
De: Adv. Systems Design [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: tera-feira, 20 de fevereiro de 2001 11:41
Assunto: [PHP-DB]
I've already made an object which had a property that was an array. Now I
need to have an array that can hold objects as its elements is It possible ?
I didn't get it the expression array[$i]-Object gave me syntax error. Any
tips ?
[]'s
Jayme.
http://www.conex.com.br/jjeffman
--
PHP
You need mix JavaScript and PHP. Write an "OnChange" event handler for the
"campus" selection list and fill up the "buildings" drop-down menu in two
ways:
1) If the amount of data is not very large you can get all data needed to
run
the "application" client side, load the data into JavaScript
MySQL do support composite keys . Have a look on the mysql database
structure the "columns_priv" table has 5 fields in its primary key.
I think you should use an auto_increment as your primary field instead.
HTH.
Jayme.
-Mensagem Original-
De: Russ Michell [EMAIL PROTECTED]
Para:
Try use a delimited string and split it on retrieve.
HTH.
Jayme.
-Mensagem Original-
De: Kyle Mathews [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: segunda-feira, 19 de fevereiro de 2001 19:35
Assunto: [PHP-DB] Inserting arrays into a database
Hello:
I'm wondering what is
You can pass the "href" as an urlencoded to your php script.
HTH.
Jayme.
-Mensagem Original-
De: Sridhar Ranganathan [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: sbado, 17 de fevereiro de 2001 21:40
Assunto: [PHP-DB] Links On The Fly
Hi All
I have a search engine which
Using a JavaScript function instead of the "action" form property I think is
possible .
HTH.
Jayme.
-Mensagem Original-
De: Marc Bragg [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: sexta-feira, 16 de fevereiro de 2001 17:53
Assunto: [PHP-DB] double "posts"
Is it possible to
No it hasn't. The field order in the form doesn't matter, but the order you
use their values in the query yes !
I don't know what kind of operation you're making on the database
updating, inserting, etc. ).
If you are inserting you must not give any member_id, as long as it is
generated by the
How about use "A TARGET='main' HREF=\"" ...
HTH
JAYME.
-Mensagem Original-
De: John Halladay [EMAIL PROTECTED]
Para: PHP DB List (E-mail) [EMAIL PROTECTED]
Enviada em: quinta-feira, 15 de fevereiro de 2001 19:46
Assunto: [PHP-DB] Related frames
I'm trying to have a link in one frame
-increment fields should not be exposed to the user.
HTH.
Jayme.
http://www.conex.com.br/jjeffman
--
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]
I think write to the user's machine it's up to him, you can't write to it,
you have to "invite" the user to download the file you created for him on
the server. That's the polished application !
HTH.
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Gar
What for you need a ID if you have already the username which I guess may a
unique key ?
HTH.
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Brandon Feldhahn [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: segunda-feira, 5 de fevereiro de 2001 22:00
Assunto
JavaScript arrays and
refresh the select boxes using JavaScript scripts. Otherwise you must reload
the page and process the values posted by the form.
HTH.
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Kepa Lyman [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: quarta-fe
row number returned :
// Check if a valid result has records
if(mysql_num_rows($result) 0){
// stuff
}
else{
// No records procedure
}
HTH
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Kevin Connolly [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviada em: sexta-fei
There is the "nl2br()" function too :
// From php manual :
nl2br -- Converts new lines to HTML line breaks.
Description
string nl2br(string string);
Returns string with 'BR' inserted before all new lines.
HTH
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Origin
The last time I sent a message to php-list-admin asking for stop this kind
of messages they took the email address off but I was fired of the list too.
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Jon Niola [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]; [EMAIL
H
Jayme.
http://www.conex.com.br/jjeffman
-Mensagem Original-
De: Rubanowicz, Lisa [EMAIL PROTECTED]
Para: Rubanowicz, Lisa [EMAIL PROTECTED]; [EMAIL PROTECTED]
Enviada em: tera-feira, 23 de janeiro de 2001 11:54
Assunto: RE: [PHP-DB] Newbie - 2 tables one insert
I realised I just sent
I am running PHP3.017(cgi) + Apache + MySQL on Windows98 SE.
The include() and the getenv() functions are asking for a dial-up
connection. Can somebody give me a hand ?
Jayme.
http://www.conex.com.br/jjeffman
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail
49 matches
Mail list logo
