[PHP-DB] Imap-Connection fails, how do I have to define imap_open
Hi,
I want to connect within a php-Script to my Imapserver at all-inkl.
In my Thunderbird the account-settings are:
Server: w017fd8a.kasserver.com
Port: 993
Connecting-Way: SSL/TLS
Authication-Method: normal Password
this settings are function in the Thunderbird-Client.
But in the testing-scipt for Imap-Access I get an error that the access
to the
All-inkl server fails. Does anyone have experience how I have to the
fine the line
in imap_open?
$mbox=imap_open("{w017fd8a.kasserver.com:993/imap/ssl/novalidate-cert}",
"" ,"");
if(!$mbox)
{
echo "Imap-Zugriff gescheitert"; <-- In Englisch "Imap-Access
fails"
}
//$mbox="INBOX.msf"
echo "Postfächer"; <-- In English Mailboxes
$folders=imap_listmailbox($mbox,"{w017fd8a.kasserver.com:993/imap/ssl/novalidate-cert}","*");
...
imap_close($mbox);
?>
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQLnd support for ed25519
Hi Dimi, I think mysql 8 is the new version of mysql. I don't know if there a exists a stable release or only a beta. My thoughts are that the last php-version maybe can handle the mentioned authentication method or you have to try to compile the handling for the mysql-plugin in the php-mysqldriver. Maybe the question about enhancing the php is relation on the Linuxdistribution. Here I mean an additional rpm if you use Redhat, Fedora, Centos, Suse... or .deb if you use Debian, Ubuntu or such of these. To mix a tarball with one of these packages I think it is to difficult in this case. Regards, Ruprecht Am 08.09.21 um 15:20 schrieb dimi_php: Hi Ruprecht, yes, if a provider not changed the default authentication (mysql_nativ_password) there is nothing customers have to do, because the default authentication on mysql 5.7 and 10.5 is the same (SHA-1 based). Mysql changed this starting from version 8, were the default authentication now is the plugin caching_sha2_password. Mariadb not changed the default, but recommends to use a safer authentication method like the ed25519-plugin. I would like to use it, but then i have the problem that PHP (the Mysql nativ driver) cames with an error like "The server requested authentication method unknown to the client". So i would be glad if this authentication method would be implemented. Regards, Dimi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQLnd support for ed25519
Hi Dimi, hi everyone, I don't know about this algorithm. On one running server and on my local linuxbox there is Mysql running. On another server the provider changed from mysql to mariadb. As reason for the change from mysql 5.7 to mariadb 10.5 the provider only told his customers that mariadb is an enlargement of the database and based on mysql. Nothing told about better security or any more, only that the provider looked forward without problems in the changingprocess. Regards, Ruprecht Am 07.09.21 um 17:04 schrieb dimi_php: Hi everyone, i just wanted to ask if the authentication with ed25519 algorithm with the MySQLnd is maybe possible in the future? I use mariadb which currently not support either the sha256_password or the caching_sha2_password, therefore i have to use the standard mysql_native_password authentication, although i actually want to use the ed25519 authentication-plugin in mariadb. Best regards, Dimi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problems with googlecalender event-insert
Hi I have some problems with the Oauth by inserting a testevent into my
Google-Calender. I changed the script for reading from my calendar a
little bit and was trying the insert.
The old Google-login with email was disabled from Google some time ago
and the only way to use the Api is via Oauth.
I become the following errors running the script from the console.
php /var/www/localhost/htdocs/calendar_insert.php
PHP Fatal error: Uncaught exception 'Google_Auth_Exception' with
message 'Error refreshing the OAuth2 token, message: '{
error : invalid_request,
error_description : Missing required parameter: refresh_token
}'' in /root/vendor/google/apiclient/src/Google/Auth/OAuth2.php:357
Stack trace:
#0 /root/vendor/google/apiclient/src/Google/Auth/OAuth2.php(272):
Google_Auth_OAuth2-refreshTokenRequest(Array)
#1 /root/vendor/google/apiclient/src/Google/Client.php(454):
Google_Auth_OAuth2-refreshToken(NULL)
#2 /var/www/localhost/htdocs/calendar_insert.php(49):
Google_Client-refreshToken(NULL)
#3 /var/www/localhost/htdocs/calendar_insert.php(73): getClient()
#4 {main}
thrown in /root/vendor/google/apiclient/src/Google/Auth/OAuth2.php on
line 357
Fatal error: Uncaught exception 'Google_Auth_Exception' with message
'Error refreshing the OAuth2 token, message: '{
error : invalid_request,
error_description : Missing required parameter: refresh_token
}'' in /root/vendor/google/apiclient/src/Google/Auth/OAuth2.php:357
Stack trace:
#0 /root/vendor/google/apiclient/src/Google/Auth/OAuth2.php(272):
Google_Auth_OAuth2-refreshTokenRequest(Array)
#1 /root/vendor/google/apiclient/src/Google/Client.php(454):
Google_Auth_OAuth2-refreshToken(NULL)
#2 /var/www/localhost/htdocs/calendar_insert.php(49):
Google_Client-refreshToken(NULL)
#3 /var/www/localhost/htdocs/calendar_insert.php(73): getClient()
#4 {main}
thrown in /root/vendor/google/apiclient/src/Google/Auth/OAuth2.php on
line 357
I'm using the Google-php-api-client that works fine in the script for
reading from the calendar. Here the script that should insert a Testevent:
?php
require 'vendor/autoload.php';
define('APPLICATION_NAME', 'owncrminsert');
define('CREDENTIALS_PATH', '
.credentials/.credentials/calendar-api-calenderinsert.json');
define('CLIENT_SECRET_PATH','/var/www/localhost/htdocs/vendor/client_secret_889445840794-01897crinjia9q8q2c4ta02ksd8bsftg.apps.googleusercontent.com.json');
define('SCOPES', implode(' ', array(
Google_Service_Calendar::CALENDAR)
));
/**
* Returns an authorized API client.
* @return Google_Client the authorized client object
*/
function getClient() {
$client = new Google_Client();
$client-setApplicationName(APPLICATION_NAME);
$client-setScopes(SCOPES);
$client-setAuthConfigFile(CLIENT_SECRET_PATH);
$client-setAccessType('offline');
// Load previously authorized credentials from a file.
$credentialsPath = expandHomeDirectory(CREDENTIALS_PATH);
if (file_exists($credentialsPath)) {
$accessToken = file_get_contents($credentialsPath);
} else {
// Request authorization from the user.
$authUrl = $client-createAuthUrl();
printf(Open the following link in your browser:\n%s\n, $authUrl);
print 'Enter verification code: ';
$authCode = trim(fgets(STDIN));
// Exchange authorization code for an access token.
$accessToken = $client-authenticate($authCode);
// Store the credentials to disk.
if(!file_exists(dirname($credentialsPath))) {
mkdir(dirname($credentialsPath), 0700, true);
}
file_put_contents($credentialsPath, $accessToken);
printf(Credentials saved to %s\n, $credentialsPath);
}
$client-setAccessToken($accessToken);
// Refresh the token if it's expired.
if ($client-isAccessTokenExpired()) {
$client-refreshToken($client-getRefreshToken());
file_put_contents($credentialsPath, $client-getAccessToken());
}
return $client;
}
/**
* Expands the home directory alias '~' to the full path.
* @param string $path the path to expand.
* @return string the expanded path.
*/
function expandHomeDirectory($path) {
$homeDirectory = getenv('HOME');
if (empty($homeDirectory)) {
$homeDirectory = getenv(HOMEDRIVE) . getenv(HOMEPATH);
}
return str_replace('~', realpath($homeDirectory), $path);
}
date_default_timezone_set('Europe/Berlin');
// Get the API client and construct the service object.
$client = getClient();
$service = new Google_Service_Calendar();
/*
$event=array(
'summary' = 'Google I/O 2015',
'location' = '800 Howard St., San Francisco, CA 94103',
'description' = 'A chance to hear more about Google\'s developer
products.',
'start' = array(
'dateTime' = '2015-05-28T09:00:00-07:00',
'timeZone' = 'America/Los_Angeles',
),
'end' = array(
'dateTime' = '2015-05-28T17:00:00-07:00',
'timeZone' = 'America/Los_Angeles',
),
'recurrence' = array(
'RRULE:FREQ=DAILY;COUNT=2'
),
'attendees' = array(
array('email' = 'lp...@example.com'),
array('email' = 'sb...@example.com'),
),
Re: [PHP-DB] SQL Injection
On 15.05.2015 07:21, Karl DeSaulniers wrote: On May 14, 2015, at 11:11 PM, Onatawahtaw onatawah...@yahoo.ca wrote: Hi Karl, If you look at the link you provided you'll notice that some of the code is for ASP.net and some is for PHP. I have looked in the link. Most problems by inject an sql-Code is to add something in the where-clause let it end with a semicolon and add an additional sql-command behind the semicolon. In this case you have two SQL-Command. The first maybe a Select-Command and the next can be to drop a whole table with all its content. One thing you can do is to trim the Select-Statement and trough all behind a semicolon in addition the semicolon away. Another securitymethod of mysql that the fieldvarables are capseled by escaping. So mysql get note that this is a variable content for a formfield and should looked like that. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: RES: [PHP-DB] input field validation
YVES SUCAET wrote: Nope, it's not. The problem was formulated as Integer detection. not numerical detection in general. this must be able via preg_match (http://de3.php.net/manual/en/function.preg-match.php) using the regular expression /[1-9]/ possible [0] in addition. Regards, Ruprecht Helms - Ruprecht Helms IT-Service Softwaredevelopment allow your worktools be individual Web: http://www.rheyn.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] problem in recorset that seems temporary
Hi,
I have a problem that confuse me a little bit. When I want to delete a
picture by giving the id-value in the URL I get the following error:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL
result resource in
/opt/lampp/htdocs/pferdeservice_karle/galerie_delete.php on line 81
On clicking the relodebutton on the browser I get no error and the
deletion of the recordset seems to be not executed. When I don't reload
the page and change to view the pictureresults the recordset have been
deleted. But I don't know why I get the warning-message.
Attached the code.
Regards,
Ruprecht
http://www.rheyn.de
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN
http://www.w3.org/TR/html4/loose.dtd;
html
head
title/title
meta name=GENERATOR content=Quanta Plus
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
style type=text/css
a:link { color:#FF;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-weight:bold;text-decoration:none;}
a:visited { color:#CC340A;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-weight:bold;text-decoration:none;}
a:active { color:#FFCC00;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-style:italic; font-weight:bold;text-decoration:none;}
a:hover { color:#FF9900;
font-family:Arial,Helvetica,Verdana,Sans-serif;font-size:9pt;
font-weight:bold;text-decoration:none;}
td { color:#00; font-family:Arial,Helvetica,Verdana,Sans-serif;
font-size:9pt;font-weight:plain;}
h2 { color:#00; font-family:,Helvetica,Verdana,Sans-serif;
font-size:12pt; font-weight:bold;}
h4 { color:#FF; font-family:Arial,Helvetica,Verdana,Sans-serif;
font-size:10pt; line-height:12pt; font-weight:bold;}
h1 {
color:#44;
margin-top:1em;
font-size: 1.4em;
font-weight: bold;
}
body{
text-align:center;
background-color:#F0F0F0;
font-family:Verdana, Geneva, Arial, Helvetica, sans-serif;
font-size:0.78em;
}
/style
body
table
tbody
TR
TD bgcolor=#dd
table height=780 width=200 align=centerTRTD
table width=80% align=center style=border-bottom-color : #ff;
border-left-color : #ff; border-right-color : #ff;
border-spacing : 10px; border-top-color : #ff;
tbody
TR
TD width=200 bgcolor=#f0f0f0h2Bildergalerie/h2
A href=galerie_zeigen.phpGaleriebilder zeigen/A
A href=galerie_add_neu.phpGaleriebild hinzufuuml;gen/Abr
A href=galerie_update.phpGaleriebild aktualisieren/Abr
/TD
/TR
tr
td bgcolor=#f0f0f0h2Quicklinks/h2
A href=springpferde_zeigen.phpSpringpferde/A
A href=dressurpferde_zeigen.phpDressurpferde/Abr
FAQ
/td
/tr
tr
td bgcolor=#f0f0f0h2News/h2
A href=news_zeigen.phpNews zeigen/A/Abr
A href=news_add0.phpNews hinzufuuml;gen/Abr
News bearbeitenbr
News louml;schen
/td
/tr
/tbody
/table
/TD/TR/table
/TD
td valign=top
h1 align=leftGalerie louml;schen/h1
?
mysql_connect(localhost,root);
$result=mysql_db_query(pferdeservice-karle,SELECT * FROM Galerie
WHERE ID=$id);
$zahl = mysql_num_rows($result);
echo Zahl vorhandener Bilder .$zahl;
echo mysql_error();
while($row = mysql_fetch_object($result))
{
$galerie_id=$row-ID;
$result=mysql_db_query(pferdeservice-karle,DELETE FROM
Galerie_kultur WHERE GalerieID=$id);
}
$result=mysql_db_query(pferdeservice-karle,DELETE FROM Galerie WHERE
ID=$id);
echo mysql_error();
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Inserting databasecontent within the same form
Hi Niel,
SELECT Kunden.*, City.name, City.vorwahl FROM Kunden LEFT JOIN City
USING (zipcode)
I'm understanding you this is a way for designing the sql-statement.
My customer want that they have inserted the city after typing in the
zipcode in the zipfield. The city should be searched in a database and
inserted in the field city automaticly.
I think the only way is to do that with some ajax-code combined with a
short phpscript.
Actually I have these codes, but the automatic inserting fails, I don't
know why.
-
ajax.js
function Ajax() {
//Eigenschaften deklarieren und initialisieren
this.url=;
this.params=;
this.method=GET;
this.onSuccess=null;
this.onError=function (msg) {
alert(msg)
}
}
Ajax.prototype.doRequest=function() {
//Üeberpruefen der Angaben
if (!this.url) {
this.onError(Es wurde kein URL angegeben. Der Request wird
abgebrochen.);
return false;
}
if (!this.method) {
this.method=GET;
} else {
this.method=this.method.toUpperCase();
}
//Zugriff auf Klasse für readyStateHandler ermöglichen
var _this = this;
//XMLHttpRequest-Objekt erstellen
var xmlHttpRequest=getXMLHttpRequest();
if (!xmlHttpRequest) {
this.onError(Es konnte kein XMLHttpRequest-Objekt erstellt werden.);
return false;
}
//Fallunterscheidung nach Übertragungsmethode
switch (this.method) {
case GET: xmlHttpRequest.open(this.method,
this.url+?+this.params, true);
xmlHttpRequest.onreadystatechange = readyStateHandler;
xmlHttpRequest.send(null);
break;
case POST: xmlHttpRequest.open(this.method, this.url, true);
xmlHttpRequest.onreadystatechange = readyStateHandler;
xmlHttpRequest.setRequestHeader('Content-Type',
'application/x-www-form-urlencoded');
xmlHttpRequest.send(this.params);
break;
}
//Private Methode zur Verarbeitung der erhaltenen Daten
function readyStateHandler() {
if (xmlHttpRequest.readyState 4) {
return false;
}
if (xmlHttpRequest.status == 200 || xmlHttpRequest.status==304) {
if (_this.onSuccess) {
_this.onSuccess(xmlHttpRequest.responseText,
xmlHttpRequest.responseXML);
}
} else {
if (_this.onError) {
_this.onError([+xmlHttpRequest.status+
+xmlHttpRequest.statusText+] Es trat ein Fehler bei der
Datenbertragung auf.);
}
}
}
}
//Gibt browserunabhängig ein XMLHttpRequest-Objekt zurück
function getXMLHttpRequest()
{
if (window.XMLHttpRequest) {
//XMLHttpRequest für Firefox, Opera, Safari, ...
return new XMLHttpRequest();
} else
if (window.ActiveXObject) {
try {
//XMLHTTP (neu) für Internet Explorer
return new ActiveXObject(Msxml2.XMLHTTP);
} catch(e) {
try {
//XMLHTTP (alt) für Internet Explorer
return new ActiveXObject(Microsoft.XMLHTTP);
} catch (e) {
return null;
}
}
}
return false;
}
-
einfuegen.js
//Instanz der Klasse Ajax erzeugen und mit der Datenübertragung starten
function load()
{
var plz=document.getElementById(plz).value;
with (new Ajax()){
url=ort_suchen.php;
method=POST;
params=plz=+plz;
onSuccess=successHandler;
onError=errorHandler;
doRequest();
}
//Den Text in die Seite einfügen
function successHandler(txt,xml){
document.getElementById(ort).innerHTML=txt;
}
//Fehler
function errorHandler(msg){
document.getElementById(text).innerHTML=msg;
}
}
---
ort_suchen.php
?
include(authentication.php);
$plz = mysql_real_escape_string ( $_POST['plz'],$link);
$ort=;
$result=mysql_db_query($datenbank,SELECT * from Orte WHERE PLZ = '$plz');
while ($row=mysql_fetch_object($result)){
$ort= $row-Bezeichnung;
}
echo $ort;
?
-
in the source-phpscript that do the request I have this
html-header
databaseconnection
...
script type=text/javascript src=ajax.js/script
script type=text/javascript src=einfuegen.js/script
...
some formcode
...
tr
tdPLZ/td
tdINPUT type=text id=plz name=plz onkeyup=load()/td
/tr
tr
tdOrt/td
tdINPUT type=text id=ort name=ort
div id=ortOrt/div
...
Regards,
Ruprecht Helms
Web: http://www.rheyn.de
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Inserting databasecontent within the same form
/table /td td width=33%/td /tr tr tderstellt v.br Ruprecht Helms IT-Service amp; Softwareentwicklungbr Louml;rrach/td td/td td/td /tr /tbody /table Regards, Ruprecht Helms Web: http://www.rheyn.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problems with ereg-Command
Hi,
I have some problems with validating the values of the fields street,
phone and fax. In the field street I want that only the european
standard for writing ( number name or name. number) should be
possible. By other fieldentries the user should be informed of the error
and the proccessing should stop.
In the fields phone and fax it should be able to write (12345) 12345
or to write 12345 / 12345
The checking of the contactperson in german Ansprechpartner is also
incorrect.
if (!ereg([a-zA-Z .0-9],$strasse))
{
echo Unguuml;ltige Werte in Strasse;
exit;
}
if (!ereg([a-zA-Z] \.,$ansprechpartner))
{
echo Unguuml;ltige Werte im Ansprechpartner;
exit;
}
if (ereg([0-9 ()/],$telefon) == false)
{
echo Unguuml;ltige Werte bei Telefon;
exit;
}
if (ereg([0-9 ()/],$fax) == false)
{
echo Unguuml;ltige Werte bei Fax;
exit;
}
What is the code for the correct validating.
Regards,
Ruprecht Helms
---
Ruprecht Helms IT-Service Softwaredevelopement
Web: http://www.rheyn.de
Mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with reading out value from urlline
Hi, I have the problem that a phpscript is not able to read out a value from the browserline. In the browserline I have the URL domain/page?id=value. The id-Value I want to process within the script but a echo $id shows me no value. The Php-Surrounding is very secured. Formfields and variables that schould be part of a mysqldatabase must be escaped by the mysql_real_escape_string-command. What is the right command to get the value from the browserline. Regards, Ruprecht -- Ruprecht Helms IT-Service Softwaredevelopment Web: a href=http://www.rheyn.deRuprecht Helms IT-Service Softwareentwicklung, Loerrach/a -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with rss-feed generation
Hi, I've a problem in creating a xml-file for a dynamic rss-feed. When I try to read the feed in my feedreader RSSowl I get an errormessage that the xml was not formated properly The feed should present boardentries in a short description. Because there are much articles the feed should show that as seperate postings like other feeds do it also. Together with the xml-file I think that someone can give me support how to fix the problem so I can try to read the feed in RSSowl for testing. Regards, Ruprecht --- Ruprecht Helms IT-Service Softwaredevelopment allow your worktools be individual Web: http://www.rheyn.de rss-feed-test3.php Description: application/php xml version=1.0 encoding=ISO-8859-1 !DOCTYPE rss PUBLIC -//Netscape Communications//DTD RSS 0.91//EN http://my.netscape.com/publish/formats/rss-0.91.dtd; rss version=0.91 channel title(RSS 2.0)/title linkhttp://www.xing.com//link descriptionDie neuesten Artikel in Bla-Bereich ; /description languagede/language managingEditorRuprecht Helms [EMAIL PROTECTED]/managingEditor webMasterRuprecht Helms [EMAIL PROTECTED]/webMaster item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; dsklfdsafdsajfasdf lt;brgt;/description descriptiondsklfdsafdsajfasdflt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; Test lt;brgt;/description descriptionTestlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; Testantwort lt;brgt;/description descriptionTestantwortlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; xx lt;brgt;/description descriptionxxlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]Test erneuter Testlt;brgt;/description description]Test erneuter Test lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]Test erneuter 2. Test lt;brgt;/description description]Test erneuter 2. Test lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]Test erneuter 2. Test lt;brgt;/description description]Test erneuter 2. Test lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; dfklödsfadfsjdkjsdafasdj lt;brgt;/description descriptiondfklödsfadfsjdkjsdafasdjlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]dfklödsfadfsjdkjsdafasdj lt;brgt;/description description]dfklödsfadfsjdkjsdafasdj lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]dfklödsfadfsjdkjsdafasdj lt;brgt;/description description]dfklödsfadfsjdkjsdafasdj lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt
Re: [PHP-DB] Problem with rss-feed generation
Niel Archer wrote: Hi the first line is badly formed xml version=1.0 encoding=ISO-8859-1 Should be: ?xml version=1.0 encoding=ISO-8859-1 ? ok by beginning the php-code with ?php I fixed the problem. Unfortunately my RSSowl tell me that there must be other errors in the xml-formating. And I don't got a detailed information what RSSowl dislike in the xml-file. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problem with rss-feed generation
Niel Archer wrote: Hi ok by beginning the php-code with ?php I fixed the problem. Unfortunately my RSSowl tell me that there must be other errors in the xml-formating. And I don't got a detailed information what RSSowl dislike in the xml-file. Try opening it in a browser. Opera, for example, tells you what error it encounters. That's how I identified your initial error. firefox tells me that it dislike the closing xml-tag. In my quanta-editor it seems that can be difficulties with the tagend of the opening xml-line of the second position of the questionmark. Regards, Ruprecht ?xml version=1.0 encoding=ISO-8859-1? !DOCTYPE rss PUBLIC -//Netscape Communications//DTD RSS 0.91//EN http://my.netscape.com/publish/formats/rss-0.91.dtd; rss version=0.91 channel title(RSS 2.0)/title linkhttp://www.bla.com//link descriptionDie neuesten Artikel in Bla-Bereich ; /description languagede/language managingEditorRuprecht Helms [EMAIL PROTECTED]/managingEditor webMasterRuprecht Helms [EMAIL PROTECTED]/webMaster item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; dsklfdsafdsajfasdf lt;brgt;/description descriptiondsklfdsafdsajfasdflt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; Test lt;brgt;/description descriptionTestlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; Testantwort lt;brgt;/description descriptionTestantwortlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; xx lt;brgt;/description descriptionxxlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]Test erneuter Testlt;brgt;/description description]Test erneuter Test lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]Test erneuter 2. Test lt;brgt;/description description]Test erneuter 2. Test lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]Test erneuter 2. Test lt;brgt;/description description]Test erneuter 2. Test lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; dfklödsfadfsjdkjsdafasdj lt;brgt;/description descriptiondfklödsfadfsjdkjsdafasdjlt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]dfklödsfadfsjdkjsdafasdj lt;brgt;/description description]dfklödsfadfsjdkjsdafasdj lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]dfklödsfadfsjdkjsdafasdj lt;brgt;/description description]dfklödsfadfsjdkjsdafasdj lt;brgt; - /description /item item title/title link/link descriptionlt;table CELLPADDING=quot;5quot; CELLSPACING=quot;0quot; border=quot;0quot; align=quot;leftquot;gt;lt;trgt;lt;tdgt;lt;#47;tdgt;lt;#47;trgt;lt;#47;tablegt; lt;brgt; ]dfklödsfadfsjdkjsdafasdj lt;brgt;/description description]dfklödsfadfsjdkjsdafasdj
Re: [PHP-DB] Problem with rss-feed generation
Hi Niel, firefox tells me that it dislike the closing xml-tag. In my quanta-editor it seems that can be difficulties with the tagend of the opening xml-line of the second position of the questionmark. Because you missed the space in front of it. You really need to find out more about XML and RSS specifications. This isn't a PHP or Db problem so doesn't belong on this list. Maybe I thought that someone of the member have worked with a dynamicly rss-feed generator. I use some mysql-tables for content within the feed. Du you know a good tutorial for XML and RSS, possible relating with PHP. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with imagebuilding
Hi, I actually have a problem with a script that creates a picture from database content. I the following error: Warning: imagepng(): supplied argument is not a valid Image resource in /opt/lampp/htdocs/cycosmos_2/avatare/avatarbild.php on line 315 The other lines that copy and resize other content for the imagebuilding I've remarked, because there produce errors too. Another script that produce the result that I want by working with hardcoded content works without no problems. Can someone tell me what can be wrong in the databasescript. The file avatarbild.php contails the malefunction script. The file bild_komplettavatar.php contains an example with the correct output. Regards, Ruprecht --- Ruprecht Helms IT-Service Softwaredevelopment allow your worktools be individual Web: http://www.rheyn.de avatarbild.php Description: application/php bild_komplettavatar.php Description: application/php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problems by transfer of arrayed formfield
Hi,
in the meentime I tried to look why the foreach-loops puts out an error.
I change the script with the checkboxes in this to look that the array
is filled correctly.
html
head
titleTest/title
/head
body
form action=form_test2.php enctype=multipart/form-data
gesamt louml;chen nbsp;nbsp;
?
for ($i=0;$i=5;$i++)
{
//echo input type='checkbox' name=\ids[]\ value=.$i.;
$ids[] = $i;
//$user_id = $aus_konto[kontoinp];
//echo input type='checkbox' name='aus_id[]' value='$user_id';
}
?
input type=submit value=ausführen
input type=reset value=abbrechen
/form
I still have problems with the foreach-loop
Here the actually error:
*Warning*: Invalid argument supplied for foreach() in
*/www/htdocs/scriptdirectory/form_test2.php* on line *11
Regards,
Ruprecht Helms
*
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Reset of checkboxstati
Hi, how can I reset the status of a checkbox. I want that no checkbox is selected on loading or reloading a form. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] handling of checkboxvalues
Luis Morales wrote: Well, you can do this... form name='my_form' method='post' action='form.php' ENCTYPE='multipart/form-data' input type='checkbox' name='user_loeschen[] value=?= $id ? id=?= $id? input type=submit name=submit value=send form /form Actually I have written this script to check the checkbox. This bring me an error telling me that I have forgot to set a ; but I think I ve coded something wrong with simple and dopple quots. Regards, Ruprecht html head titleTest/title /head body form ? echo input type='checkbox' name='aus_id[]' value='.$aus_konto[konto].erl=I'; ? /form /html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problems by transfer of arrayed formfield
Hi I have to scripts that should transfer values of a checkbox into
another script that put them out.
You see that the value of the checkbox is stored in a array-variable. By
putting out the value of
the arrayvariable there is no output. What can be wrong.
Enclosed the two scripts.
Regards,
Ruprecht
html
head
titleTest/title
/head
body
form action=form_test2.php
gesamt louml;chen nbsp;nbsp;
?
for ($i=0;$i=5;$i++)
{
echo input type=checkbox name='aus_id[$i]' value=$i;
//$user_id = $aus_konto[kontoinp];
//echo input type='checkbox' name='aus_id[]' value='$user_id';
}
?
input type=submit value=ausführen
input type=reset value=abbrechen
/form
/html
html
head
titleTest/title
/head
body
?
for ($i=0;$i=5;$i++)
{
echo $aus_id[i];
}
//$user_id = $aus_konto[kontoinp];
//echo input type='checkbox' name='aus_id[]' value='$user_id';
?
/form
/html
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] handling of checkboxvalues
Hi Luis,
you can do this...
form.php
?
if($_POST['submit'] == 'send form'){
for($i=0;count($_POST['user_loeschen'])$i;$i++){
--- put here your sql statement to delete user ---
ej... delete from users where id = '{$_POST['user_loeschen'][$i]}'
---
}
}
?
form name='my_form' method='post' action='form.php'
ENCTYPE='multipart/form-data'
input type='checkbox' name='user_loeschen[] value=?= $id ? id=?=
$id?
input type=submit name=submit value=send form
/form
I think I made it like the same you tell me. Look into the other mail I
post to the list.
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Problems by transfer of arrayed formfield
Hi antispo,
html
head
titleTest/title
/head
body
?
for ($i=0;$i=5;$i++)
{
echo $aus_id[i]; //try echo $_POST['$aus_id][$i]
}
//$user_id = $aus_konto[kontoinp];
//echo input type='checkbox' name='aus_id[]' value='$user_id';
?
/form
/html
Ok I clickt on the 1st and 3rd checkbox. I stored the value of $i as
value into the checkbox-array. The result should be 0 2, but I does not
get an result. The only I get is an empty page.
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] handling of checkboxvalues
Hi, I want to have a function that delete some customers. The customers will be selected by cklicking on in checkboxes. This is the line I codes the checkboxes: input type='checkbox' name='user_loeschen[] value=id id=.[User-ID]. How can I use the checkboxvariable within another script and handle the id-value? I little codescripplet will help me. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] How to put content of databasefield into an array
Hi, how can I put the content of a databasefield into a array. I need this to put out a securetyimage for validation. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problems in creating image
Hi,
I want to insert a securityimage within a registrationform.
Unfortunately the securityimage-scripts is putting out errors.
Actualy I have the whole project that include also these scripts on my
local host under /srv/www/htdocs/projectdir.
What can be wrong because the script only says that it cant be displayed
because there are errors in the script. What
errors that are not mentioned.
The database Moneysql1 mentioned in the script is stored localy.
As Attachment the script.
Regards,
Ruprecht
?
header (Content-type: image/jpeg);
if (!isset($code)) {
exit;
}
$host = localhost;
//$user = Moneysql1;
$user=root;
//$pass = QaKkoMXq;
$pass = ;
$datenbank = Moneysql1;
$verbindung = mysql_connect($host, $user, $pass) OR die (Konnte keine Verbindung zur Datenbank herstellen!);
mysql_select_db($datenbank) OR die (Konnte die Datenbank nicht auswaehlen!);
$im = imageCreateFromJPEG($_SERVER[DOCUMENT_ROOT]./images/secure_back2.jpg);
// Lösche alte Securecodes
$zualt = date(Y-m-d H:i:s,mktime(date(H),date(i)-10,date(s),date(m),date(d),date(Y)));
$res = mysql_query(DELETE FROM secure WHERE datum'.$zualt.');
// Jetzt hole den neuen
$res = mysql_query(SELECT * FROM secure WHERE secure1='.$code.');
if (mysql_num_rows($res)1) {
exit;
}
$help = mysql_fetch_array($res);
$z = $help[secure2];
$abstand = 20;
$zufall = array();
$gesamtbreite = 0;
for ($n=0;$nstrlen($z);$n++) {
$zufall[$n] = array();
$zufall[$n][ziffer] = substr($z,$n,1);
//echo $_SERVER[DOCUMENT_ROOT];
$ausmasse = ImageTTFBBox(20,0,$_SERVER[DOCUMENT_ROOT]./ttf/arialbd.ttf,substr($z,$n,1));
$zufall[$n][hoehe] = rand(0-$ausmasse[5],40);
$zufall[$n][breite] = $ausmasse[4];
$gesamtbreite += $ausmasse[4];
}
// Zähle den Abstand dazu
$gesamtbreite += (strlen($z)-1)*$abstand;
$breite = (250-$gesamtbreite)/2;
$black = ImageColorAllocate ($im, 0, 0, 0);
// Und jetzt setze jede einzelne Ziffer in das Bild ein
for ($n=0;$nstrlen($z);$n++) {
ImageTTFText ($im, 20, 0, $breite, $zufall[$n][hoehe], $black, $_SERVER[DOCUMENT_ROOT]./ttf/arialbd.ttf, $zufall[$n][ziffer]);
$breite += $abstand;
$breite += $zufall[$n][breite];
}
ImageJpeg ($im);
ImageDestroy ($im);
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Scriptproblem
Hi, how can I display the stored data of an user as value in a formfield. Actualy the formfield vorname shows no entry and the formfield name shows .$row-Name. What is the correct syntax in this case. Regards, Ruprecht ? mysql_connect(localhost,user,password); $result=mysql_db_query(salzert,SELECT * FROM Benutzer WHERE ID=$id); echo 'input type=text name=id value='; echo $id; echo ''; echo tr; echotdVorname/td; echo 'tdinput type=text name=vorname value='; echo $row-Vorname; echo '/td'; echo /tr; echo tr; echo tdName/td; echo 'tdinput type=text name=name value=.$row-Name./td'; echo /tr; ... ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] inserting due date into database
Hi, how can I calculate the due date from the date of an invoice and insert the result into a mysql-database. The daydifference is 14 days. Actualy I have tried something with mktimes, but I only get the timestamp of the due date. I have troubles to write that into a dabasefield that was set to datetype. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] insert into mysql-db from csv-file
Hi John, I want to read a csv-file and import the datas into a mysql-db. How do I make this. A little scriptexaple in php would be helpfull. Why not just LOAD DATA INFILE from MySQL? No need to involve PHP at all, really... I think the command you also can write in the mysql_db_query-Command. The problem the insertprocedure must be able via webbrowser. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Import into mysql from csv-file
Hi, how do I import data stored in a csv-file (formated text) into a mysql_database. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP sitemap
Dermot Mc Laughlin wrote: Hi, Is it possible/easy to create a simple sitemap page using PHP which would automatically parse all files and directories from index.html and create a structured HTML document from the results? seams to be possible. It's some code to write. You need something to store the founded links for processing later. Regards, Ruprecht -- Ruprecht Helms IT-Service Softwareentwicklung Tel./Fax +49[0]7621 16 99 16 Web: htp://www.rheyn.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: Validate Value
Rinku wrote: Can you pls tell me how to add space in name ? by using nbsp; or by using the using the ascii-code of that combined with the char-command. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Reading information of german insurance-card
Hi, does someone have made expearances in reading informations from the german insurance-cards that are needed at dentists, hospital, medical doctors, ... How do I get the information stored on the card and how can I put the different information into database-fields. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Best table structure
Tom Chubb wrote: Please can someone let me know their opinion on the following: I have written some code for submitting a top 20 music chart online. I use the following to insert into mysql: your posting is offtopic - you can get more help by asking in the mysql-mailinglist. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Image Resize
Kenny wrote: Hi All, Does anyone know if you can resize a tif image? I have created a photo gallery and the client want to be able to upload Jpeg and Tiff files, Unfortunately I have never worked with Tiff Here is my code for Jpg files, But tiff has me stumped tiff is not good graficformat. The browsers aren´ t able to display this. Some browsers, f. e. IE are not able to display the PNG-format always properly. The best you take only jpg. The snipplet you send seams to work. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Procedure for submitting an order via email
On 1 May 2004 at 22:47, Ignatius Reilly wrote: With the PHP IMAP functions you can process your mail box programmatically as a data repository. nice to know. What I want is an scriptexample for a checkoutprocedure of a online-store. I want submit via email the content of a basket, that is stored in a databasetable, some formfields and the mailreceiver taken from another databasetable. Regards, Ruprecht Ruprecht Helms IT-Service Softwareentwicklung Tel./Fax +49[0]7621 16 99 16 Web: http://www.rheyn.de email:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Procedure for submitting an order via email
Hi, I'm looking for an simple example how to send an order (content of the basket) via email. Does someone have such a good ans simple example. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with update-command
Hi, In the attached file I've a problem with the update-procedure. The procedured gets its values from a formular an should update an articlerecordset as needed. After update I get not the result of the updating, the old value is stored in the database. How have I to rewrite the lines for proper work. Regards, Ruprecht Ruprecht Helms IT-Service Softwareentwicklung Tel./Fax +49[0]7621 16 99 16 Web: http://www.rheyn.de email:[EMAIL PROTECTED] ? echo Artikelid ; echo $id; echo Chorid ; echo $chorid; echo Beschreibung ; echo $beschreibung; echo Preis ; echo $preis; mysql_connect(localhost,web172,fbn7__1); //$result=mysql_db_query(usr_172_1,UPDATE artikel SET Beschreibung='$beschreibung' WHERE Chorid=$chorid AND ID=$id); $result=mysql_db_query(usr_172_1,UPDATE artikel SET Preis='\$preis\' WHERE ID='\$id\'); //mysql_error($result); ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with cookies
Hi,
I've some trouble with the handling of cookies. At the command setcookie I get a
warning that the header is already set. How can I fix the problem.
Regards,
Ruprecht
Ruprecht Helms IT-Service Softwareentwicklung
Tel./Fax +49[0]7621 16 99 16
Web: http://www.rheyn.de
email:[EMAIL PROTECTED]
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.
File information ---
File: basket_add.php
Date: 16 Feb 2004, 16:52
Size: 4996 bytes.
Type: Unknown
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] convert date in german format
Hi, how can I convert a date stored in a mysql-database for output in the german format (dd.mm.yy). I tried date (d.m.y,$row-from); but I still get the english-format stored in the database. The databasefield is type date. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] OT] PHP-DEV tarball
Hi, does someone know where I can find a sourcetarball of the dev-package for php (4.33 and/or 4.2.3)? I need it for an php-extension. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Help with file upload
On Thu, 2003-10-16 at 07:14, John W. Holmes wrote: Bunmi Akinmboni wrote: Warning: move_uploaded_file(./ayservenet.jpg): failed to open stream: Permission denied in /home/ayserve/public_html/fu/fuprocess.php on line 6 PHP runs as the web server and it does not have permission to write to the current directory. If you're using IIS, PHP runs as the IUSR_computer_name user. And how is it by running Linux. I've a similar problem with my provider in uploading files via php. The permissions in the html-subdir are set that all persons have write-permissions. At the moment I work with a workaround that by using email to transfer the file to me to be uploaded via ftp. But the way should be that the user should be able to upload a file by himselve via PHP. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Help with file upload
On Thu, 2003-10-16 at 09:58, Bunmi Akinmboni wrote:
Thanks Neil. My ultimate aim to update my database with the details of
the upload after it uploads successfully, but I need to solve this
problem first.
The folder already has permission 777.
Dateiname: /home/www/web172/phptmp/phppYlgrZDatei wurde hochgeladen
Warning: move_uploaded_file(): SAFE MODE Restriction in effect. The
script whose uid is 897 is not allowed to access
/home/www/web172/html/html owned by uid 30 in
/home/www/web172/html/upload_http.php on line 9
This is my actual Warning after running this script
files should moved from ../web172/phptmp/ into ../web172/html/
both directories are on the same 'floor'.
?
echo 'Dateiname: ';
echo $userfile;
//chdir('html');
if(is_uploaded_file($userfile));
{
echo Datei wurde hochgeladen;
chmod(html,100755);
move_uploaded_file($userfile,'html/'.$userfile);
}
//move_uploaded_file($userfile,$userfile);
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with uploadscript
Hi,
I've problems with a http-uploadscript. When I run the htmlfile and the
script replies an output of the filename but I can't find the file in
the destinationdirectory.
Why this can happen. Addes you can see the html-file and the script
Regards,
Ruprecht
html
head
title/title
meta http-equiv=Content-Type content=text/html;
charset=ISO-8859-15
meta name=GENERATOR content=Quanta Plus
/head
body
form action=upload_http.php enctype=multipart/form-data
input type=hidden name=MAX_FILE_SIZE value=1
pDatei:input type=file name=userfile
input type=text name=zielpfad value=html/p
input type=submit value=hochladen
input type=reset value=abbrechen
/form
/body
/html
?
echo 'Dateiname: ';
echo $userfile;
//chdir('html');
move_uploaded_file($userfile,'html')
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Trouble with uploading a file via ftp_put
Hi, Let me get this straight: You're trying to transfer a file from a local PC (A) to a server (B). And your code is running on (B)? If so, then, (assuming you have things setup correctly, ie have an ftpserver running on (A)), you should be using ftp_get() or similar. If not, could you describe *exactly* what you're trying to do and explain why you're not using a standard FTP client on the local pc to transfer the file to the remote pc. I want that (B) can locate the file on (A) and upload it to the subdirectory on (B). This should also be possible in the case the user have no ftp-server on his local pc. Why I want try it without the standart FTP client. The script is part of a portal and because of comfortreasons and securityreasons I want the upload and the entry in a database act with php on (B). (B) has a ftpserver included. If the way over ftp is the wrong way, you can also tell me how to do this with the normay copy-command. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] pathinformation from file-field
Hi, how can I get the pathinformation you can see in the file-field if you chose one file within a formular for transfer. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] pathinformation from file-field
On Mon, 2003-10-06 at 13:07, Jason Wong wrote: On Monday 06 October 2003 18:31, Ruprecht Helms wrote: how can I get the pathinformation you can see in the file-field if you chose one file within a formular for transfer. If you mean when you do an HTTP upload, then no, you cannot get the path info. All you get is the file name. This is for security reasons. yes for upload. I try to use it with the copy-command. I want combine it with the ipadress of the local host. If I'm right the file should be copied to a webserver. With ftp or http-upload I have trouble, because the uploadfunctions are malefunction. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Trouble with uploading a file via ftp_put
On Mon, 2003-10-06 at 13:05, Jason Wong wrote:
Now I tried the method with move_uploaded (http-upload).
This is the testscript
?php
// upload.php: PHP File Upload im Safe Mode21.5.02/vo
// (http-Protokoll und POST-Mechanismus)
// Skript funktioniert auch im Safe Mode, da
//die Funktion move_uploaded_file verwendet wird.
if ($img1_name == ) {
?
html
head
titleUpload a File/title
/head
!--
Formular: in einem Filepanel kann der Name des lokalen Files angegeben
werden, das auf den Server hochgeladen werden soll.
--
body
h1Upload a File/h1
form enctype=multipart/form-data method=post
action=?php echo $PHP_SELF?
pstrongFile to Upload:/strongbr
input type=file name=img1 size=30/p
Pinput type=submit name=submit value=Upload File/p
/form
?php
}
// Das Formular ist ausgefuellt worden...
else {
$curdir=getcwd();
// der Filename kommt vom Formularfeld img1, s. oben.
// Dieser Touch muss mit dem cgi-Skript gemacht werden:
// exec(/usr/local/info-sys/cgi-bin/phptouch $SCRIPT_FILENAME
$curdir/tmp/$img1_name,$t,$status);
move_uploaded_file($img1, ./html/$img1_name);
// Dieser Chown muss mit dem cgi-Skript gemacht werden:
// exec(/usr/local/info-sys/cgi-bin/phpchown $SCRIPT_FILENAME
$curdir/tmp/$img1_name,$r,$status);
// Wichtig:
// rwx-Permissions erforderlich fuer Zielverzeichnis tmp
?
html
head
titleFile Upload/title
/head
body
PYou sent: ?php echo $img1_name; ?, a ?php echo $img1_size;
? byte file with a mime type of ?php echo $img1_type; ?./p
?php
}
?
/body
/html
And this are the errormessages.
Warning: move_uploaded_file(./html/udsklein.png)
[function.move-uploaded-file]: failed to create stream: No such file or
directory in /home/www/web172/html/upload.php on line 51
Warning: move_uploaded_file() [function.move-uploaded-file]: Unable to
move '/home/www/web172/phptmp/php7AuByW' to './html/udsklein.png' in
/home/www/web172/html/upload.php on line 51
You sent: udsklein.png, a 5741 byte file with a mime type of image/png.
What can be wrong here
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Trouble with uploading a file via ftp_put
Hi,
by uploading a file via the ftp_put-command the upload is not done
properly. Result is I have a file in the destinationdirectory but
0 bit in size, only the filename is transfered.
How have I to write the script that the file I want upload should
be uploaded within the correct size. The actual script you can see
here.
[code]
$conn_id=ftp_connect('62.241.50.14');
ftp_login($conn_id,'user','password');
echo Current directory : , ftp_pwd($conn_id), \n;
ftp_chdir($conn_id,html);
echo Current directory is now : , ftp_pwd($conn_id), \n;
$dstdir=html;
$upload=ftp_put($conn_id,$bild,$dstdir./.$bild,FTP_BINARY);
[/code]
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Trouble with uploading a file via ftp_put
On Sun, 2003-10-05 at 11:39, Jason Wong wrote:
$upload=ftp_put($conn_id,$bild,$dstdir./.$bild,FTP_BINARY);
[/code]
1) You've got your source-file and destination-file mixed up.
2) You've already chdir into 'html' so destination-file so be just '$bild' and
not '$dstdir./.$bild'. Unless your directory structure really is
'html/html/'
actual I have the following script.
I want to upload a image from the local pc into the subdir html of a
webspace. The file I want to upload is not stored in the
destinationdirectory.
This is my actual script
?
...
$conn_id=ftp_connect('62.241.50.14');
ftp_login($conn_id,'user','password');
echo Current directory : , ftp_pwd($conn_id), \n;
//ftp_chdir($conn_id,html);
echo Current directory is now : , ftp_pwd($conn_id), \n;
echo brBilddatei ;
echo $bild;
$upload=ftp_put($conn_id,'html'+$bild,$bild,FTP_BINARY);
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: [PHP-INSTALL] Problem by running mysql-connection in php-script
On Thu, 2003-10-02 at 22:28, Michael Scappa wrote: Ruprecht, Make sure you have PHP pointing to the right location for the mysql.sock. locate mysql.sock. Sometimes its in the /tmp dir. If it is in another location you can point to it specifically when you call mysql_connect (refer to php.net for the exact string), or just change it in your php.ini. This are the entries I've made in the php.ini [MySQL] ; Allow or prevent persistent links. mysql.allow_persistent = On ; Maximum number of persistent links. -1 means no limit. mysql.max_persistent = -1 ; Maximum number of links (persistent + non-persistent). -1 means no limit. mysql.max_links = -1 ; Default port number for mysql_connect(). If unset, mysql_connect() will use ; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the ; compile-time value defined MYSQL_PORT (in that order). Win32 will only look ; at MYSQL_PORT. mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. mysql.default_socket = /tmp/mysql.sock ; Default host for mysql_connect() (doesn't apply in safe mode). mysql.default_host = localhost ; Default user for mysql_connect() (doesn't apply in safe mode). mysql.default_user = root And this is my actual /tmp-directorylinux:/tmp # ls . .esd AcroSaTWYY aaa ksocket-root migrate-2 noteedit.2vmq44 .. .shtool.8404 AcroWx7cEx alsaplayer_root_0mc-root migrate-3 noteedit.rvtxIc .ICE-unix .webmin Acrol21KzJ audacity1.1-root mcop-root migrate-4 orbit-root .X0-lock AcroAgqtL1AcrooMY5eg gsr-record-Untitled.wav-1603.BHH8QX medusa-idled-service migrate-5 .X11-unix AcroMfep2RAcrowt39f1 jpsock.141.6939 migrate migrate-6 .caitmpAcroQUQtXcAcrox5BdJI kde-root migrate-1 mysql.sock You see there is the mysql.sock And this is the connection-command in some scripts I use. Normaly it works fine, but now It fails and I get the reported error. mysql_connect(localhost,root); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL, PHP or ghost?
Hi Peter Beckman, Seems that either I don't understand mysql, or something. My table, with the non-important things removed... mysql explain plate; +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-++ | pid | mediumint(8) unsigned | | PRI | NULL| auto_increment | | year| year(4) | YES | | NULL| | [...] mysql select * from plate where pid=65; +-+-+--+- | pid | plate | year | +-+-+--+- | 65 | DVF0343 | NULL | +-+-+--+- But if I do this: mysql update plate set year= where pid=65; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 1 mysql select * from plate where pid=65; +-+-+--+- | pid | plate | year | +-+-+--+- | 65 | DVF0343 | 2000 | +-+-+--+- you have chosen a wrong format. The format for year is . With string the field years don't know what to do. Regards, Ruprecht --- Ruprecht Helms IT-Service Softwareentwicklung Tel./Fax +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Imageresizing for giffiles
Hi,
here I've an example for dynamicly resizing jpg-files. How can do this
for gif-files?
Regards,
Ruprecht
?
mysql_connect(localhost,root);
$result=mysql_db_query(chorportal,SELECT * FROM dirigent WHERE
ID='$chorid');
while ($row = mysql_fetch_object($result))
{
if (!$row-Foto)
{
$source = imagecreatefrompng('leer.png');
$ctl = 1;
}
else
{
$source = imagecreatefromjpeg($row-Foto);
}
}
$orig_width = imagesx($source);
$orig_height = imagesy($source);
$size_limit = 70;
if ($orig_height $oirg_width)
$scaledown = $orig_height;
else
$scaledown = $orig_width;
$newscale = $size_limit / $scaledown;
$new_w = abs($orig_width * $newscale);
$new_h = abs($orig_height * $newscale);
$base_image = imageCreate($new_w, $new_h);
imagejpeg($base_image,'temp.jpg');
if ($ctl != 1)
{
$image = imagecreatefromjpeg('temp.jpg');
$imagetoresize = imagecreatefromjpeg('chor1_gr.jpg');
imagecopyresampled($image,$imagetoresize,0,0,0,0,$new_w,$new_h,$orig_width,$orig_height);
imageJpeg($image,'chor.jpg',100);
unlink('temp.jpg');
echo img src='chor.jpg' ;
}
else
{
echo img src='leer.png';
}
?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] changing properties of an image dynamicly
Hi, how can I change the size-properties of an image that I take from a database dynamicly to a new format. The original picture can be different in size and should become a new fixed size. Also interessting for me is when I have s list of pictures with different original size and I will reduze the size to display all the pictures of the list but if there are more pictures the picutures are smaller than the list have less entries. This are two seperate questions. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] failure in Uploadfunction
Hi,
I want to make a fileupload via php within a script that insert values
into a database. By executing the script I get the error that ftp-put
can function, because there is no correct login into the ftp-server
(user and password is required). Replace the emailadress against the
userpassword I get no error, but I get no result - file in the subfolder
upload of the directory-path.
I tried ftp-login but it also fails with a error. As FTP-Server I use
the proftpd.
$conn_id=ftp_connect('127.0.0.1');
ftp_login($conn_id,'rhelms','[EMAIL PROTECTED]');
$upload=ftp_put($conn_id,'/srv/www/htdocs/chorportal/upload/'+$logo,$logo,FTP_BINARY);
if (!$upload)
{
echo FTP failed;
}
else
{
echo FTP-Upload successful;
}
How have I to correct the script that the upload functions properly.
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem with select-tag within a php-script
Hi,
I've some trouble with a select-tag in a php-script.
In a database should be written the ID of a table, the user could select
the recordset by the Name. My problem is that the fieldentry of the
selecttag is not transfered to the executionscript. The different Names
within the recordset are shown correctly.
Here my listing
?
mysql_connect(localhost,root);
$result=mysql_db_query(chorportal,SELECT * FROM choere ORDER BY
Name);
echo select value='chorid';
while($row = mysql_fetch_object($result))
{
echo option value=\'.$row-ID.\';
echo $row-Name;
echo /option;
}
echo /select;
?
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problems with formvalues by using Suse 8.2
Hi, under using Suse 8.2 I've the problem that the values of formfields will be put out or worked withit within a phpscript. The testscript with phpinfo() is working fine. What have I to set (in the php.ini) that php is handling the formfieldvalues properly? Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] actualy result of problem with formfieldvalues under Suse 8.2
Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? The value I take from a normal formfield by the default transfermethod. After switching to the php-script I get a blank page without the value I inserted into the textfield. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] actualy result of problem with formfieldvalues underSuse 8.2
On Thu, 2003-06-19 at 23:30, Thorsten Körner wrote: Hi Am Donnerstag, 19. Juni 2003 23:21 schrieb Ruprecht Helms: Hi, in the meantime I set the value of register_globals = off the next to on. I get the same result. The following script I use for testing the formfieldvalues ? echo $begriff ? As I said before, this the wrong way. You should leave register_globals=off and acces your data this way: ?php echo $_POST['begriff']; ? Ok here the copy of my script in original ? echo $begriff; ? That is all Your second mistake was to forget the ; and the end of the echo-line ?php echo $_POST['begriff']; ? Your second mistake was to forget the ; and the end of the echo-line The value I take from a normal formfield by the default transfermethod. What the heck do you mean with default. You should always set: html head title/title meta http-equiv=Content-Type content=text/html; charset=ISO-8859-15 meta name=GENERATOR content=Quanta Plus /head body form action=formtest.php method=POST input type=text name=begriffbr input type=submit value=senden /form /body /html After switching to the php-script I get a blank page without the value I inserted into the textfield. This problem I have first by upgrading to 8.2. Attached my php.ini Regards, Ruprecht [PHP] ;;; ; WARNING ; ;;; ; This is the default settings file for new PHP installations. ; By default, PHP installs itself with a configuration suitable for ; development purposes, and *NOT* for production purposes. ; For several security-oriented considerations that should be taken ; before going online with your site, please consult php.ini-recommended ; and http://php.net/manual/en/security.php. ;;; ; About this file ; ;;; ; This file controls many aspects of PHP's behavior. In order for PHP to ; read it, it must be named 'php.ini'. PHP looks for it in the current ; working directory, in the path designated by the environment variable ; PHPRC, and in the path that was defined in compile time (in that order). ; Under Windows, the compile-time path is the Windows directory. The ; path in which the php.ini file is looked for can be overridden using ; the -c argument in command line mode. ; ; The syntax of the file is extremely simple. Whitespace and Lines ; beginning with a semicolon are silently ignored (as you probably guessed). ; Section headers (e.g. [Foo]) are also silently ignored, even though ; they might mean something in the future. ; ; Directives are specified using the following syntax: ; directive = value ; Directive names are *case sensitive* - foo=bar is different from FOO=bar. ; ; The value can be a string, a number, a PHP constant (e.g. E_ALL or M_PI), one ; of the INI constants (On, Off, True, False, Yes, No and None) or an expression ; (e.g. E_ALL ~E_NOTICE), or a quoted string (foo). ; ; Expressions in the INI file are limited to bitwise operators and parentheses: ; |bitwise OR ; bitwise AND ; ~bitwise NOT ; !boolean NOT ; ; Boolean flags can be turned on using the values 1, On, True or Yes. ; They can be turned off using the values 0, Off, False or No. ; ; An empty string can be denoted by simply not writing anything after the equal ; sign, or by using the None keyword: ; ; foo = ; sets foo to an empty string ; foo = none; sets foo to an empty string ; foo = none ; sets foo to the string 'none' ; ; If you use constants in your value, and these constants belong to a ; dynamically loaded extension (either a PHP extension or a Zend extension), ; you may only use these constants *after* the line that loads the extension. ; ; All the values in the php.ini-dist file correspond to the builtin ; defaults (that is, if no php.ini is used, or if you delete these lines, ; the builtin defaults will be identical). ; Language Options ; ; Enable the PHP scripting language engine under Apache. engine = On ; Allow the ? tag. Otherwise, only ?php and script tags are recognized. ; NOTE: Using short tags should be avoided when developing applications or ; libraries that are meant for redistribution, or deployment on PHP ; servers which are not under your control, because short tags may not ; be supported on the target server. For portable, redistributable code, ; be sure not to use short tags. short_open_tag = On ; Allow ASP-style % % tags. asp_tags = Off ; The number of significant digits displayed in floating point numbers. precision= 12 ; Enforce year 2000 compliance (will cause problems with non-compliant browsers) y2k_compliance = On ; Output buffering allows you to send header lines (including cookies) even ; after you send body content, at the price of slowing PHP's output layer a ; bit. You can enable output buffering during runtime by calling the output ; buffering functions. You
Re: [PHP-DB] mysql, php, mp3 - a variable problem
Hi, Where do you get $info2 from? I only see $info in this function. I guess that the $info-values are formfieldvalues. $info-[db-field] is normaly used within a whileloop for outputing a select-statement. In the case of formfieldvalues you can use $formfieldname. .: Allowee function scan_dir($dir) ... $query =insert into mp3 ( file, path, artist, title, album) values ( '$info2-filename', '$dir', '$info2-v2_artist', '$info2-v2_title', '$info2-v2_album');; mysql_query($query); ... Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel./Fax +49[0]7621 16 99 16 email: [EMAIL PROTECTED] Homep.http://www.rheyn.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] - Shopping cart software
Hi Mignon Hunter, Can anyone recommend shopping cart software; does not have to be open source. I need to set up pretty fast and be able to calculate the different sales tax for anywhere, USA. (International should be ok). have a look on http://www.phpshop.org. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel./Fax +49[0]7621 16 99 16 email: [EMAIL PROTECTED] Homep.http://www.rheyn.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Printing from the browser
Hi Antonio Bernabei, Hi, I don't know if this the right place to ask for. I want to print a page on a jet printer . I don't know if it is possible to do printingjobs from serverside. To print a site I think it's better by writing a little javascriptpart into the page that should be printed. What you can do is to combine the phpscript with the javascriptpart so ist must be able to print a dynamicly produced page on your jet printer. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem in PHP with ADODB connection, Microsoft JET
Hi Jason Wong, -- Warning: Invoke() failed: Exception occurred. Source: Microsoft JET Database Engine Description: Syntax error in FROM clause. - The error is quite explicit: Syntax error in FROM clause please post the actual sql-query for correction. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Erro na passagem de parametros
Hi Bruno Pereira, Then in english I can´t pass values from a form in html to a php file. Be so kind and post the code of your html-page and your php-script. So we can try to test it and can say if there are some errors in the code or the problem must be in misconfiguration of the httpd-configfiles or the php.ini. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Web Page Caching
Hi Philip Zee, I don't know if this is the right list to send this question to. It appears that the browser caches the result after a PHP page updates the database. I Possible that your browser stored the content of the page as normal html-page. Normaly CGI and dynamic webcontents are not cached in proxies and in browsercaches. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] RE: [PHP-WIN] Confirmation e-mail
Hi Matt Hillebrand,
That sounds mighty secure, but I think he's trying to verify that the
email address does indeed belong to the person creating an account.
I don't think so. Normaly you identify you by typing username and password
into the textfields. Sometimes the username is identical with your email.
I suggested the way via ssl because of the password-problem. I've heart
that for epayment and transactions with onlinebanking it is based on law
that the connection must be encrypted/ssl.
I use the following two functions to create a random number, and then I
insert it into the DB. Then I send a URL inside the confirmation email
that points to a script for verification of the random number. (The
parameters of the URL are the random number and username for that
particular account.)
function seed() {
list($usec,$sec)=explode(' ',microtime());
mt_srand($sec * $usec);
}
function mk_random($size) {
// $size is the number of digits in $num
$num = '';
seed();
for($i=0; $i$size; $i++) {
$num .= mt_rand(0, 9);
}
return $num;
}
Matt
Regards,
Ruprecht
--
Ruprecht Helms IT-Service und Softwareentwicklung
Tel/Fax.: +49[0]7621 16 99 16
Homepage: http://www.rheyn.de
email: [EMAIL PROTECTED]
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Confirmation e-mail
Hi Davy Obdam, [...] My question is what would be the best approach to achieve this? How is this usualy done? Storing the password in encrypted form in a database. The confirmationmail you can write with the normal mailcommand using addslashes. The securest way if the password was randomly generated is to presend the resultpage via a ssl-connection and without sending a mail or the mail must be protected. So a hacker can't sniff the password. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Parsing html entities to javascript
Hi Edwin Boersma, possible this helps http://www.php.net/manual/en/function.urldecode.php Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Problem in the returnvalue of a function
Hi Bayu Susiloadhy,
thanks for your answer.
function select_price($product_id,$quantity) {
--cut--
return True;
}
--cut--
in the meentime I change the code that not a boolevalue
was returned by the function.
$q is my querystring and $db is the selected database.
I insert the following:
$db-query($q);
$result=mysql_db_query($db,$q);
while ($row = mysql_fetch_object($result))
{
$price = $row-product_price;
}
mysql_free_result($result);
echo \n;
echo $q; // to show the sql-statement in runtime - diagnostics
echo \n;
return $price;
By executing it I get two warnings both this is not a valid Mysql-result
resort. The disliked lines are the begin of the while-loop and an the
mysql_free_result($result)-command.
How have I to change up the script to get the product_price related to the
price_group.
Regards,
Ruprecht
--
Ruprecht Helms IT-Service und Softwareentwicklung
Tel/Fax.: +49[0]7621 16 99 16
Homepage: http://www.rheyn.de
email: [EMAIL PROTECTED]
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problem in the returnvalue of a function
Hi,
I have a problem in the response of a php-function.
Here the query on the mysql-prompt.
mysql select * from product_price where product_id=7 and from_price =5;
+--++---++--+---
---+-+-+---+---+
--+
| product_price_id | product_id | product_price | from_price | to_price |
product_currency | product_price_vdate | product_price_edate | cdate |
mdate | shopper_group_id |
+--++---++--+---
---+-+-+---+---+
--+
|7 | 7 |149.99 | 0 | NULL | USD
| 0 | 0 | 950321754 | 966506270
|5 |
| 16 | 7 | 2.99 | 1 |2 | USD
| 0 | 0 | 966589140 | 966589140
|6 |
| 17 | 7 | 1.99 | 3 |5 | USD
| 0 | 0 | 966589140 | 966589140
|6 |
+--++---++--+---
---+-+-+---+---+
--+
3 rows in set (0.00 sec)
And here is the function I have written in php
/*
** name: select_price()
** created by:
** description:
** parameters:
** returns:
**/
function select_price($product_id,$quantity) {
echo Product-ID ;
echo $product_id;
echoQuantity ;
echo $quantity;
echo;
$db = new ps_DB;
$q = SELECT * FROM product_price ;
$q .= WHERE product_id= . $product_id . AND from_price = .
$quantity . ;
$q .= AND to_price = . $quantity . ;
$db-query($q);
echo \n;
echo $q;
echo \n;
return True;
}
This is the line for calling the function (in the code one line):
$price=$ps_product_price-select_price($cart[$i][product_id],$cart[$i][quanti
ty]);
//printf(%.2f, $price[product_price]);
printf(%.2f,$price);
I don't understand why the function ever returns the price 1.00 by different
quantities.
Regards,
Ruprecht
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] export 2 values for function
Hi, how have I to define the calling and a function to work with two values exported to a function that return one result. Concret I want to include a grouped-price-function in a shopping-application. The function to find the right price needs the product_id and the quantity. It returns the product-price related to the price-group which is defined for the quantity. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Outgoing mail problem.
Hi Antônio Pires de Castro Jr., Friends, I have a RedHat 7.3. I am having problems to send email. I know, I must config the php.ini. What are the configurations, that i need to setup? The path to your sendmailwrapper. I think in the case of qmail you have to write /var/qmail/bin/qmail-inject at the line of the sendmail-configuration. I have to say I've not tested the entry, because at moment I have no mailforms running in my local environment and no specific entry in my php.ini. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Storing Radio Buttons Checkboxes in MySQL
Hi Jason Wong, manual FAQ PHP and HTML Contents/answers for checkboxes, radiobuttons and/or option-boxes usualy are stored in databases. All other (the tags) are nonsense to store in a database, because these are typically templatestuff or written by taking a loop within a php-script. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Permission denied! !§$!§$
Hi Jim Hatridge, Warning: unlink() failed (Permission denied) in /home/hatridge/public_html/Database/currency.php on line 12 permissions and all are either 666 or 777. The modification 777 means everyone can do everything. So there can't be any problem in writing or reading. Insert a Errorhandling-Command for output what the database dislike. If you are using mysql you do this with mysql_error(). I will remember you to control the connectline. User must exist and the position of user and host is important. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Variables de SESSION dentro de funciones PHP
Hi Francisco José Saiz netPerceptions, would you be so kind and repeat your mail in english. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Parserproblem by cascading outputscript
Hi, I've a parserproblem in the attached script. The script should produce dynamicly a diagramm of a familybuilding. In the part for the second generation I get a parsererror and I do not find what is the problem. Regards, Ruprecht -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Best reporting Tool
Hi Mohammad Saad, [...] or should I use conventional method of writing database queries if you want to use mysql you can use phpMyAdmin [...]but still is there any other better way out, are Oracle Reports supported in PHP? I dont think that php has a feature to support Oracle Reports. But I have heard that php is able to use Oracle. The tools of Oracle are using Java and some of them base on jsp. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] [Newbie Q] csv file upload via php to mysql tutoria
Hi kristina, [...] I can see that phpMyAdmin does this, which is great but I need it for joe public to be able to use. so I don't want them using phpMyAdmin. If you can't use phpMyAdmin try to make it with SQL-Import or a similar function. For mysql you have documentation under http://www.mysql.com in English and http://www.mysql.de for German. Regards, Ruprecht -- Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax.: +49[0]7621 16 99 16 Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Calendar
Hi! I would like this to run with a mySql database. use lycos and are looking for cst-calendar-1.2 Regards, Ruprecht Ruprecht Helms IT-Service und Softwareentwicklung Tel. / Fax+49[0]7621 16 99 16 email: [EMAIL PROTECTED] Homepage: http://www.rheyn.de -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] possible Error in Querydefiniton
Hi John W. Holmes,
You can find out why with mysql_error(), but it's probably because you
haven't selected a database with mysql_select_db().
now I have this code, but with the same result
?
mysql_connect(localhost,root);
mysql_select_db(finance);
mysql_db_query(finace,INSERT INTO buchung (Bezeichnung) VALUES ('b'))or
die(Queryfehler);
?
I always become the die-message. I'm using PHP Version 4.0.6
Regards,
Ruprecht
Ruprecht Helms IT-Service und Softwareentwicklung
Tel/Fax: +49[0]7621 16 99 16
email: [EMAIL PROTECTED]
Homepage: http://www.rheyn.de
-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] possible Error in Querydefiniton
Hi John W. Holmes, Use mysql_error() in your die() message to find out what the problem was... ok, typemissmatch was the problem. Thank for the tip. Regards, Ruprecht Ruprecht Helms IT-Service und Softwareentwicklung Tel/Fax: +49[0]7621 16 99 16 email: [EMAIL PROTECTED] Homepage: http://www.rheyn.de - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] possible Error in Querydefiniton
Hi,
I've some trouble with the following querydefinition
?
mysql_connect(localhost,root);
mysql_db_query(finace,INSERT INTO buchung (Bezeichnung) VALUES ('b'))
or die (Query ungültig);
?
and this is the tablestructur
+-+--+--+-+-++--
| Field | Type | Null | Key | Default | Extra |
Privileges |
+-+--+--+-+-++-
| ID | int(11) | | PRI | | auto_increment |...
| Bezeichnung | varchar(30) | YES | | ||
| Art | char(1) | YES | | ||
| Brutto | char(1) | YES | | ||
| Betrag | decimal(8,2) | YES | | ||
| Steuer | int(11) | | | 0 ||
+-+--+--+-+-++--
By execution the script says that the query die. I don't know why.
Ruprecht Helms IT-Service und Softwareentwicklung
Tel/Fax: +49[0]7621 16 99 16
email: [EMAIL PROTECTED]
Homepage: http://www.rheyn.de
-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] a beginner
Hi Pax, Sorry, Ruprecht. I was talking about mSsql (miscrosoft). Ok, my mistake. I meen that SQL-Server is able to handle stored procedures. But SQL-Server is not the database normaly use with php. Default is mysql. Regards, Ruprecht -- Ruprecht Helms - IT-Service Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 27-Aug-02 Time: 10:14:19 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] verify text entry in a textarea doesn't work
Hi [EMAIL PROTECTED], I use the same type of checking on input type=text boxes and it works fine. Any ideas why it doesn't work on a textarea field? The crlf can be one reason. textareas are not the same like textboxes and you give them parameters how large (horizontal size) and how high (vertical size) it should be. Regards, Ruprecht -- Ruprecht Helms - IT-Service Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 27-Aug-02 Time: 18:15:14 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Mail Function
Hi Manoj Japher, add the following (see in context) ? $toaddress = [EMAIL PROTECTED]; ^ addslashes(...) $fromaddress = [EMAIL PROTECTED]; ^ addslashes(...) $subject = Test Mail; ^ addslashes(...) $content = Your username and password as you requested \n ^ addslashes(...) .Username = user \n .Password = pass \n; mail($toaddress, $subject ,$content, $fromaddress); echo Your username and password has been mailed to you ; ? The returned mail can be a result of the missing part(s). Regards, Ruprecht -- Ruprecht Helms - IT-Service Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 27-Aug-02 Time: 22:16:46 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] a beginner
Hi Pax, ' does .. MSSQL stored proc? I don't think. Mysql handles the handling of SQL-processes by creating a link for the time the process is working. After it the link dies. The result mysql have no transaction-tracking. That's my actual knowledge of mysql. The other database I don't know. Regards, Ruprecht -- Ruprecht Helms - IT-Service Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 26-Aug-02 Time: 21:57:22 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how to insert radiobutton value into mysql database
On 17-Aug-02 bo wrote:
$insertQuery = INSERT INTO tablename VALUES ( \{$Seeking}\,
^^
('$Seeking',...);
);
(and in the future how do I retrieve those from mySQL and output to the
webpage?)
$selectQuery =SELECT * FROM tablename WHERE rule
take the mysql_db_query-command.
Regards,
Ruprecht
P. S. for direct reply remember - because of some spam, mails from
hotmail were automaticly filter out by maildrop on my mta.
--
Ruprecht Helms - IT-Service Softwareentwicklung
==
E-Mail: Ruprecht Helms [EMAIL PROTECTED]
Date: 17-Aug-02
Time: 11:48:53
==
Homepage: http://www.rheyn.de
email: [EMAIL PROTECTED]
Phone + Fax +49[0]7621 16 99 16
This message was sent by XFMail
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] phpmyadmin download
Hi Page Works Web Solutions, Can someone point me in the direction of where to get a copy of phpmyadmin as a .pkg file? a tarball of it you can get via the link http://www.php-center.de There is a links to php-projects and software. Regards, Ruprecht -- Ruprecht Helms - IT-Service Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 06-Jul-02 Time: 14:54:33 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Storing passwords in a database
On 30-Jun-02 Peter J. Schoenster wrote: On 30 Jun 2002 at 11:24, Lisi wrote: 1) Storing the passwords using some form of encryption, ... This seems to me to be preferable, It is nothing that you can suggest or prefer. In this word it sounds I can do if I want. You have to / you must encrypt passwords especially by emailing to users. In the other case you can cancel the password(s) and say to all internetusers here is a host that has all the time a welcomeparty and hacking causes no problems. Remember the content of emails is normaly not secured and ascii-text. Readable for every sniffer. Regards, Ruprecht -- Ruprecht Helms - IT-Service, Internet, Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 30-Jun-02 Time: 23:14:12 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Re: Emulating HTTP File Uploads
I use fopen() to open remote php scripts using the GET method for non-file uploads but it doesnt work with HTTP POST or file uploads. Does anyone have any ideas? http://www.php.net/manual/en/ref.curl.php php consits of a ftpfunction to put files on a webserver without any cgi-like methodhandling. Regards, Ruprecht -- Ruprecht Helms - IT-Service, Internet, Softwareentwicklung == E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 22-Jun-02 Time: 14:54:40 == Homepage: http://www.rheyn.de email: [EMAIL PROTECTED] Phone + Fax +49[0]7621 16 99 16 This message was sent by XFMail -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] HUGE problem here
Hi Camelia Enderby, hi others, try this for the delete query: $query = DELETE FROM auth WHERE name='$deletename'; See if it helps. how the case there a different names in the table that are equal to the value of deletename. try to identify the recordset you want to delete by his ID and then $querey = DELETE FROM auth WHERE id = $recordid; Take care by deleting recordsets. Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 08-Jun-02 Time: 13:05:16 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] dynamic URL result in search?
Hi Rita, [...] I need to get users to the page their book is on [books.php?page=3] -- else they'll have to try to find the book they searched for by going through a bunch of pages. verbal if found books.php?page=$booksite else URL searchsite endif You mast have a databaseconnection an an SELECT-Statement with WHERE-Clause to select the wanted book(s). Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 05-Jun-02 Time: 09:12:23 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Images and MySQL - please help
Hi DrTebi, fetch the image from database A and put it into a buffer then I guess somehow I have to buffer the output, manipulate the buffer by adding the watermark, and then insert the image into the database B ^^ Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 17-Apr-02 Time: 10:41:33 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] dates in MYSQL
Hi Alex Francis, SELECT From the database WHERE date = todays date. ^ somethink like now() or date() an other method you put the date in a variable that you get by the datecommand and make SELECT From table WHERE date = datevar (variable with current date) Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 17-Apr-02 Time: 11:37:25 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: how to notify admin by e-mail only once if mysq
Hi Lisi, Pardon my ignorance, but what's webmin? not a problem. Webmin is a webbased administrationtool for different things to administrate. It begins from useraccounting and ends by administration squid, apache, postfix/qmail, samba, and others. Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 14-Apr-02 Time: 23:21:26 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] how connect a remote data base MSAccess with PHP in
Hi Silvia Mahiques, I have a question... I have a remote database in Microsoft Access on a WinNT System, and a Apache and PHP on Linux System. How can I connect this? There is one function in PHP for make this: odbc_connect(DSN,user,password) DSN (Data Source Name) in local host is the name of the DataBase, but in remote host, what I need do? so you have to add the linuxhost in the DSN. In NT-Notation \\server\path. I don't know how you write it in the odbc-function (you need to connect from linux to your Access-Database on nt). Possible you need unixodbc as driver, but I don't know exactly. Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 10-Apr-02 Time: 11:12:57 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Content Management - best way to store data
Hi olinux, Is it best to store article data in XML - if so how? if it could be a webapplicationserver too have a look on zope http://www.zope.org The Roxen-CMS is based on xml but I have heared from friends that they wasn't able to build an intranet with it. It's totaly different to html and to place a button in xml is not so simple it seams to by you mean first. Regards, Ruprecht -- E-Mail: Ruprecht Helms [EMAIL PROTECTED] Date: 15-Mar-02 Time: 17:29:35 to be informed - http://www.rheyn.de - This message was sent by XFMail -- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Someone using the tool DeZign
Hi, does someone using DeZing as Tool for modelling databases? I have some trouble with the ImportER Access. Regards, Ruprecht -- 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]
Re: [PHP-DB] how to use MS Access file
At 17:25 10.01.02 +0600, Sergey wrote: How can read and put data into or out of file.mdb with sql query With ODBC. Have a look on http://www.unixodbc.org Regards, Ruprecht -- 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]
Re: [PHP-DB] onClick
Hi Jonathan Duncan, Is it possible to call a PHP function using the onclick parameter? If this should be a javascript-mouseevent you have to use onmouseup instead. Regards, Ruprecht -- 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]
