[PHP-DB] New Member
Hi, this is my first post on this list. I've never used PHP, but I'm interested in exploring it, along with MySQL and Apache server software. Very briefly, my main focus is on designing webpages. I've been unemployed for several months and have been using my extra time to learn new computer skills, primarily Dreamweaver and Cascading Style Sheets. I'm working with Windows XP, but I'd like to get away from Windows eventually. I got Linux installed on my computer a couple months ago, but I haven't found time to learn it yet. Then I apparently forgot part of my password, so I'm locked out! So I'm going to stick with the Windows platform for now. I started downloading MySQL just today, when one of your members recommended I join this list. He also recommended Apache, so I checked it out and discovered that you can download pre-configured packages of PHP, MySQL and Apache at http://www.hotscripts.com/PHP/Software_and_Servers/Installation_Kits/ So here are my first questions: 1. Which package should I download - the first one (Firepages phpdev)? 2. Since this is all new to me, I don't want to do anything that will somehow screw up my other software. I don't really understand servers and would like to ask if installing Apache will give me two servers, or will it replace IIS? I just want to make sure I can continue previewing my webpages and was concerned that I might somehow screw things up if I install Apache wrong. Eventually, it would probably be nice to have Apache software up and running on a Linux platform and use IIS on the Microsoft platform when necessary. Finally, here's an example of my immediate goal, which I understand would involve MySQL and PHP: http://www.geobop.com/marini/2.htm I want to create really nice, interactive tables featuring information on the world's nations and animals. I posted the questions on this page to a Dreamweaver group, but they indicate where I'm headed. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] mysql, php, mp3 - a variable problem
hi, i put a script together to scan a directory and its subdirectories for all mp3 files. the tag informations and path then should be put into a mysql database. i included a script called mphp3.php from http://res.crea-bmb.de/mphp3/ which returns the needed tag info from one file. the script to recursively scan a dir i got from groups.google. using the mphp3.php with one file is simple (demo from website): ? include(mphp3.php); $info = New mphp3(2); $info-load(test.mp3); echo $info-title. is a nice song. it's encoded with.$info- bitrate.kbps.; ? my code to include the db: ? include(mphp3.php); mysql_connect(192.168.100.12,user,password) or die (no connect to db); mysql_select_db(music) or die (db does not exist); function scan_dir($dir) { $info = New mphp3(2); $handle = @opendir($dir); while ($file = @readdir ($handle)) { if (eregi(^\.{1,2}$,$file)) { continue; } if(is_dir($dir.$file)) { scan_dir($dir.$file./); } else { $info-load(/.$dir.$file); $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); } } @closedir($handle); } scan_dir(mp3/); ? but all it does is to put the path ($dir) into the database. everything else is ignored. an error does not occur. since the simple demo works fine i think its a problem with the validity of variables. i'm new to php, so could anybody give me a hint on what mightbe wrong with my code please? thanx a lot -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql, php, mp3 - a variable problem
Hi, Where do you get $info2 from? I only see $info in this function. .: Allowee function scan_dir($dir) { $info = New mphp3(2); $handle = @opendir($dir); while ($file = @readdir ($handle)) { if (eregi(^\.{1,2}$,$file)) { continue; } if(is_dir($dir.$file)) { scan_dir($dir.$file./); } else { $info-load(/.$dir.$file); $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); } } @closedir($handle); } scan_dir(mp3/); ? but all it does is to put the path ($dir) into the database. everything else is ignored. an error does not occur. since the simple demo works fine i think its a problem with the validity of variables. i'm new to php, so could anybody give me a hint on what mightbe wrong with my code please? thanx a lot -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] ?? php and mysql database question ??
Hello, I have a question, not sure if what I am looking for is available at all or a smaller program of the full sized program I am looking for but thought I'd ask to see if anyone knows of a program or a program they may of created. On my personal Computer I run a Windows OS and on my server (located elsewhere) I run a linux OS. Now on my server I have PHP 4.0 installed as well as mysql database installed. But I am not always available online to update the website/databse and wondered if there is a way to do updates/tests my my personal computer. Test them offline and put them live when I am happy with it. The thing is on my personal computer I run a Windows OS and was wondering if there is a program I can install to have mysql database or a similar program to mysql database to run my scripts offline? I already have installed a PHP program that I can run/test PHP scripts and thought I'd ask here if anyone knew of a mysql one. (I thought since a PHP program is available on Windows OS maybe a mysql one was too?) If anyone can help me that would be great. If not, it was worth a shot! If anyone has another idea of doing things offline let me know, I am all ears. (e.g. a similar database program to mysql I can download for Windows OS .. I don't mean MS ACCESS etc, needs to be linux like so I can test my scripts offline and make MINOR edits to get it to work with mysql. But would prefer a mysql program if available.) I need the program so I can test my PHP pages and do database changes to work with my PHP pages. As I do on my live website. (e.g. retrieve data from a database, and send data to a database. etc...) I'm not aware of a program for mysql on Windows OS but thought to ask here and see if any of you people do or know any in development. Thanks for your time in advance. Kind Regards, Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] ?? php and mysql database question ??
I already have installed a PHP program that I can run/test PHP scripts and thought I'd ask here if anyone knew of a mysql one. (I thought since a PHP program is available on Windows OS maybe a mysql one was too?) There is... http://www.mysql.com/ for more info .: Allowee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql, php, mp3 - a variable problem
hi allowee, sorry, this was not meant to be. $info2 is supposed to be $info. my fault. but that is not the actual problem. Hi, Where do you get $info2 from? I only see $info in this function. .: Allowee function scan_dir($dir) { $info = New mphp3(2); $handle = @opendir($dir); while ($file = @readdir ($handle)) { if (eregi(^\.{1,2}$,$file)) { continue; } if(is_dir($dir.$file)) { scan_dir($dir.$file./); } else { $info-load(/.$dir.$file); $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); } } @closedir($handle); } scan_dir(mp3/); ? but all it does is to put the path ($dir) into the database. everything else is ignored. an error does not occur. since the simple demo works -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql, php, mp3 - a variable problem
hmmm, maybe this code.. $info-load(/.$dir.$file); if $dir = mp3s and $file = test.mp3 then it will load '/mp3s/test.mp3' you got that directory? I've seen the class and you are hiding the fopen error message, which could be the problem. .: Allowee On Saturday 07 June 2003 11:11, Ole Hornauer wrote: hi allowee, sorry, this was not meant to be. $info2 is supposed to be $info. my fault. but that is not the actual problem. Hi, Where do you get $info2 from? I only see $info in this function. .: Allowee function scan_dir($dir) { $info = New mphp3(2); $handle = @opendir($dir); while ($file = @readdir ($handle)) { if (eregi(^\.{1,2}$,$file)) { continue; } if(is_dir($dir.$file)) { scan_dir($dir.$file./); } else { $info-load(/.$dir.$file); $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); } } @closedir($handle); } scan_dir(mp3/); ? but all it does is to put the path ($dir) into the database. everything else is ignored. an error does not occur. since the simple demo works -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
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] mysql, php, mp3 - a variable problem
On Saturday 07 June 2003 11:20, Allowee wrote: hmmm, maybe this code.. $info-load(/.$dir.$file); if $dir = mp3s and $file = test.mp3 then it will load '/mp3s/test.mp3' you got that directory? I've seen the class and you are hiding the fopen error message, which could be the problem. .: Allowee hmmm. that won't work.. you can try $info-load(./.$dir./.$file); or simple.. $info-load($dir./.$file); .: Allowee -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql, php, mp3 - a variable problem
well, you are right. the dir '/mp3' does not exist. 'mp3' is a subdir from my htdocs dir. so i think the right path should be 'mp3/someartist/somesong', right? i fixed that, but the original problem is still the same :( hmmm, maybe this code.. $info-load(/.$dir.$file); if $dir = mp3s and $file = test.mp3 then it will load '/mp3s/test.mp3' you got that directory? I've seen the class and you are hiding the fopen error message, which could be the problem. .: Allowee On Saturday 07 June 2003 11:11, Ole Hornauer wrote: hi allowee, sorry, this was not meant to be. $info2 is supposed to be $info. my fault. but that is not the actual problem. Hi, Where do you get $info2 from? I only see $info in this function. .: Allowee function scan_dir($dir) { $info = New mphp3(2); $handle = @opendir($dir); while ($file = @readdir ($handle)) { if (eregi(^\.{1,2}$,$file)) { continue; } if(is_dir($dir.$file)) { scan_dir($dir.$file./); } else { $info-load(/.$dir.$file); $query =insert into mp3 ( file, path, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] mysql, php, mp3 - a variable problem
moin, sorry, my php-knowledge is not the best. what do you mean with formfieldvalues? i think $info-value is used to get the id3-tag info from the class, right? this worked for me in a more simple way without the recursive scan: ? include(mphp3.php); $info = New mphp3(2); mysql_connect(192.168.100.12,user,password); mysql_select_db(music); $info-load(test.mp3); $abfrage =insert into mp3 ( file, artist, title, album) values ( '$info-filename', '$info-v2_artist', '$info-v2_title', '$info-v2_album');; mysql_query($abfrage); ? 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
[PHP-DB] Re: ?? php and mysql database question ??
hi, u can install vmware (not freeware) on your windows machine and then install linux as a virtual machine. it behaves just like a real machine. works fine for me! Hello, I have a question, not sure if what I am looking for is available at all or a smaller program of the full sized program I am looking for but thought I'd ask to see if anyone knows of a program or a program they may of created. On my personal Computer I run a Windows OS and on my server (located elsewhere) I run a linux OS. Now on my server I have PHP 4.0 installed as well as mysql database installed. But I am not always available online to update the website/databse and wondered if there is a way to do updates/tests my my personal computer. Test them offline and put them live when I am happy with it. The thing is on my personal computer I run a Windows OS and was wondering if there is a program I can install to have mysql database or a similar program to mysql database to run my scripts offline? I already have installed a PHP program that I can run/test PHP scripts and thought I'd ask here if anyone knew of a mysql one. (I thought since a PHP program is available on Windows OS maybe a mysql one was too?) If anyone can help me that would be great. If not, it was worth a shot! If anyone has another idea of doing things offline let me know, I am all ears. (e.g. a similar database program to mysql I can download for Windows OS .. I don't mean MS ACCESS etc, needs to be linux like so I can test my scripts offline and make MINOR edits to get it to work with mysql. But would prefer a mysql program if available.) I need the program so I can test my PHP pages and do database changes to work with my PHP pages. As I do on my live website. (e.g. retrieve data from a database, and send data to a database. etc...) I'm not aware of a program for mysql on Windows OS but thought to ask here and see if any of you people do or know any in development. Thanks for your time in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] What must a (Windows) User do to query Oracle9i with oci8 functions
hi i already found this in this newsgroup: Hi Robert Yes oci8 functions work fine with Oracle9i. that's great :-) but someone said something about Recompiling to use oci8 extension with Oracle9i. So now my question: What tasks are requiered to query Oracle9i DB with the oci8-extension ? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Problems with OCIFetchStatement()'s $skip and $return?
Hi, I'm using OCIFetchStatement()'s undocumented parameter $return (http://de.php.net/manual/de/function.ocifetchstatement.php) to limit the number of rows fetched from a result set. Unfortunately, I sometimes get far less rows than expected. Before I further investigate the issue, can anyone confirm problems with using OCIFetchStatement()'s $skip and $return parameters? TIA, -sapporo. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] incrementing values
Hi there, is there a function in mysql to increment a value inside a field? I am always doing this with php, just thought this might be really usefull?! Thanx, Merlin -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] incrementing values
AUTO_INCREMENT http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Merlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, 03 June, 2003 17:56 Subject: [PHP-DB] incrementing values Hi there, is there a function in mysql to increment a value inside a field? I am always doing this with php, just thought this might be really usefull?! Thanx, Merlin -- 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] problem with insert query
hi i am wrote a script to read e-malis from a file and insert it into the tables of database i get error when i write it here is the code can anyone tell me what is wrong? ? $mails=file(mails.txt); $number_of_mails = count($mails); for ($i=0; $i$number_of_mails; $i++){ @ $db = mysql_connect(localhost); mysql_select_db(me2resh00); $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); $result = mysql_query($query); if ($result) echo mysql_affected_rows(). affected.; } ? here is the error that i get Parse error: parse error in enter.php on line 9 and line 9 is $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Displaying groups from SELECT
What I did to somewhat solve the problem of over calling mysql was to initiate the query outside the loop (SELECT prod_name query), put the results into an array and then use the array inside the while($cats) loop. For example, $sql=SELECT prod_name, cat_id FROM products; $result=mysql_query($sql, $conn); Be sure to get the cat_id too! The go through the results and create an associative array. I don't have my php book in front of me so I can't write out the code verbatim. Plus it's Saturday morning.. the alcohol hasn't left my brain from last night... :) Then, inside your while ( $cats = mysql_fetch_array( $result ) ) loop, you call your array and compare each line with some equality test on cat_id. That should do the trick. metin PS. there's probably an mysql query that could do what you want.. just can't think of it right now. On Fri, 06 Jun 2003 23:55:46 -0400 Becoming Digital wrote: Thanks, Gürhan, but I think I needed to explain things better. As is generally a good idea, the categories are referenced in the product table by ID, not name. Additionally, this is something along the lines of what I already had. I was trying to use only one query and make PHP do the remaining work. Here's the code I'm currently using, which I should have posted in the first place. ? $query = SELECT * FROM categories; $result = mysql_query( $query ); $rows = mysql_num_rows( $result ); print ul\n; while ( $cats = mysql_fetch_array( $result ) ) { print li .$cats[cat_name] ./li; $queryB = SELECT prod_name FROM products WHERE prod_cat= .$cats[cat_id]; $resultB = mysql_query( $queryB ); print ul; while ( $items = mysql_fetch_array( $resultB ) ) { print li .$items[prod_name] ./li; } print /ul; } print /ul; ? The more I think about it, the more it seems like I'll just have to use two queries. I just didn't want to do so bcs the second query will run at least four times and it seemed inefficient. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Gürhan Özen [EMAIL PROTECTED] To: Becoming Digital [EMAIL PROTECTED] Cc: PHP-DB [EMAIL PROTECTED] Sent: Friday, 06 June, 2003 23:07 Subject: Re: [PHP-DB] Displaying groups from SELECT On Fri, 2003-06-06 at 21:49, Becoming Digital wrote: I'm wearing the stupid hat today, so please pardon this. I know I must be overlooking something. I have a small catalogue with two tables (categories, products) from which I'm trying to display items. I'm trying to print the contents as below without using two queries, but I'm having a difficult time with it. cat1 prod1 prod2 cat2 prod1 prod2 etc. I think this came up fairly recently, but I cannot for the life of me figure out what search terms would answer this question. As you can see from the message subject, I don't even know how to refer to my problem. Thanks a lot for all your help. Edward Dudlik Becoming Digital www.becomingdigital.com Hi Ed, The magic word is DISTINCT :) $query=SELECT DISTINCT(category) AS cat_name FROM table_name; $result=mysql_query($query); print ul; while ($row=mysql_fetch_array($result)) { print li.($row[cat_name]).; $query1=SELECT productname FROM tablename WHERE category=.($row[cat_name]).; $result1=mysql_query($query1); while ($row1=mysql_fetch_array($result1)) { print li.($row1[productname]).; } print /ul; } print /ul; I hope this helps.. -- 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] SQL Server connection error.
Hi, I am new to PHP DB code and am currently struggling with the connection to SQL Server 2000. I am using ODBC and have created a System DSN with integrated NT security specifiying which DB etc. I have written the following code and posted it in the htdocs folder for Apache. (We are all running on Win2000 platforms, Web server is set apart from the DB server, but linked via LAN. PHP code: HEAD TITLEADODB Test in PHP/TITLE /HEAD BODY ?php // simple conection $cnx = odbc_connect('web', '', ''); //query $SQL_Exec_String = select * from TblClients; //ejecucion query $cur= odbc_exec( $cnx, $SQL_Exec_String ); echo table border=1trthDni/ththNombre/th. thcodigo/ththciudad/th/tr\n; while( odbc_fetch_row( $cur ) ) { $Title= odbc_result( $cur, 1 ); $Fname= odbc_result( $cur, 2 ); $Surname= odbc_result( $cur, 3 ); $Address1= odbc_result( $cur, 4 ); echo trtd$Title/tdtd$Fname/td. td$Surname/tdtd$Address1/td/tr\n; } echo /table; ? /BODY /HTML I then get back the following error: Warning: SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'PROTE\LATTITUDWEBSERV$'., SQL state 28000 in SQLConnect in C:\Apache\Apache2\htdocs\DBtest.php on line 9 Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\Apache\Apache2\htdocs\DBtest.php on line 10 DATA FROM SQL SERVER WITH PHP4 Cand_ID Password Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in C:\Apache\Apache2\htdocs\DBtest.php on line 14 Am at a loss as to why the error. Have created another DSN in same system which links in using VB to the same SQL Server using the same NT integrated security and it is fine, so I am a little perplexed. Any help or pointers would be gratefully received Best regards Russell _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] problem with insert query
Try this. I made some minor syntax changes and added some error reporting. While it may not fix things, it might help you figure out what's wrong. ? $mails=file(mails.txt); $number_of_mails = count($mails); for ($i=0; $i$number_of_mails; $i++) { $link = @ mysql_connect(localhost) or die( mysql_error() ); $db = mysql_select_db(me2resh00, $link); $query = insert into recipients (recipient_name, recipient_email) values (\friend\, \.$mails[$i].\); $result = mysql_query($query); if ($result) echo mysql_affected_rows(). affected.; } ? Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Ahmed Abdelaliem [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 07 June, 2003 08:15 Subject: [PHP-DB] problem with insert query hi i am wrote a script to read e-malis from a file and insert it into the tables of database i get error when i write it here is the code can anyone tell me what is wrong? ? $mails=file(mails.txt); $number_of_mails = count($mails); for ($i=0; $i$number_of_mails; $i++){ @ $db = mysql_connect(localhost); mysql_select_db(me2resh00); $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); $result = mysql_query($query); if ($result) echo mysql_affected_rows(). affected.; } ? here is the error that i get Parse error: parse error in enter.php on line 9 and line 9 is $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- 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] Possible to store arrays in mySQL without explode()/implode()
is it possible to store an array in mySQL without using implode() / explode(), like this: $stuff['blob'] = string; $stuff['hm'] = G-string; mysql_query(INSERT INTO table VALUES ($stuff)); and if, who must the mysql table be defined ? thx Jakob 'iNstinct' Mund -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Glitching install script.
I'm still new to php and my syntax is not great. I am getting this notice: Notice: Undefined variable: begin in /home/wwwfulc/public_html/install.php on line 21 When I hit subit it just prints Completed. and doesn't update the database at all. Can anyone help me find my glitch in this? You can see it in action here http://www.fulco.net/install.php You can see the whole file (minus html tags at beginning and end) here http://www.fulco.net/installphp.txt Here's the code (minus the SQL Dump). PHP: _ html head titleXenology Database Install Script/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 ?php error_reporting(E_ALL); require(xenosetup.php); $con = mysql_connect($host, $user, $pass) or die (I cannot connect to the database because: . mysql_error()); mysql_select_db($db, $con) or die(I cannot select the correct database because: . mysql_error()); if ($begin){ $sql = 'CREATE TABLE xeno(SQL DUMP HERE); echo Completed.; } else { printf(a href=\%s?begin=1\Begin/abr, $PHP_SELF); } ? /body /html _ Your help is appreciated! Yours in Service, Jason Britton Scar's http://st.fulco.net/ Legion [EMAIL PROTECTED] Vincit imitationem veritas.
Re: [PHP-DB] Possible to store arrays in mySQL withoutexplode()/implode()
Not that I'm aware of, but why don't you give it a shot. Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Jakob Mund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 07 June, 2003 09:04 Subject: [PHP-DB] Possible to store arrays in mySQL without explode()/implode() is it possible to store an array in mySQL without using implode() / explode(), like this: $stuff['blob'] = string; $stuff['hm'] = G-string; mysql_query(INSERT INTO table VALUES ($stuff)); and if, who must the mysql table be defined ? thx Jakob 'iNstinct' Mund -- 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] problem with insert query
It seems to me that this code will not provide useful information: if ($result) echo mysql_affected_rows(). affected.; If the insert was successful, it will always say 1 affected. Since you are only inserting one row at a time. On Sat, 07 Jun 2003 08:49:15 -0400, Becoming Digital wrote: Try this. I made some minor syntax changes and added some error reporting. While it may not fix things, it might help you figure out what's wrong. ? $mails=file(mails.txt); $number_of_mails = count($mails); for ($i=0; $i$number_of_mails; $i++) { $link = @ mysql_connect(localhost) or die( mysql_error() ); $db = mysql_select_db(me2resh00, $link); $query = insert into recipients (recipient_name, recipient_email) values (\friend\, \.$mails[$i].\); $result = mysql_query($query); if ($result) echo mysql_affected_rows(). affected.; } ? Edward Dudlik Becoming Digital www.becomingdigital.com - Original Message - From: Ahmed Abdelaliem [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, 07 June, 2003 08:15 Subject: [PHP-DB] problem with insert query hi i am wrote a script to read e-malis from a file and insert it into the tables of database i get error when i write it here is the code can anyone tell me what is wrong? ? $mails=file(mails.txt); $number_of_mails = count($mails); for ($i=0; $i$number_of_mails; $i++){ @ $db = mysql_connect(localhost); mysql_select_db(me2resh00); $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); $result = mysql_query($query); if ($result) echo mysql_affected_rows(). affected.; } ? here is the error that i get Parse error: parse error in enter.php on line 9 and line 9 is $query = insert into recipients (recipient_name, recipient_email) values ('friend', '.$mails[$i].'); --- Listserv only address. Jeff Shapiro -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] incrementing values
is there a function in mysql to increment a value inside a field? I am always doing this with php, just thought this might be really usefull?! UPDATE table SET column = column + 1 WHERE ... Like that? ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Possible to store arrays in mySQL without explode()/implode()
On Saturday 07 June 2003 21:04, Jakob Mund wrote: is it possible to store an array in mySQL without using implode() / explode(), like this: $stuff['blob'] = string; $stuff['hm'] = G-string; mysql_query(INSERT INTO table VALUES ($stuff)); serialize() and if, who must the mysql table be defined ? Any *TEXT field large enough to hold it. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db -- /* It is better to have loved and lost -- much better. */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Loading database information from a text file
Hi, I have a text file with all my database information from creating databases to setting up tables. I have looked throught the mysql docs on how to load these on from a text file via the mysql prompt. But all I can find is: load data infile filename.txt into table whatever But this is not what I am looking for. :( As the tables are already defined in the text file and the appropiate database name to enter them into. Is there a way to load these into the database directly instead of doing each table seperately from the mysql prompt? (not web admin) Thanks in advance. Kind Regards, Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Displaying groups from SELECT
hey, you can join the two queries and make only one... ? function get_inventory() { $query = SELECT c.cat_id, p.product_name FROM categories as c LEFT JOIN products as p on (c.cat_id = p.cat_id); $result = mysql_query( $query ); if ( mysql_num_rows($query) 0 ) { while ( $row = mysql_fetch_array($query, MYSQL_ASSOC) ) { $res_array[] = array('cat_id' = $row['cat_id'], 'product_name' = $row['product_name'] ); } if (is_array($res_array) { return $res_array; } else { return 0; } } else { return 0; } } //MAIN if (!$inventory = get_inventory()); { echo 'There is no result for your search.'; } else { $counter = count($inventory); for ($i=0; $i$counter; $i++) { print ul\n; $current_inventory = $inventory[$i['cat_id']]; $peek_inventory = $inventory[$i+1['cat_id']]; if ($current_inventory != $peek_inventory) { print li . $current_inventory ./li; print /ul\n; print ul; print li . $inventory[$i['product_name']] . /li; print /ul\n; } else { print li . $inventory[$i['product_name']] . /li; } print /ul; } } ? i think this work...didn't and couldn't test it... hope it's not too late KD -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Loading database information from a text file
I have a text file with all my database information from creating databases to setting up tables. I have looked throught the mysql docs on how to load these on from a text file via the mysql prompt. But all I can find is: load data infile filename.txt into table whatever But this is not what I am looking for. :( As the tables are already defined in the text file and the appropiate database name to enter them into. Is there a way to load these into the database directly instead of doing each table seperately from the mysql prompt? (not web admin) Is this a mysqldump file? The file has all of the SQL statements that you need to run? If so, just send it to mysql... Mysql -uuser -ppassword database_name filename.txt You can call that through exec() if you want. The file must be proper SQL, though. ---John W. Holmes... Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: ?? php and mysql database question ??
snip hi, u can install vmware (not freeware) on your windows machine and then install linux as a virtual machine. it behaves just like a real machine. works fine for me! /snip Yup I am aware of this but would be much better under Windows itself, saves mucking around than if it is possible. Which it is. :) I downloaded yesturday a Windows version of mysql that runs via DOS. Works a wonderful. Does exactly what I want being offline. Now I have can do all my PHP and mysql work offline as I have all the tools now for it. including the PHP server side to display php offline correctly. Thanks people for all your help in pointing me in the right direction. Mostly appreicated and I hope I can help some of you in return sometime soon. Now off to do my offline work. :) Kind Regards, Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: ?? php and mysql database question ??
snip hi, u can install vmware (not freeware) on your windows machine and then install linux as a virtual machine. it behaves just like a real machine. works fine for me! /snip Yup I am aware of this but would be much better under Windows itself, saves mucking around than if it is possible. Which it is. :) I downloaded yesturday a Windows version of mysql that runs via DOS. Works a wonderful. Does exactly what I want being offline. Now I have can do all my PHP and mysql work offline as I have all the tools now for it. including the PHP server side to display php offline correctly. Thanks people for all your help in pointing me in the right direction. Mostly appreicated and I hope I can help some of you in return sometime soon. Now off to do my offline work. :) Kind Regards, Jerry http://mobile.yahoo.com.au - Yahoo! Mobile - Check compose your email via SMS on your Telstra or Vodafone mobile. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php