Re: [PHP-DB] About PDO::fetchObject
Something like this should get you started
stmt = $stmt;
$this->metadata = $metadata;
}
public function map()
{
$databaseData = $this->stmt->fetchObject();
$r = new \ReflectionClass($this->metadata['class']);
$obj = $r->newInstanceWithoutConstructor();
foreach ($this->metadata['c2p'] as $col => $property) {
$val = $databaseData->$col;
$type = $property['type'] ?: 'string';
settype($val, $type);
$prop = $r->getProperty($property['name']);
$prop->setAccessible(true);
$prop->setValue($val);
}
return $obj;
}
}
// usage
class Item {
public $id;
public $name;
public $description;
}
$mapper = new SimpleMapper($stmt, array(
// the class where we want to map the database data
'class' => 'Item',
// database column to object property mapping metadata
'c2p' => array(
'ItemID' => array('name' => 'id', 'type' => 'int'),
'ItemName' => array('name' => 'name', 'type' => 'string'),
'ItemDescription' => array('name' => 'description', 'type' =>
'string')
)
));
$item = $mapper->map();
On Thu, Jun 11, 2015 at 9:26 AM, Octopus Puras wrote:
> I have a MySQL table, whose name is Items:
> ItemID ItemName ItemDescription
>
> I also have a PHP class:
> class Item {
> public $id;
> public $name;
> public $description;
> }
>
> If I execute $stmt->fetchObject(), I will get an object with fields of
> ItemID, ItemName, etc. But I want to adapt the name of the fields to the
> Item class. What should I do?
>
Re: [PHP-DB] PDO user question
Hi Jim I've had some success with querying using pdo and prepared statements as well. One thing that I'm curious about is How does one handle the need to get the number of rows returned by a Select? The documentation is very clear that PDO doesn't return that value for a Select statement (depending upon driver?) and there were a couple of solutions that made no sense to me. There was even one that did a completely separate query just to get the row count which makes even less sense. I believe you are referring to "SELECT COUNT(*)..." Because I couldn't find a different way I use that. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] class of objects created by mysqli_result->fetch_object
Hi, I fetched some data from my MySQL database into objects. These are of class stdClass. Now I wonder about the sense of having objects without methods defined. In fact, I cannot benefit from any of the OO advantages (namely property protection, controlled method calls on class properties) unless I wrap the properties of these instances of stdClass to a custom class, right? Is there any way to fetch MYSQL data to a suitable class other than stdClass - suitable in the sense of: the custom class has all properties which are fetched from db. thx Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] History of MySQL support in PHP
Indeed, the book writing is no bad guess, but with slightly different focus than PHP ancestry. But wondering how long mysql is supported is more or less personal interest. Thx to both of you for answering and greetings from Germany to China and California, USA Stefan Reimers ___ Forest Liu wrote: Maybe he is writing a book "Leading to Creativity: the road of PHP and its father" haha just joking my pleasure to read the post from Mr.Lerdorf and best wishes from all Chinese PHP programer. On Sat, 19 Mar 2005 07:41:55 -0800, Rasmus Lerdorf <[EMAIL PROTECTED]> wrote: The actual code for the first MySQL extension was just a search and replace of "msql"->"mysql" in the original msql extension I wrote before that. I found 1995'ish documentation for that the other day: http://lerdorf.com/php/msql.html And that extension was based on the original msql support in PHP version 1 dating back to around March or April of 1995. You can see that code in the PHP 1.0.8 tarball located at http://museum.php.net. Unfortunately I didn't use CVS in the early days so we don't have revision history going back that far. But I am curious, why do you want to know? -Rasmus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] History of MySQL support in PHP
The changelog reaches back to the first beta of PHP4 Forest Liu wrote: I think you can check the changelog on www.php.net On Sat, 19 Mar 2005 14:13:44 +0100, Stefan Reimers <[EMAIL PROTECTED]> wrote: Hi list, can anyone tell me, when PHP originally started the MySQL support? I downloaded the php 3.0.17 version from php.net and it already supports MySQL. Thx in advance Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] History of MySQL support in PHP
Hi list, can anyone tell me, when PHP originally started the MySQL support? I downloaded the php 3.0.17 version from php.net and it already supports MySQL. Thx in advance Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Is there anything non commercial pdf lib to create PDF file from PHP ?
Try FPDF on http://www.fpdf.org/ Stefan Santoso Berkah wrote: Dear Friends, Is there anything non commercial pdf library (stable release) to create PDF file from PHP except PHPlib.com ? I've browsed this site and it costed Euro 450. Can you help me please ? Best regards, [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Problem with an update after an insert: MySQL
It would make things easier if you could determine the error, so try to
use mysql_error after all your mysql_queries, not just after the first one.
Stefan
[EMAIL PROTECTED] wrote:
I'm having trouble with having trouble with doing an update after doing an
insert on and a select on a table. The order of execution is:
$result = mysql_query("select token from tokenuserid where userid =
'$none' ");
if (!$result)
echo mysql_error();
$numresult = mysql_num_rows($result);
$row = mysql_fetch_row($result);
$gotToken = $row[0];
$generatedToken = date(YmdHis);
$result = mysql_query("insert into tokenuserid values ('$generatedToken',
'$none')");
$result = mysql_query("update tokenUserid set userid = '$userid' where
token = '$gotToken'");
if (!$result)
echo "can't find user";
I can't get this update to take. Actually, I can get this to work on one
implementation of this database and on the next implementation of this it
doesn't work. returning the error after the update. The MySQL version is 3.23.52.
Is it because I have a capital U in the name tokenUserid in the update
statement? I could believe this as a reason since the table is defined as:
tokenuserid - (without any caps). If this is the problem then why does it occur in one
implementation and not the other?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Newbie Setup Trouble
Hi!
first of all, the fatal error indicates that the mysql extension is
missing or just disabled. To find out what's wrong check for the file
php_mysql.(so|dll) [using *nix|Windows] in the php-extension directory.
If present, then open the php.ini file and search for the string
extension=php_mysql and delete the ; in front of it, if present.
Stop and start webserver and try again.
Alternatively you should install XAMPP or similar which installs Apache,
PHP and MySQL at once. This makes life easier for beginners.
Stefan
Mike Rondeau wrote:
Hello,
I have just begun study of using PHP, MySQL and Apache server. Right now
I'm following a book, "PHP and MySQL For Dummies" and am having trouble
already. I must be a REAL dummy! I have installed all 3 programs but
something is not right somewhere. Being so new to this I am having a real
time trying to figure out which program is messed up. Certain things work,
but others don't.
For instance, my book told me how to make a phpinfo.php page, which works
fine. But it also tells me to create some other pages to test if PHP and
MySQL are working or not. I followed the scripts provided exactly but keep
getting syntax errors, even though the script is just what the authors
wrote. For instance, it said to make a page and call it mysql_up.php. Here's
the script for it:
Test MySQL
mysql_connect($host,$user,$password);
$sql="show status";
$result = mysql_query($sql);
if ($result == 0)
{
echo "Error " . mysql_errno() . ": "
. mysql_error() . "";
}
else
{
?>
Variable_nameValue
";
$row_array = mysql_fetch_row($result);
for ($j = 0; $j < mysql_num_fields($result); $j++)
{
echo "" . $row_array[$j] . "";
}
echo "";
}
?>
But when I open it in my browser I get this error:
Fatal error: Call to undefined function mysql_connect() in C:\Program
Files\Apache Group\Apache2\htdocs\mysql_up.php on line 10
Could anyone of you smart people point me in the right direction? I'd be
pulling my hair out if I had any left :)
I can't make any progress with this study until I know my 3 programs are
talking to eachother properly, but my book gives no info on this error.
Thanks a millionfold for any advice, and I appologise for the length of
this post.
Sincerely,
Mike Rondeau
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Adding Up MySQL Results
I guess this is what you mean:
sum(quantity)*priceprice
450.00 15.00
479.99 29.99
... ...
is that right?
JeRRy wrote:
I run this mysql query: "select
sum(quantity)*price,price from sale
where dvd_id=1 group by price";
I get this result:
sum(quantity)*price price
450.00 15.00
29.99 29.99
I want to display the sum of the values in the first
column
(450.00+29.99), but I cannot figure out how to do
this! Can someone
clue me in?
// Multiplying with varaibles
$factorA = number_format(system_value('sum');
$factorB = number_format(system_value('price'), 0);
$product = $factorA + $factorB;
echo $product;
?>
Something like that?
You'll have to obviously play with this to make it
work for you. But calculations work like your Windows
Calculator number keypad.
+ = plus
- = minus
* = multiply
etc...
Look at these:
http://au.php.net/manual/en/function.number-format.php
http://au.php.net/round
J
Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP-DB] getting data back when inserting
The actual problem was the leading number in some of your arguments (4_h_1, 4_h_2, etc) Stefan > -Ursprüngliche Nachricht- > Von: Aaron Todd [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 1. Dezember 2004 18:33 > An: [EMAIL PROTECTED] > Betreff: Re: [PHP-DB] getting data back when inserting > > Thanks a bunch...thats exactly what I was looking for. > > Aaron > > > "Stefan" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > You should easily use > > mysql_insert_id(); > > otherwise you could use something like: > > SELECT max(id) FROM ... > > But I think the first command is what you're looking for. > > Stefan > > > > -Ursprüngliche Nachricht- > > Von: Aaron Todd [mailto:[EMAIL PROTECTED] > > Gesendet: Mittwoch, 1. Dezember 2004 17:01 > > An: [EMAIL PROTECTED] > > Betreff: [PHP-DB] getting data back when inserting > > > > I was wondering if somone might be able to suggest a command to me...I > am > > inserting data into a MySQL database that has an auto-incrementing > primary > > field. When I insert the data I would like to somehow get the value of > > the > > auto-incrementing primary field. I thought I could just run a SELECT > > statement on some of the data that I am inserting, but the problem is > that > > it could have a duplicate already in the database. > > > > Anyone know of a command or something to point me in the direction I am > > looking to go? > > > > Thanks, > > > > Aaron > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] getting data back when inserting
You should easily use mysql_insert_id(); otherwise you could use something like: SELECT max(id) FROM ... But I think the first command is what you're looking for. Stefan > -Ursprüngliche Nachricht- > Von: Aaron Todd [mailto:[EMAIL PROTECTED] > Gesendet: Mittwoch, 1. Dezember 2004 17:01 > An: [EMAIL PROTECTED] > Betreff: [PHP-DB] getting data back when inserting > > I was wondering if somone might be able to suggest a command to me...I am > inserting data into a MySQL database that has an auto-incrementing primary > field. When I insert the data I would like to somehow get the value of > the > auto-incrementing primary field. I thought I could just run a SELECT > statement on some of the data that I am inserting, but the problem is that > it could have a duplicate already in the database. > > Anyone know of a command or something to point me in the direction I am > looking to go? > > Thanks, > > Aaron > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: [EMAIL PROTECTED] November 2, 2004
To end up with this discussion: It is a piece of truth that the whole world is curious on what will happen during ( ;-) )and after the voting in the US but as the main part of the world has no effect on the election by using php this posting was obviously misplaced. Worst of all, this posting started a discussion WHICH IS MISPLACED ITSELF IN THE PHP.DB LIST. Gh wrote: and by the way the main reason we have problems in America * People with out health insurance [snip] THAT is one of the major reasons the rest of the world gets p*d of Americans ;) -- Lester Caine - L.S.Caine Electronic Services -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: php_mysql.dll fails to load
It appears as if the "php_mysql.dll" module has problems loading the "libmysql.dll" file. Setting the PHP dir to the system %path% var did NOT work for me. However, these options did: a) copy the bundled libmysql.dll to the windows system32 folder. b) OR, copy the bundled libmysql.dll to apache's BIN folder. c) OR, copy the bundled libmysql.dll to apache's root folder. I'm currently using option C, but I would prefer not having to copy DLL files across my system. Has anyone found a better solution? My Server Includes: * Microsoft WindowsXP SP2 * MySQL 4.0.21 * Apache 2.0.52 * PHP 5.0.2 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: php_mysql.dll fails to load
It appears as if the "php_mysql.dll" module has problems loading the "libmysql.dll" file. Setting the PHP dir to the system path var did NOT work for me. However, these options did: a) copy the bundled libmysql.dll to the windows system32 folder. b) OR, copy the bundled libmysql.dll to apache's BIN folder. c) OR, copy the bundled libmysql.dll to apache's root folder. I'm currently using option C, but I would prefer not having to copy DLL files across my system. Has anyone found a better solution? My Server: * Microsoft WindowsXP SP2 * MySQL 4.0.21 * Apache 2.0.52 * PHP 5.0.2 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PostgreSQL
M Saleh Eg wrote: Any Idea about where I'd get an installer version of PostgreSQL for windows? Wow, I recently had a project working on PostgreSQL. For local development we installed cygwin on WIN and tried to keep that working. How long does that installer exist? Nevertheless, thx for the link, I reported it to my successors on the project. Stefan Reimers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP - FOXPRO
The following excerpt is a result found on the internet. I am not the author of that text, but as it might help, here you go: >Here's the first part: > >http://php.weblogs.com/com_php > >Using COM from PHP to get to the ADO object model. ADO is an >abstraction of OLE DB funtionality. > >The second part is connecting to an OLEDB Provider for VFP: > >http://fox.wikis.com/wc.dll?Wiki~VFP_OleDB_Provider > >That should get you going. Good luck, Stefan Reimers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Abstraction Layer....
PHP knows at least three more: dba - for databases built on "Berkeley DB" which can be used some DB-configurations of MySQL dbm - also very specific for dbm-format, which seems not to be a relational one. Some apps seem to use that kind of DB internally. dbx - supports about a dozen types of RDBMS (e.g. PostgreSQL and Oracle, furthermore ODBC) and is very nice. I worked with it the last four months to write a flexible information system. Some comparisons can be found at: http://php.weblogs.com/Compare_PEAR_DB_ADOdb http://phplens.com/lens/adodb/ Stefan M Saleh Eg wrote: Anyone for a list of php abstraction classes? ADODB, PEAR::DB... any others? or better? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: SQLite problem INSERTing string
Hi again, first of all thanks for quick suggestions. After some more testing, I can get more specific: This might be a more general problem than the "." in the error message. Even when I use $val = "hello" I get an equivalent error message sqlite_query(): near "hello" As said, I have done all the quoting stuff, so \' instead of ' was no solution either, until I tried double quotes instead of single ones, just as M Saleh Eg suggested. So the following statement finally works: $query = "INSERT INTO node (uri,name) VALUES (\"$val\",\"\")"; Just for everybody else: SQLite does not support the SET statement in INSERTs, so INSERT INTO table SET attr=val would not work. Thx Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] SQLite problem INSERTing string
Hello,
I am currently experiencing a problem with an INSERT statement in SQLite.
First of all an excerpt from the code:
$val = "127.0.0.1";
$query = "INSERT INTO node (uri,name) VALUES (".$val.",'bla')";
$db_name = "mysqlite";
if($db_hdl = sqlite_open($db_name)){
$db_result = sqlite_query($db_hdl,$query);
}
I get the error message:
Warning: sqlite_query(): near ".": syntax error in
C:\Programme\xampp\htdocs\dipl\testclient\sqlite_test.php on line 10
I tried addslashes (which I know I shouldn't), sqlite_escape_string, any
variant of quotes etc, I asked google and the searched the news groups
but with no relevant result, except the insight, that others experience
the same so long unsolved problem or use a syntax in their tutorials
that does not work with my code...
As you an see from the error message, I use Windows, Apache, PHP4 with
SQLite in a 2.8.14 version.
If anyone has a clue, please contact me or just answer.
Thanks in advance
Stefan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] php-mysql problem
hello,
did you load the mysql module in your php.ini configuration file?
i.e. is the following line there:
extension=mysql.so
regards
On Thu, 13 May 2004 11:47:41 -0400
Jianping Zhu <[EMAIL PROTECTED]> wrote:
> have redhat 9.0 and Server version: Apache/2.0.40.
> i have installed rpms php-4.2.2-17.2.i386.rpm
>php-mysql-4.2.2-17.2.i386.rpm
>
>
>After i create a database called mydb and serveral tables in mysql,
>I tried to run following testdb.php script
>
>
>--
>
>
>$db = mysql_connect("localhost", "root","xx");
>mysql_select_db("mydb",$db);
>$result = mysql_query("SELECT * FROM employees",$db);
>printf("First Name: %s\n", mysql_result($result,0,"first"));
>printf("Last Name: %s\n", mysql_result($result,0,"last"));
>printf("Address: %s\n", mysql_result($result,0,"address"));
>printf("Position: %s\n", mysql_result($result,0,"position"));
>?>
>
>
>---
>
>but i got error message with:
>http://coopunit.forestry.uga.edu:8080/testdb.php
>the error is:
>Fatal error: Call to undefined function:
>mysql_connect() in /var/www/html/testdb.php on line 13
>
>How can Fix this problem? Thanks
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Fw: informix problem
i have winnt 4.0 servicepack 6 + apache 2.0.47 + php 430 + informix client for nt ilogin demo works fine sql editor works fine but when i try to connect to informix via php i'get an error like Warning: ifx_connect(): E [SQLSTATE=S1 001 SQLCODE=-406] i have informix server 2000 installed on other (unix) machine. i have 256MB memory and 20 GB hard (6GB free) what should i do? Bogdan IncrediMail - Email has finally evolved - Click Here
[PHP-DB] php / xml
hello i'm trying to make a pattern for an economic document using xml ex 2 .. i need a class that work with this kind of document fast an that can transform it quickly in html ps: do you think it is a good aproach thank you sbogdan IncrediMail - Email has finally evolved - Click Here
[PHP-DB] setcookie
Hi!
(I'm using php3 on an apache-server)
I'm doing lika a shoppingcart where the user can put items.
By some reason, when I use setcookie, I can only save between 14-17 posts.
Example:
setcookie("items", item1);
setcookie("items", item2);
...
setcookie("items", item17);
After this it will not save any more items.
It seems to get full..?
NE1 had experience with this?
Or if you have a different and better way to store many
items on the server for a user they are most welcome!
Thanx!
//Stefan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: NotesSQL via ODBC in PHP
Hi MH, thanks for your comment, but it seems the NotesSQL-driver is basically fine, as I vcan access the Notes-DB from QTODBC, Access and others, but NOT from php. Do you anybody involved in the ODBC development? Thanks Steve Mh schrieb: Steve, I have used NotesSQL succesfully to MS Access and MS SQL, but not with PHP. The NotesSQL gives you a very basic SQL function set and to my opinion its not even worth trying it. This was with Notes 4.5.2. It could be better in later versions, I don't know. ODBC works fine, I have connect PHP to MS Access, MS SQL and and even XLS files. MH "Stefan Haas" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Has anybody tried to read/write a Lotus Notes Database via ODBC (NotesSQL)? I don't even get a valid connection with odbc_connect. With other tools (QTODBC) NotesSQL/ODBC is no problem at all. Anything wrong with the php ODBC driver in php 4.2.3 under Win2k? Are ther more reliable ODBC drivers? Thanks Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] NotesSQL via ODBC in PHP
Has anybody tried to read/write a Lotus Notes Database via ODBC (NotesSQL)? I don't even get a valid connection with odbc_connect. With other tools (QTODBC) NotesSQL/ODBC is no problem at all. Anything wrong with the php ODBC driver in php 4.2.3 under Win2k? Are ther more reliable ODBC drivers? Thanks Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] BinaryWrite in PHP?
Hi! I want to let the user to be able to open or save a textdocument with text that I create on the fly with some select-statements. You know when you click on a button or a link and you get a question if you what to Open the file or or Save it. In ASP I can use Response.BinaryWrite, how can I do it in PHP? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: passing variables through frames
And how does it work? -- "Matt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Nevermind everyone... I found out. > > Thanks > > "Matt" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Does anyone know how to pass a variable to a different frame? For > example, > > I have a navigation frame, and when you click a link, it opens inside a > > different frame. Can anyone tell me if there is a way to pass variables > > from the navigation frame to the main frame? Thanks a lot. > > > > Matt > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] php/mysql problem
hi,
i've a problem with php and mysql.
a mysql-server is running on my server on that i can access from 'outside'.
but, if i want to connect to the server with a 'local' php skript (running
on the same server), mysql refuses the login ('acces denied for user
[...]'). the problem is that the login i use in the php skript is exactly
the same as the one i use for connecting from 'outside'.
another strange thing is that the php skript can connect to other mysql-dbs
on other servers...
is it a config-problem ? i've no idea anymore...
Stefan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] DB-stored images
Title: DB-stored images
Hi!
I have a db where we stores images in the database but I haven't figured out how I display
that image after I've selected it from the table.
I've tried with and but $data just return the Select-query:
Picture
Anyone have an idea what I can do?
Thanks!
Here is the script:
=
$handle = ORA_LOGON("something/something","") OR DIE("Unable to connect to database");
print "\n";
print "\n";
if ($type == Author){
$SqlStatement = "SELECT ...";
} else if ($type == Titel){
$SqlStatement = "SELECT ...";
} else if ($type == Picture) {
$SqlStatement = "SELECT PICTURE FROM KATALOGUE WHERE ISBN = '$isbn'";
}
$csr = ORA_OPEN($handle) OR DIE("Unable to open data database cursor");
ORA_PARSE($csr, $SqlStatement)OR DIE("Unable to parse query");
ORA_EXEC($csr) OR DIE("Unable to run query");
print "$type\n";
while(ORA_FETCH($csr)){
$data = "">
if ($type == Picture){
print "\n";
} else {
print "$data\n";
}
}
print "\n";
ORA_CLOSE($csr);
ORA_LOGOFF($handle);
?>
//Stefan
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Linux + Apache + freetds + MsSQL 7.0
hi there,
i have a 'little' problem:
i am using the system above and select queries work fine.
but i have problems to insert records into the db, even if the
generated queries from the script works fine if you try them with
the microsoft sql manager.
i eliminated all critical fields in the insert operations like
datefields etc.
theres no error message at all and i do not understand why
mssql_query($insertQuery) returns always FALSE
an example:
INSERT INTO Adressen (Datenbank, Bereich, Quelle, Unterquelle,
Kundennummer, Anrede, Vorname, Nachname, Anschrift, Land, PLZ, Ort,
Newsletter) VALUES ('x', 'x', 'x', 'x', 'x', 'm', 'stefan', 'kisker',
'...', 'D', '1', 'stadt', 'n')
best regards,
stefan
--
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]
[PHP-DB] Row order
Hello! I have this little problem sorting a search result by different fieldnames. I do my search, get a quite impressive amount of variables that I use in my MySQL-query, and by default use "ORDER BY name". But I want to be able to klick on different headers to sort like "ORDER BY $order". The problem that I encounter is that I lose all the variables from the search when I refresh the document. Is it possible to resend all variables without inserting them in the -tag ? (like ) Hopefully someone has a smart solution.. =) regards - Stefan -- 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]
AW: [PHP-DB] PHP4-ODBC-MSSQL7
Hi, I'm not sure about the probeme you have, but if the probleme is based on ODBC, why do use ODBC? You could also use the Sybase-Ct libs.. should work also with MSSQL... Greetings, Stefan -Ursprüngliche Nachricht- Von: Michael Yevdokimov [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 10. Juli 2001 13:09 An: [EMAIL PROTECTED] Betreff: [PHP-DB] PHP4-ODBC-MSSQL7 Hello Everyone!! We are making on the project with PHP4 and MSSQL7. Everything is based on NT4 platform. Certainly, in this case we are operating by SQL stored procedures. The question is.. I found some problems while extracting data from database over ODBC which we need to use to make a bridge between PHP and MSSQL. For example, we created a table with columns: col_subj_id int col_subj_owner_id int col_subj_last_update timestamp(8) col_subj_title varchar(512) col_subj_content text(16) col_subj_keywords varchar(256) col_subj_secur int col_subj_reg_page varchar(128) Then I try to execute a stored procedure usp_get_subj: Create Procedure usp_get_subj ( @subj_id int ) As SELECT * FROM tbl_subject WHERE col_subj_id = @subj_id RETURN Well, everything is working in Query Analyzer and in ASP but not in PHP... If obviously to define the column names like: SELECT col_subj_id, col_subj_owner_id, col_subj_last_update, col_subj_title, col_subj_content, col_subj_keywords, col_subj_secur, col_subj_reg_page FROM tbl_subject WHERE col_subj_id = @subj_id it will not be working either... But! If to order the columns in the query of the stored procedure by data types like: SELECT col_subj_id, -- int col_subj_owner_id, -- int col_subj_secur, -- int col_subj_last_update, -- timestamp(8) col_subj_title, -- varchar(512) col_subj_reg_page, -- varchar(128) col_subj_keywords, -- varchar(2560 col_subj_content -- text(16) FROM tbl_subject WHERE col_subj_id = @subj_id everything will be working pretty good.. WHY? Do you have any ideas on this subject? ;-) Hope to obtain help from your side.. Thank you in advance. Mike P.S. The friend of mine who is ASP programmer just told me that there was such a problem with the old versions of ODBC. I am not sure but I am afraid that the PHP's ODBC support is aimed on that old ODBC driver. Could anyone advice me anything on this subject please? Michael Yevdokimov Web developer e-mail: [EMAIL PROTECTED] Globalocity B.V. Tel.: +31 (0)70 312 2814 Fax.: +31 (0)70 312 2808 http://www.globalocity.com e-mail: [EMAIL PROTECTED] -- 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] -- 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]
AW: [PHP-DB] image resizing
There are several possibilities to do this... first PHP has the possibility to use the GD - Libs (which doesn't support Gif's because of licence problems). The second (and in my opinion better) posibility is ImageMagick which are some programs to modify pictures (you have to call them externaly from your php - scripts) (www.imagemagick.org). I think, I have seen several Tutorials to do so (PHP/ImageMagick) but on the fly.. I don't find them in my bookmarks now... Hope this helps, Stefan Siefert -Ursprungliche Nachricht- Von: Adv. Systems Design [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 9. Juli 2001 16:04 An: [EMAIL PROTECTED] Betreff: [PHP-DB] image resizing Is there a way of sizing image resolution on the fly? TIA Luis __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- 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] -- 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]
[PHP-DB] mysql_query returns nothing?
Hm, since we are using PHP 4.0.6 we do get sometimes no returnvalue...(function mysql_query) I think, this is always then, when we are executing update oder delete syntax hm, does anyone know anything about it? Stefan Siefert -- 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]
AW: [PHP-DB] newbie: Trying to select a database in php
Try it with mysql_select_db($database,$connect) instead of
msql_select_db($database,$connect) :-)
msql is a different Database System (in general, it is a lot older than
mysql I think)
Stefan
-Ursprüngliche Nachricht-
Von: Paul Lockyer [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 20. Juni 2001 10:07
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] newbie: Trying to select a database in php
Im using win2k and php to retrieve and dipslay database records, however
whenever the page is loaded in a browser I get the following error (the line
in question is in bold)
Fatal error: Call to undefined function: msql_select_db() in
D:\ASP\test\php\default.php on line 18
The code I am using is below
";
echo "DVD Title";
while($row = mysql_fetch_array($sql_result)){
$title = $row["main_title"];
echo "$title";
}
echo "";
mysql_free_result($sql_result);
mysql_close($connection);
?>
Any help would be appreciated
--
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]
AW: [PHP-DB] mssql_connect() function not found when I load the page...
You need to uncomment the mssql.dll (or something called like this) in your php.ini (In the section Windows DLL's). Greetings, Stefan -Ursprüngliche Nachricht- Von: lwneo [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 20. Juni 2001 06:21 An: [EMAIL PROTECTED] Betreff: [PHP-DB] mssql_connect() function not found when I load the page... Hi, I am running PHP with apache as server at Windows 98 platform. When I open a page I write that will connect to Microsoft SQL Server 7.0 in my intranet, I get the error : mssql_connect( ) function not found. Could someone tell me how to solve this problem? Thanks. lwneo. -- 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] -- 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]
AW: [PHP-DB] Connection to AS/400.
Also if ODBC isn't native for linux (not yet) there are several ports (or Projects) for linux the best I know is unixODBC (www.unixODBC.org), but there is also the iodbc project (www.iodbc.org). Last but not least, is there a company which sells ODBC solutions and support them (www.openlinksw.com). The support is very usefull!! Greetings, Stefan Siefert -Ursprüngliche Nachricht- Von: Nicolas Machado [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 7. Mai 2001 21:36 An: [EMAIL PROTECTED] Betreff: [PHP-DB] Connection to AS/400. OK, I have Linux, Apache and PHP, somebody knows if exist something like ODBC to connect to DB2/400. I mean, exist ODBC for linux? Thank for all. Best Regards --- Este Mail NO contiene Virus. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.251 / Virus Database: 124 - Release Date: 26/04/01 -- 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] -- 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]
[PHP-DB] Oracle 8i + PHP4: character set
Hello, I do have a little tiny problem with the character set. If I try to insert a word containing an german umlaut by a php-script, Oracle strips the seventh bit. I.e. "ä" becomes a "d". In PHP the SQL statement is written correctly. Facts: 1. I use Oracle 8i. The DB is made with the we8iso8859p1 option. 2. The NLS_LANG is set to GERMAN_GERMANY.WE8ISO8859P1 3. SQLPLUS works fine. What else could be wrong? If somebody has experience please answer. Stefan -- 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]
AW: AW: AW: [PHP-DB] configure with sybase-ct option
ok let's see take those: ftp://ftp.metalab.unc.edu/pub/Linux/ALPHA/freetds/freetds-0.51.tgz and compile them... in your configure script of php, you enter --with-sybase-ct=/your/freetds/installpath Greetings, Stefan Siefert -Ursprungliche Nachricht- Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 27. April 2001 11:07 An: Stefan Siefert; [EMAIL PROTECTED] Betreff: Re: AW: AW: [PHP-DB] configure with sybase-ct option OK. But we're running on Solaris. At 11:11 AM 4/27/01 +0200, Stefan Siefert wrote: >Normaly, they are shipped with the database, you try to connect to... but if >you don't have them you could get them from: >www.php.net/extra/ctlib-linux-elf.tar.gz > >Stefan Siefert > >-Ursprungliche Nachricht- >Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]] >Gesendet: Freitag, 27. April 2001 10:58 >An: Stefan Siefert; [EMAIL PROTECTED] >Betreff: Re: AW: [PHP-DB] configure with sybase-ct option > > > >You mean I need to install the sybase-ct libraries before I configure PHP? >Where can I get them? > >Thanks, >Lester > >At 10:58 AM 4/27/01 +0200, Stefan Siefert wrote: > >Do you have the sybasect - libraries installed??? You need to have them > >installed in order to compile PHP succesfully! > >Also, if you have sybase-ct installed, specify the path > >with: --with-sybase-ct=/path/to/sybasectlibs > > > >Hope this helps, > > > >Stefan Siefert > > > >-Ursprungliche Nachricht- > >Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]] > >Gesendet: Freitag, 27. April 2001 10:38 > >An: [EMAIL PROTECTED] > >Betreff: [PHP-DB] configure with sybase-ct option > > > > > > > >I tried to configure PHP4.0.2 with sybase-ct support. But I got this error > >when running "make install" > > > >In file included from internal_functions.c:33: > >/export/home/lester/php-4.0.2/ext/sybase_ct/php_sybase_ct.h:58: ctpublic.h: > >No such file or directory > > > > > >I used the following commands: > > > > ./configure --with-nsapi= > > --enable-libgcc > > --with-mysql=/usr/local/mysql > > --enable-track-vars > > --enable-short-tags > > --enable-asp-tags > > --with-sybase-ct > > make > > make install > > > > > >Did I miss anything? Or should I download the latest version and install >it? > > > >Thanks, > >Lester > > > > > > > >- > >Lester June Cabrera > >Chief Web Programmer > >I-Quest Corporation > > > >Tel: (632) 867 8150 local 301 or 302 > >Fax: (63 2) 867 8077 > >E-mail: [EMAIL PROTECTED] > > > >Visit the most comprehensive on-line business travel resource at > >http://www.worldroom.com > > > >Successful events start here. Visit http://www.worldroomevents.com . > >The one-stop online exchange for event planners and suppliers to the MICE > >industry. > > > > > >-- > >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] > > > > > > > >-- > >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] > > >-- >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] - Lester June Cabrera Chief Web Programmer I-Quest Corporation Tel: (632) 867 8150 local 301 or 302 Fax: (63 2) 867 8077 E-mail: [EMAIL PROTECTED] Visit the most comprehensive on-line business travel resource at http://www.worldroom.com Successful events start here. Visit http://www.worldroomevents.com . The one-stop online exchange for event planners and suppliers to the MICE industry. -- 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] -- 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]
AW: AW: [PHP-DB] configure with sybase-ct option
Normaly, they are shipped with the database, you try to connect to... but if you don't have them you could get them from: www.php.net/extra/ctlib-linux-elf.tar.gz Stefan Siefert -Ursprungliche Nachricht- Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 27. April 2001 10:58 An: Stefan Siefert; [EMAIL PROTECTED] Betreff: Re: AW: [PHP-DB] configure with sybase-ct option You mean I need to install the sybase-ct libraries before I configure PHP? Where can I get them? Thanks, Lester At 10:58 AM 4/27/01 +0200, Stefan Siefert wrote: >Do you have the sybasect - libraries installed??? You need to have them >installed in order to compile PHP succesfully! >Also, if you have sybase-ct installed, specify the path >with: --with-sybase-ct=/path/to/sybasectlibs > >Hope this helps, > >Stefan Siefert > >-Ursprungliche Nachricht- >Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]] >Gesendet: Freitag, 27. April 2001 10:38 >An: [EMAIL PROTECTED] >Betreff: [PHP-DB] configure with sybase-ct option > > > >I tried to configure PHP4.0.2 with sybase-ct support. But I got this error >when running "make install" > >In file included from internal_functions.c:33: >/export/home/lester/php-4.0.2/ext/sybase_ct/php_sybase_ct.h:58: ctpublic.h: >No such file or directory > > >I used the following commands: > > ./configure --with-nsapi= > --enable-libgcc > --with-mysql=/usr/local/mysql > --enable-track-vars > --enable-short-tags > --enable-asp-tags > --with-sybase-ct > make > make install > > >Did I miss anything? Or should I download the latest version and install it? > >Thanks, >Lester > > > >- >Lester June Cabrera >Chief Web Programmer >I-Quest Corporation > >Tel: (632) 867 8150 local 301 or 302 >Fax: (63 2) 867 8077 >E-mail: [EMAIL PROTECTED] > >Visit the most comprehensive on-line business travel resource at >http://www.worldroom.com > >Successful events start here. Visit http://www.worldroomevents.com . >The one-stop online exchange for event planners and suppliers to the MICE >industry. > > >-- >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] > > > >-- >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] -- 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] -- 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]
AW: [PHP-DB] configure with sybase-ct option
Do you have the sybasect - libraries installed??? You need to have them installed in order to compile PHP succesfully! Also, if you have sybase-ct installed, specify the path with: --with-sybase-ct=/path/to/sybasectlibs Hope this helps, Stefan Siefert -Ursprungliche Nachricht- Von: Lester June Cabrera [mailto:[EMAIL PROTECTED]] Gesendet: Freitag, 27. April 2001 10:38 An: [EMAIL PROTECTED] Betreff: [PHP-DB] configure with sybase-ct option I tried to configure PHP4.0.2 with sybase-ct support. But I got this error when running "make install" In file included from internal_functions.c:33: /export/home/lester/php-4.0.2/ext/sybase_ct/php_sybase_ct.h:58: ctpublic.h: No such file or directory I used the following commands: ./configure --with-nsapi= --enable-libgcc --with-mysql=/usr/local/mysql --enable-track-vars --enable-short-tags --enable-asp-tags --with-sybase-ct make make install Did I miss anything? Or should I download the latest version and install it? Thanks, Lester - Lester June Cabrera Chief Web Programmer I-Quest Corporation Tel: (632) 867 8150 local 301 or 302 Fax: (63 2) 867 8077 E-mail: [EMAIL PROTECTED] Visit the most comprehensive on-line business travel resource at http://www.worldroom.com Successful events start here. Visit http://www.worldroomevents.com . The one-stop online exchange for event planners and suppliers to the MICE industry. -- 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] -- 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]
AW: [PHP-DB] Connecting and Viewing a Database
Maybe you tell us, which system you are running, like linux, or windows. If you use linux you should try to use unixODBC (Tutorial for uinxODBC and PHP: www.unixODBC.org).. If you use windows, it should be done by uncommenting the odbc-library in php.ini like: extension=php_odbc.dll Greetings, Stefan Siefert -Ursprüngliche Nachricht- Von: Anyangwe, Tanwani [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 27. März 2001 17:49 An: '[EMAIL PROTECTED]' Betreff: [PHP-DB] Connecting and Viewing a Database Does anyone know how to connect and display table rows from an ODBC source MS Access & MySQL databases? -- 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] -- 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]
AW: [PHP-DB] Structure Question
I think you should store all files in a table with an extra table with the filetypes (like you suggest in the end of your mail)!! In my opinion this is a well designed database modell, 'cause you have only one table (instead of 10 or twelve depending on the count of your datatypes), but you are able to select over the filetyp criteria!! Stefan Siefert -Ursprüngliche Nachricht- Von: Jordan Elver [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 27. März 2001 14:38 An: PHP Database Mailing List Betreff: [PHP-DB] Structure Question Hi, I want to keep filenames of different kinds of media(real sudio, qt, mp3) for articles in a db table. Would it be best to store each kind of media in a different table like one table for real audio, one for quicktime, one for mp3. Or, would it better to store them all in the same table but with another table telling me what kind of file it is? Like: media table id | name | filename | type_id media types type_id | name Any ideas folks? Cheers, Jord -- 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] -- 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]
AW: [PHP-DB] Naming cookies
Hi Tristan,
I'm not sure about this, but try to use ob_start() at the beginning. This
tells php to execute the page in cache and put it to the client when it's
execution is finish. It enables you, to use cookies not only before html,
but from every position in html... maybe this works...
Stefan Siefert
-Ursprungliche Nachricht-
Von: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 13. Marz 2001 16:52
An: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Betreff: [PHP-DB] Naming cookies
Afternoon guys and girls
I have a queston regarding cookies...
I have a login form that takes the member name and password from a MySQL
Database.
I have three fields:
member
pw
userlevel
I want to set a cokkie to remember the user and thier user level, so I named
the
cookie - authlevel$userlevel --- as I have three levels of security
access,
I opted for a dynamic cookie name,that changed depending on thier userlevel.
Can I include a variable in the cookie name?
I am having probs getting this to work correctly, and this is my first guess
as
to why it isn't working.
I have included two codes, the first is my login script, and the second is
on my
secure pages above the head tag.
If anyone can spot my error, I'll gladly furnish them with a beer and a
toblerone.
Thanks in advance,
Tris...
http://www.mysite.com");
exit;
}
$db_name = "my_database";
$table_name = "userlist";
$connection = @mysql_connect("my_database_host", "my_username",
"my_password")
or die("Couldn't connect.");
$db = mysql_select_db($db_name, $connection)
or die("Couldn't select database.");
$sql = "SELECT * FROM $table_name
WHERE member = \"$member\" AND pw = \"$pw\"
";
$result = mysql_query($sql)
or die ("Can't execute query.");
while($row = mysql_fetch_array($result)) {
$userlevel = $row['userlevel'];
$member = $row['member'];
$pw = $row['pw'];
}
$num = mysql_numrows($result);
if (($num != 0) && ($userlevel = '1') || ($userlevel = '2') || ($userlevel =
'3')) {
$cookie_name = "authlevel$userlevel";
$cookie_value = "ok";
$cookie_expire = "";
$cookie_domain ="";
setcookie($cookie_name, $cookie_value, $cookie_expire, "/", $cookie_domain,
0);
$display_block ="
You are now logged into STN TreasuryYou are logged in under
the
mail address, $member, you can now access the site as per your
assigned
access level $userlevel.Link to level
1Link to level 2Link to level 3
";
} else {
header("Location: http://www.mysite.com");
exit;
}
?>
==
Hello, and welcome to level 1 of the secret test area...";
} else {
header( "location:http://www.mysite.com");
exit;
}
?>
===
**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
**
--
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]
--
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] PHP Bug or configuration error?
Hi Pierre... I think the problem is, that you have configured php as cgi-apliction, and not as an ISAPI module. I'm not sure how to configure PHP this way (cause we run only linux - server, and no IIS..) but this should be the problem. Greetings, Stefan Siefert >Hallo listmembers, >i have a misterious error with php4.0.4 on windows-2000. If i call a script >this lines will be displayed in the Adress-Part of my Browsers (IE5.0 & >Netscape 4.75/6): >http://localhost/php/php.exe/test/funwin/normal.php3?show=10 >I dont know why "/php/php.exe" is in the Adress. I hope somebody could help >me. -- 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]
[PHP-DB] Really strange behaviour of PHP with Sybase ASE 11.9.2 + ODBC + Linux
Hi there... I have experienced really strange behaviour of PHP and Sybase. Our configuration: Linux (Suse Linux 7.0), Apache 1.3.17, PHP 4.0.4pl1, Sybase ASE 11.9.2 on an Linux Box, unixODBC with a Sybase ODBC - Driver. It was hard work, to get this working, but after some time we got it running. Running means, that we were able to connect to an Sybase Database over ODBC. Then we copied a PHP - Website (developed under Windows, Sybase ASE 11.9.2 ODBC) into the webroot. Well, we expected somme problems, but not the things we found: Some pages loaded without any problems, but some more complex-scripts would crash php. Crash php means, that the scripts produced segmentation faults (Entries in the error log file like pid 15978: Segmentation Fault). Any Ideas what could crash php when the same scripts works with windows??? Thx, Stefan Siefert P.S.: If you have any questions, feel free to mail :-)) -- 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]
[PHP-DB] unixODBC and Sybase ASE 11.9.2 on a linux box
Hi, we are trying the above combination, but we do not find any hints how (which?) we configure an ODBC - Driver for Sybase in an odbc.ini file... if anyone has experience with this combination we would be very glad if you could post a small overview or a source, where we can find informations about this combination... thx Stefan Siefert -- 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]
AW: [PHP-DB] PHP 4.04 install binary Win32 and MSQL 7.0
I'm not 100 % sure (cause we don't use the win binaries) but I think I can remember that you have to uncomment some lines in the php.ini file. There should be a section with database modules like oracle odbc or somethink like this. try to uncomment the sybase module. Hope this works, Greetings Stefan -Ursprungliche Nachricht- Von: Come Italia s.r.l. - Webmaster [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 18. Januar 2001 16:05 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: [PHP-DB] PHP 4.04 install binary Win32 and MSQL 7.0 I've installed and correctly configured (I suppose) the binary version of PHP 4.04 on a Win NT server with Microsoft IIS. I'm using CGI version of IIS. when I try to connect my script with Microsoft SQL 7.0 DB I get this error "Fatal error: Call to undefined function: sybase_pconnect() in ./db/sybase.php on line 17" This means that the binary version of PHP doesn't support SQL 7.0?? Must I compile the source code of PHP? Thanks a lot Luca -- 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]
AW: [PHP-DB] SQL coloring in BBEdit 6.0?
Try Multiedit or Ultraedit.. this are Editor's which can be taught to highlight Syntax.. you only need a config - file for the programing language you need. Greetings, Stefan -Ursprüngliche Nachricht- Von: Rubanowicz, Lisa [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 16. Januar 2001 16:03 An: 'Michael Zornek'; [EMAIL PROTECTED] Betreff: RE: [PHP-DB] SQL coloring in BBEdit 6.0? Hi All, I am new to PHP and am using TextPad 4.0 at the moment but it doesn't colour code PHP. Can anyone recommend a Text Editor that does this. The BBEdit is only for Mac. Thanks for your help All the Best Lisa -Original Message- From: Michael Zornek [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 16, 2001 2:51 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP-DB] SQL coloring in BBEdit 6.0? Hello, I'm using BBEdit 6.0.2 to do some PHP. I love the way it colors the PHP commands differently. I also do mySQL. I usually write up a whole list of SQL statements in a text editor and then feed them into the server. Is there a way to have BBEdit color code the mySQL commands that same way it does HTML and PHP? Thanks Mike -- Mike Zornek, Web Development Seybold Publications 428 East Baltimore Avenue P.O. Box 644 Media, PA 19063, USA http://www.seyboldreports.com Phone: (610) 565-2480 x131 Fax: (610) 565-4659 Email: [EMAIL PROTECTED] -- 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] -- 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]
[PHP-DB] OCI8 and Listener
Hi, i've compiled my php modul with oci8.But I can't connect to my db. It tells me the error ORA-12162. In the documentation there is no such error mentioned. Do I need to start to Oracle listner? Is tere somebody who had solved this problem in the past? Thanks Stefan -- 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]
