kevin myers wrote:
well right after you insert it you can pull it right back out again, or
i think you can do :
$query = insert into logs values
((nextval('public.logs_log_id_seq'::text) as
$log_id),$id,'$logtext','now','$_SERVER[PHP_AUTH_USER]');;
and then use it that way, or maybe you can do
Hi all
I'm new with php.
I need connect with my db in oracle7.3.3, and doing it:
?php
putenv(ORACLE_SID=my_sid);
putenv(ORACLE_HOME=my_path_home);
$handle = ora_plogon(user, ssword)or die;
$cursor = ora_open($handle);
ora_commitoff($handle);
$query = insert into my_tab values ( )...;
Are you sure you give access to this user from the machine to the database
server? Check IP address permissions and if the user has access to the
specific table and/or database in MySQL. Also check to make sure the
database server is setup to allow you access from your machine.. check the
MySQL
Hi,
I have this problem retrieving data from a mssql table with PHP.
I have this in my mssql table column:
Globe and Mail data are retrieved and processed for CustomSearch.
On the R30, the crontab entry:
0 4 * * 1-6 /usr1/applic/ntgm/ntgm_get.pl
will run the Perl script at 4 a.m. everyday to
- Original Message -
From: Roger 'Rocky' Vetterberg [EMAIL PROTECTED]
To: kevin myers [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 4:52 AM
Subject: Re: [PHP-DB] getting serial in PHP
[snip]
From: Roger 'Rocky' Vetterberg [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Are there any scripts out there, in PHP or ASP, that give similar support
in Microsoft SQL Server (MSSQL) that phpMyAdmin gives for MySQL databases?
I have a client who is requiring me to code in ASP using MSSQL server, and
I'd like to have a web-based (preferably in PHP) admin tool for the
For any who may be interested:
I fixed the problem, noted below, myself. Evidently the Slackware
PHP/Apache binary is somewhat broken. It worked after I rebuilt PHP with
configure --with-axps --with-pgsql
Apache did not require a rebuild.
dwb
-Original Message-
From: Dave Brunberg
Make sure that u had installed Oracle Client on your Machine and Recompile your php
with --with-oracle=$ORACLE_HOME then
check wether your Apache included -lpthread
-Original Message-
From: Marcial Comern Mario [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Mon, 31 Mar 2003 07:57:38 -0600
Nathaniel Price wrote:
- Original Message -
From: Roger 'Rocky' Vetterberg [EMAIL PROTECTED]
To: kevin myers [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, March 31, 2003 4:52 AM
Subject: Re: [PHP-DB] getting serial in PHP
*snip*
What I do, when I need to reference an ID from a
Hi,
I'm trying to using a news script and improve somes with a query.
$req = MYSQL_QUERY(SELECT * FROM $TBL_NEWS);
$res = MYSQL_NUM_ROWS($req);
?
table border=0 width=400 cellspacing=0 cellpadding=0
tr
td
img src=img/titre_calendrier.gif alt= width=404 height=51
border=0
?
-Original Message-
From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 9:13 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] MSSQL/PHP problem
[snip]
WHen I retrieve this data from php to display on my webpage I
get this:
Globe and Mail data
Yeah it worked, thank you very much. I just have one more question.
How much space does the data takes up if I set it to text. Because in
VarChar (which I had before) will change it's size depending how long the
chars is, will changing it to text cause the data to take up a large amount
of
Hi,
I am creating a database for a web application. The idea for the application
is for a company administrator to be able to log into the site and allocate
staff to a project.
Staff will be able to log in and update the status of the project they are
working on and clients will be able to log
Maybe mssql_connect()??
www.php.net/mssql_connect
The documentation indicates using sybase_connect (etc...) unless you
are on a windows machine.
But that doesn't work either as the sybase.so file seems to be
non-existant (on my machine anyway)
Regards
Greg Cirino
John W. Holmes [EMAIL
Hi,
I havea question about printing.When the table in HTML page is too big and I print the
page,part of the table got truncated.Is there a way to print the web page without
truncation?
Thanks in advance.
Dan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
I am trying to build an array from the results of a query on a mySQL
table.
I am using a loop to create this string in a variable $mystring:
'30'=true, '20'=true
I then need to use it like this:
$defaultValues['ib_article'] = array($mystring);
It isn't working. I am sure there is a better
Instead of building a string in your loop do the assignment in the loop
I have no idea what is being pulled from where, so I can't really give a
good example
-Original Message-
From: Charles Kline [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 1:25 PM
To: [EMAIL PROTECTED]
Here is more details. Thanks for the reply.
I am using HTML_QuickForm (pear) to create my forms. In order to set
the default state of some of the elements (checkboxes in this case) I
need to pass an array as the value to QuickForm.
This array needs to be in the format of this:
Dan,
It is more of a HTML-related question:
Need to change the table width in percentage (%) rather than just numbers.
HTH,
-rob
Dan Liu [EMAIL PROTECTED]
03/31/2003 01:17 PM
To: [EMAIL PROTECTED]
cc:
Subject:[PHP-DB] print table truncated
Hi,
I
$mystring;
foreach ($sth_opt as $thekey = $thevalue){
$mystring .= '.$thevalue.'=true, ;
}
$defaultValues['ib_article'] = array($mystring);
Try this ...
foreach ($sth_opt as $thekey = $thevalue){
$defaultValues['ib_article'][$thevalue] = 'true';
}
I'm not sure if the indices
Hmm... that is not quite it. Here is a better example:
Here is how I would define default values for a checkbox in
HTML_QuickForm;
$defaultValues['ichkABC'] = array('A'=true,'B'=true);
$form-setDefaults($defaultValues);
The checkboxes are defined later like this:
$checkbox[] =
hi all, i am changing the title are reposting - i have a clearer idea
now of what i am trying to do...
what is the syntax to initialize an associative array with values
returned in a query where the key in the array is coming from the query
and the value is static value of true?
i want to
Hi,
I am trying to get PHP mail() to do the following:
1) Grab email addresses from a database and put in the
BCC of the email. (hidding their email address)
2) Grab first names from a database and put in the
body of the email.
Below is a script I am using, does not do any queries
to any
mail() will not run queries, you need to look at the php manual for the set
of functions for the database type you plan on using and execute the
database stuff in your script and pass the formatted results in the
appropriate argument of the mail function.
ie
$con = mysql_connect($host,
Can this fucktion be use to mail the submited content of a form? If so how?
Thanks for your time,
Mike Delorme
Hey. I just figured it out! So simple too :)
$myarray = array();
foreach ($sth_opt as $thekey = $thevalue){
$myarray[$thevalue] = true;
}
On Monday, March 31, 2003, at 06:05 PM, Charles Kline wrote:
hi all, i am changing the title are reposting - i have a clearer idea
now of what i am
This is not so much a database question. The answer is yes, it can be. You
can read the documentation to find out how.
http://www.php.net/manual/en/function.mail.php
A quick example is:
?php
$body = '';
foreach ($_POST as $key= $val){
$body .= $key = $val\n;
}
mail ($address, Form
How would I modify the code below to handle an UPDATE?
On Sunday, March 30, 2003, at 07:19 PM, Charles Kline wrote:
then I built the INSERT like so:
foreach($article_keys as $articleid)
{
$insert[] = ('$v_ib_id','$articleid');
}
$article_sql = INSERT INTO tbl_ib_articles (issue_brief,article)
Does anyone know how to take a variable containing POST data from a form
and use this value in another PHP file? I need to take a username from
one PHP file and use it in a couple of other PHP files later when adding
to a database.
Thank you,
Alexa Kirk
Everything looks okay with this when I echo the sql string:
INSERT INTO tbl_ib_articles (issue_brief,article) VALUES
('24','30'),('24','20'),('24','31')
My question was, what do I need to change to make this an UPDATE?
Thanks,
Charles
On Monday, March 31, 2003, at 08:30 PM, [EMAIL PROTECTED]
You could set a cookie containing the value on the first page and access it
on the others.
-Original Message-
From: Alexa Kirk [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2003 6:35 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [PHP-DB] Sharing variable values among
Hello,
Can anyone recommend a pure php solution for thumbnail image creation and
photo gallery script? Everywhere I look the scripts require either GD,
NetPBM
or ImageMagick. Is it not possible to build an thumbnail app without these
tools?
Thank you for any help...
Larentium
--
PHP
What kind of data do you need to collect at each booking?
Shaun [EMAIL PROTECTED] escribió en el mensaje
news:[EMAIL PROTECTED]
Hi,
I am creating a database for a web application. The idea for the
application
is for a company administrator to be able to log into the site and
allocate
staff
You can't perform update like this.
You should loop through rows you want to update if they have different key
values.
UPDATE tbl_ib_articles SET col_name=new_value WHERE key_column=key_value;
You can change the condition part, which can include non-key columns,
HTH,
Mustafa
- Original
On Tuesday 01 April 2003 11:20, Keith Spiller wrote:
Can anyone recommend a pure php solution for thumbnail image creation and
photo gallery script? Everywhere I look the scripts require either GD,
NetPBM
or ImageMagick. Is it not possible to build an thumbnail app without these
tools?
In
You can store the value in a session variable
session_start();
if (isset($_HTTP_SESSION_VARS['your_variable_name'])) {
$value=$_HTTP_SESSION_VARS['your_variable_name']; //get the value
}else{
$_HTTP_SESSION_VARS['your_variable_name']=new value;
}
You can use this script to pass values between
Hi All
Has anyone upgraded from PHP Home Edition 2.2.3 (from sourceforge.net) to
version 2.2.8 ? and if so were there any issues?
Steve Dodkins
_
IMPORTANT NOTICE This email (including any attachments)
is meant only for the intended recipient. It may also contain
Hi Ben
Comments inline
On 31 Mar,2003 at 13:46 Benjamin Trépanier wrote:
snip
border=0
?
$i!=$id_news_
$id= mysql_result($req,$i,id);
$titre = mysql_result($req,$i,titre);
$date = mysql_result($req,$i,date);
$heure = mysql_result($req,$i,heure);
Check out mysql manual, section 6.3.4 - Date and Time Functions, example
$condition='';
if($GET['week']) $condition .= WEEK(date)='$_GET[week]' AND ;
if($GET['year']) $condition .= YEAR(date)='$_GET[week]' AND ;
and so on
then use the condition:
$sql = SELECT * FROM news WHERE $condition 1;
39 matches
Mail list logo