Fwd: Re: Fwd: Re: [PHP-DB] search error
Note: forwarded message attached. - Sponsored Link Mortgage rates near 39yr lows. $420,000 Mortgage for $1,399/mo - Calculate new house payment--- Begin Message --- I have this code already, have a look at this few lines of code, which is already existing. -- $query1 = "SELECT distinct link_id, url, title, description, $fulltxt, size FROM ".$mysql_table_prefix."links WHERE link_id in ($inlist)"; $result = mysql_query($query1); echo mysql_error(); - I have experience of past I would get number of responses, and php database mailing list had many members world wide, only single response, why? -- In previous code, posted, can you have a look in case tables have been joined properly to respond to query and give proper search results. Chris <[EMAIL PROTECTED]> wrote: Asif Qureshi wrote: > Here I narrow down the problem. I meant narrow down the problem in your code. Add echo "mysql error? " . mysql_error() . " "; after your mysql_query calls for example. -- Postgresql & php tutorials http://www.designmagick.com/ - Everyone is raving about the all-new Yahoo! Mail beta.--- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Moving phpNuke to phpBB
Hi I'm helping out someone move from PHPNuke to phpBB. Only the forums and users need to be moved. Nuke's Db structure for the forums seems to mimic phpBB's closely, which is no great surprise. Any advice or information would be greatly appreciated. For example, anyone know a way to convert the stored passwords? Nuke uses a 40 char hash, while phpBB only 32. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Special Character
I you use a SQL adapter, like ADO, it could do the htmlentities it self... However, if you would like to change this, note that oracle will consider some chars as 'special chars', like (if I remember well) the &. To be able to insert a string with these chars, you need to search/replace them by their ascii value (use the Oracle function chr() This is specially true when inserting urls. vincent -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Wed 22/11/2006 22:17 To: David Skyers Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Special Character David Skyers wrote: > Hi Kevin, > > Thanks for this, it got rid of my special characters. However I now have a > problem with foreign characters. > > Example > > 'De l'Âge du fer au haut Moyen Âge.' > > gets inserted into oracle as > > De l'Âge du fer au haut Moyen Âge. > > I have an oracle procedure that inserts the data, if I run the oracle > procedure directly in oracle it inserts the special characters okay. The > problem seems to be with the way php execute the procedure. Are you calling htmlentities or htmlspecialchars before calling the procedure? That looks like what's happening. -- Postgresql & php tutorials http://www.designmagick.com/ -- 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: Fwd: Re: [PHP-DB] search error
Asif Qureshi wrote: Here I narrow down the problem. I meant narrow down the problem in your code. Add echo "mysql error? " . mysql_error() . ""; after your mysql_query calls for example. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fwd: Re: [PHP-DB] search error
Here I narrow down the problem. www.multipurposechain.com I enter for example search word, world, Its giving error. However previously, was giving proper output and search results from tables in database. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- Begin Message --- Asif Qureshi wrote: Got error 28 from table handler Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/wwwabcde/public_html/multipurposechain/searchfuncs.php on line 294 Got error 28 from table handlerDisplaying results 1-10 of 4541 matches (12.77 seconds) We're not going to go through all of your code. Narrow down the problem and we'll be able to help. -- Postgresql & php tutorials http://www.designmagick.com/ --- End Message --- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
AW: [PHP-DB] Direct Import Excel Data to MySQL (without CSV)
>What do you mean you can't write the data back - do you get an error? I try to edit the data on the Excel surface and then when I made some changes I would like to safe them back in the MySQL Database. Is it possible to write the data back with the common Excel functionality (including ODBC) Regards, Adrian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] My first try with PHP and Oracle ..
Matthias Bareuther wrote: Hello everybody, I'd like to connect to OracleDB using AdoDB. Here's my sourcecode so far : debug = true; $conn->PConnect($host,$user, $pass, $dbase); ?> When I load the site, it alway sais : 'MyServer-IP': Missing extension for native The AdoDB software is written in PHP and connects to your Oracle database using PHP's oci8 library calls. You can get AdoDB's "Missing extension" error when oci8 is not enabled in PHP. There are lots of installation documents that show how to configure PHP with oci8 enabled. One is at: http://www.oracle.com/technology/tech/php/pdf/underground-php-oracle-manual.pdf Chris -- Christopher Jones, Oracle Email: [EMAIL PROTECTED]Tel: +1 650 506 8630 Blog: http://blogs.oracle.com/opal/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Special Character
David Skyers wrote: Hi Kevin, Thanks for this, it got rid of my special characters. However I now have a problem with foreign characters. Example 'De l'Âge du fer au haut Moyen Âge.' gets inserted into oracle as De l'Âge du fer au haut Moyen Âge. I have an oracle procedure that inserts the data, if I run the oracle procedure directly in oracle it inserts the special characters okay. The problem seems to be with the way php execute the procedure. Are you calling htmlentities or htmlspecialchars before calling the procedure? That looks like what's happening. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] search error
Asif Qureshi wrote: Got error 28 from table handler Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/wwwabcde/public_html/multipurposechain/searchfuncs.php on line 294 Got error 28 from table handlerDisplaying results 1-10 of 4541 matches (12.77 seconds) We're not going to go through all of your code. Narrow down the problem and we'll be able to help. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Direct Import Excel Data to MySQL (without CSV)
Adrian Schimpf wrote: Hi together Is there a way to direct import MySQL data into an Excel Sheet, edit it and click a button to upload/sync it? I'm already using an ODBC driver to import the Data but then I'm not able to write the data back. That's probably the only way to do it. What do you mean you can't write the data back - do you get an error? -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] My first try with PHP and Oracle ..
Matthias Bareuther wrote: Hello everybody, I'd like to connect to OracleDB using AdoDB. Here's my sourcecode so far : debug = true; $conn->PConnect($host,$user, $pass, $dbase); ?> When I load the site, it alway sais : 'MyServer-IP': Missing extension for native The adodb list would be the best place to ask: http://adodb.sourceforge.net/#mail -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] search error
Got error 28 from table handler Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/wwwabcde/public_html/multipurposechain/searchfuncs.php on line 294 Got error 28 from table handlerDisplaying results 1-10 of 4541 matches (12.77 seconds) Result page: 1 2 3 4 5 6 7 8 9 10 Next $b['weight']) ? -1 : 1; } function addmarks($a) { $a = eregi_replace("[ ]+", " ", $a); $a = str_replace(" +", "+", $a); $a = str_replace(" ", "+", $a); return $a; } function makeboollist($a) { global $entities; while ($char = each($entities)) { $a = eregi_replace($char[0], $char[1], $a); } $a = trim($a); $a = eregi_replace(""", "\"", $a); $returnWords = array(); //get all phrases $regs = Array(); while (eregi("([-]?)\"([^\"]+)\"", $a, $regs)) { if ($regs[1] == '') { $returnWords['+s'][] = $regs[2]; $returnWords['hilight'][] = $regs[2]; } else { $returnWords['-s'][] = $regs[2]; } $a = str_replace($regs[0], "", $a); } $a = strtolower(eregi_replace("[ ]+", " ", $a)); // $a = remove_accents($a); $a = trim($a); $words = explode(' ', $a); if ($a=="") { $limit = 0; } else { $limit = count($words); } $k = 0; //get all words (both include and exlude) $includeWords = array(); while ($k < $limit) { if (substr($words[$k], 0, 1) == '+') { $includeWords[] = substr($words[$k], 1); } else if (substr($words[$k], 0, 1) == '-') { $returnWords['-'][] = substr($words[$k], 1); } else { $includeWords[] = $words[$k]; $returnWords['hilight'][] = $words[$k]; } $k++; } //add words from phrases to includes if (isset($returnWords['+s'])) { foreach ($returnWords['+s'] as $phrase) { $phrase = strtolower(eregi_replace("[ ]+", " ", $phrase)); $phrase = trim($phrase); $temparr = explode(' ', $phrase); foreach ($temparr as $w) $includeWords[] = $w; } } foreach ($includeWords as $word) { if (!($word =='')) { if (ignoreWord($word)) { $returnWords['ignore'][] = $word; } else { $returnWords['+'][] = $word; } } } return $returnWords; } function ignoreword($word) { global $common; global $min_word_length; global $index_numbers; if ($index_numbers == 1) { $pattern = "[a-z0-9]+"; } else { $pattern = "[a-z]+"; } if (strlen($word) < $min_word_length || (!eregi($pattern, remove_accents($word))) || ($common[$word] == 1)) { return 1; } else { return 0; } } function search($searchstr, $category, $start, $per_page, $type) { global $length_of_link_desc,$mysql_table_prefix, $show_meta_description; //find all sites that should not be included in the result if (count($searchstr['+']) == 0) { return null; } $wordarray = $searchstr['-']; $notlist = array(); $not_words = 0; while ($not_words < count($wordarray)) { $searchword = addslashes($wordarray[$not_words]); $query1 = "SELECT link_id from ".$mysql_table_prefix."link_keyword, ".$mysql_table_prefix."keywords where ".$mysql_table_prefix."link_keyword.keyword_id= ".$mysql_table_prefix."keywords.keyword_id and keyword='$searchword'"; echo mysql_error(); $result = mysql_query($query1); while ($row = mysql_fetch_row($result)) { $notlist[$not_words]['id'][$row[0]] = 1; } $not_words++; } //find all sites containing the search phrase $wordarray = $searchstr['+s']; $phrase_words = 0; while ($phrase_words < count($wordarray)) { $searchword = addslashes($wordarray[$phrase_words]); $query1 = "SELECT link_id from ".$mysql_table_prefix."links where fulltxt like '% $searchword%'"; echo mysql_error(); $result = mysql_query($query1); $num_rows = mysql_num_rows($result); if ($num_rows == 0) { return null; } while ($row = mysql_fetch_row($result)) { $phraselist[$phrase_words]['id'][$row[0]] = 1; } $phrase_words++; } if ($category> 0) { $allcats = get_cats($category); $catlist = implode(",", $allcats); $query1 = "select link_id from ".$mysql_table_prefix."links, ".$mysql_table_prefix."sites, ".$mysql_table_prefix."categories, ".$mysql_table_prefix."site_category where ".$mysql_table_prefix."links.site_id = ".$mysql_table_prefix."sites.site_id and ".$mysql_table_prefix."sites.site_id = ".$mysql_table_prefix."site_category.site_id and ".$mysql_table_prefix."site_category.category_id in ($catlist)"; $result = mysql_query($query1); echo mysql_error(); $num_rows = mysql_num_rows($result); if ($num_rows == 0) { return null; } while ($row = mysql_fetch_row($result)) { $category_list[$row[0]] = 1; } } //find all sites that include the search word $wordarray = $searchstr['+']; $words = 0; $starttime = getmicrotime(); while ($words < count($wordarray)) { $searchword = addslashes($wordarray[$words]); $query1 = "SEL
RE: [PHP-DB] Just two PHP questions
1) What exactly I need to download for running PHP on Apache. PHP the latest version 2) What should be the location of the downloaded PHP folder/file/executable so that it interacts easily with Apache. Any, but if you prefer tu indicate an installation directory you may do that by specifing it during configuration: configure -options_here 3) Settings if any ! Read the manual, there are many settings you can set, but basically almost all of them depend upon your production or testing environment Regards, Guirao Este mensaje es exclusivamente para el uso de la persona o entidad a quien esta dirigido; contiene informacion estrictamente confidencial y legalmente protegida, cuya divulgacion es sancionada por la ley. Si el lector de este mensaje no es a quien esta dirigido, ni se trata del empleado o agente responsable de esta informacion, se le notifica por medio del presente, que su reproduccion y distribucion, esta estrictamente prohibida. Si Usted recibio este comunicado por error, favor de notificarlo inmediatamente al remitente y destruir el mensaje. Todas las opiniones contenidas en este mail son propias del autor del mensaje y no necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas controladas, controladoras, afiliadas y subsidiarias. Este mensaje intencionalmente no contiene acentos. This message is for the sole use of the person or entity to whom it is being sent. Therefore, it contains strictly confidential and legally protected material whose disclosure is subject to penalty by law. If the person reading this message is not the one to whom it is being sent and/or is not an employee or the responsible agent for this information, this person is herein notified that any unauthorized dissemination, distribution or copying of the materials included in this facsimile is strictly prohibited. If you received this document by mistake please notify immediately to the subscriber and destroy the message. Any opinions contained in this e-mail are those of the author of the message and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de C.V. or any of its control, controlled, affiliates and subsidiaries companies. No part of this message or attachments may be used or reproduced in any manner whatsoever. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] search error
search error and code has been posted -- Got error 28 from table handler Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/wwwabcde/public_html/multipurposechain/searchfuncs.php on line 294 Got error 28 from table handlerDisplaying results 1-10 of 4541 matches (12.77 seconds) Result page: 1 2 3 4 5 6 7 8 9 10 Next $b['weight']) ? -1 : 1; } function addmarks($a) { $a = eregi_replace("[ ]+", " ", $a); $a = str_replace(" +", "+", $a); $a = str_replace(" ", "+", $a); return $a; } function makeboollist($a) { global $entities; while ($char = each($entities)) { $a = eregi_replace($char[0], $char[1], $a); } $a = trim($a); $a = eregi_replace(""", "\"", $a); $returnWords = array(); //get all phrases $regs = Array(); while (eregi("([-]?)\"([^\"]+)\"", $a, $regs)) { if ($regs[1] == '') { $returnWords['+s'][] = $regs[2]; $returnWords['hilight'][] = $regs[2]; } else { $returnWords['-s'][] = $regs[2]; } $a = str_replace($regs[0], "", $a); } $a = strtolower(eregi_replace("[ ]+", " ", $a)); // $a = remove_accents($a); $a = trim($a); $words = explode(' ', $a); if ($a=="") { $limit = 0; } else { $limit = count($words); } $k = 0; //get all words (both include and exlude) $includeWords = array(); while ($k < $limit) { if (substr($words[$k], 0, 1) == '+') { $includeWords[] = substr($words[$k], 1); } else if (substr($words[$k], 0, 1) == '-') { $returnWords['-'][] = substr($words[$k], 1); } else { $includeWords[] = $words[$k]; $returnWords['hilight'][] = $words[$k]; } $k++; } //add words from phrases to includes if (isset($returnWords['+s'])) { foreach ($returnWords['+s'] as $phrase) { $phrase = strtolower(eregi_replace("[ ]+", " ", $phrase)); $phrase = trim($phrase); $temparr = explode(' ', $phrase); foreach ($temparr as $w) $includeWords[] = $w; } } foreach ($includeWords as $word) { if (!($word =='')) { if (ignoreWord($word)) { $returnWords['ignore'][] = $word; } else { $returnWords['+'][] = $word; } } } return $returnWords; } function ignoreword($word) { global $common; global $min_word_length; global $index_numbers; if ($index_numbers == 1) { $pattern = "[a-z0-9]+"; } else { $pattern = "[a-z]+"; } if (strlen($word) < $min_word_length || (!eregi($pattern, remove_accents($word))) || ($common[$word] == 1)) { return 1; } else { return 0; } } function search($searchstr, $category, $start, $per_page, $type) { global $length_of_link_desc,$mysql_table_prefix, $show_meta_description; //find all sites that should not be included in the result if (count($searchstr['+']) == 0) { return null; } $wordarray = $searchstr['-']; $notlist = array(); $not_words = 0; while ($not_words < count($wordarray)) { $searchword = addslashes($wordarray[$not_words]); $query1 = "SELECT link_id from ".$mysql_table_prefix."link_keyword, ".$mysql_table_prefix."keywords where ".$mysql_table_prefix."link_keyword.keyword_id= ".$mysql_table_prefix."keywords.keyword_id and keyword='$searchword'"; echo mysql_error(); $result = mysql_query($query1); while ($row = mysql_fetch_row($result)) { $notlist[$not_words]['id'][$row[0]] = 1; } $not_words++; } //find all sites containing the search phrase $wordarray = $searchstr['+s']; $phrase_words = 0; while ($phrase_words < count($wordarray)) { $searchword = addslashes($wordarray[$phrase_words]); $query1 = "SELECT link_id from ".$mysql_table_prefix."links where fulltxt like '% $searchword%'"; echo mysql_error(); $result = mysql_query($query1); $num_rows = mysql_num_rows($result); if ($num_rows == 0) { return null; } while ($row = mysql_fetch_row($result)) { $phraselist[$phrase_words]['id'][$row[0]] = 1; } $phrase_words++; } if ($category> 0) { $allcats = get_cats($category); $catlist = implode(",", $allcats); $query1 = "select link_id from ".$mysql_table_prefix."links, ".$mysql_table_prefix."sites, ".$mysql_table_prefix."categories, ".$mysql_table_prefix."site_category where ".$mysql_table_prefix."links.site_id = ".$mysql_table_prefix."sites.site_id and ".$mysql_table_prefix."sites.site_id = ".$mysql_table_prefix."site_category.site_id and ".$mysql_table_prefix."site_category.category_id in ($catlist)"; $result = mysql_query($query1); echo mysql_error(); $num_rows = mysql_num_rows($result); if ($num_rows == 0) { return null; } while ($row = mysql_fetch_row($result)) { $category_list[$row[0]] = 1; } } //find all sites that include the search word $wordarray = $searchstr['+']; $words = 0; $starttime = getmicrotime(); while ($words < count($wordarray))
[PHP-DB] Direct Import Excel Data to MySQL (without CSV)
Hi together Is there a way to direct import MySQL data into an Excel Sheet, edit it and click a button to upload/sync it? I'm already using an ODBC driver to import the Data but then I'm not able to write the data back. Is someone using a reliable solution? Regards Adrian Introduction: This is my first post to this list, even though I'm a frequently reader of the list. Here is a short introduction: I live and work in Switzerland as a webmaster. Currently doing a lot of internal (intranet) projects such as an address db, etc. Mostly using PHP and MySQL (JS/CSS/HTML) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] My first try with PHP and Oracle ..
Hello everybody, I'd like to connect to OracleDB using AdoDB. Here's my sourcecode so far : debug = true; $conn->PConnect($host,$user, $pass, $dbase); ?> When I load the site, it alway sais : 'MyServer-IP': Missing extension for native I asked google about this message, but the links I found didn't really help me. :-( Does anyone know, what's the meaning of this message? And how to solve the problem? Thank you .. in advance .. ,-) Greetz Matthias -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Special Character
Hi Kevin, Thanks for this, it got rid of my special characters. However I now have a problem with foreign characters. Example 'De l'Âge du fer au haut Moyen Âge.' gets inserted into oracle as De l'Âge du fer au haut Moyen Âge. I have an oracle procedure that inserts the data, if I run the oracle procedure directly in oracle it inserts the special characters okay. The problem seems to be with the way php execute the procedure. Any ideas? David _ From: Kevin Murphy [mailto:[EMAIL PROTECTED] Sent: 16 November 2006 16:45 To: David Skyers Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Special Character A solution I use is to do apply this function to all POST data collected. The key here for your problem is the chr(150) and chr(151) that are replaced with a normal hyphen. This also takes care of MS Words Smart Quotes. If there are other MS Characters you need to convert, just add them to the pattern field as the numeric version, and then add one to the array what the replacement is. function sanitize($data) { $pattern = array(chr(145),chr(146),chr(147),chr(148),chr(150),chr(151)); $replacements = array("'","'",'"','"','-','--'); $data = str_replace($pattern,$replacements,$data); $data = trim($data); $data = preg_replace("/ +/", " ", $data); $data = addslashes($data); return $data; } -- Kevin Murphy Webmaster: Information and Marketing Services Western Nevada Community College www.wncc.edu 775-445-3326 On Nov 16, 2006, at 7:32 AM, David Skyers wrote: Thanks, The problem is, we will have hundreds of users using Microsoft Word and we cannot switch it off for all of them. Ideally I need some type of string replace function, so no matter what they enter it gets trapped an replaced. It's not the normal hyphens that cause a problem but the long hyphens. Regards David -Original Message- From: Dan Shirah [mailto:[EMAIL PROTECTED] Sent: 16 November 2006 15:13 To: php-db@lists.php.net Subject: Re: [PHP-DB] Special Character To turn off the auto formatting of hyphens: In Microsoft Word 2003: Open a new document. Go to Tools>Auto Correct Options> Select the "Auto Format As You Type" tab Deselect the "Hyphens (--) with Dash (-)" option. Even though it says it will replace a double hyphen (--) with a Dash (This is an em dash) it also does the same thing for a single hyphen depending on the sentance structure. Hope this helps! Dan On 11/16/06, Niel Archer <[EMAIL PROTECTED]> wrote: Hi David What you describe sounds like Word is auto replacing hyphens with either en- or em-dashes. This is a configurable option in Word that often defaults to on. Try using double quotes, If they get switched to 66's and 99's style quotes, then that is likely the problem. I no longer use MS Office for these and other reasons, so cannot tell you how to switch off this formatting. But it can be switched off, somewhere within it. The only other option I can think of would be to change your Db character set to one that can accept these extended characters. That might also mean changing some of Window's/Word's behaviour (to be using UTF-8 for example). Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Just two PHP questions
As mentioned before, I am new to php. Till now I was trying to execute the file online. However, I have got Apache tomcat on my system which runs JSP files perfectly, including the database interactions. I am now trying to run PHP using apache on localhost. Can you please advice: 1) What exactly I need to download for running PHP on Apache. 2) What should be the location of the downloaded PHP folder/file/executable so that it interacts easily with Apache. 3) Settings if any ! I have an older version of Apache tomcat which is 5.0. I do not use the Apache Start and Stop options but Start and Stop bat files to run and stop apache. Thanks in advance. -- View this message in context: http://www.nabble.com/Just-two-PHP-questions-tf2684323.html#a7487358 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] simple issue
Thanks Jeff, As I mentioned, this is just a sample code with username password db name all changed. Thanks for your advice coz I never knew the php db archive is searchable. Jeffrey-2 wrote: > > You should be aware the the PHP-DB archives are openly available on the > web and searchable. Assuming you have listed your actual username, > password, etc, you should immediately go to your web site and change > your password. If possible change also your username and database name. > Do it now. > > It would not be an overly demanding task for a hacker to find your web > site and once she does, she has free access to your database. > > And in future, when sharing code on PHP-DB, which is a must if you want > the expert help people here can provide, always leave out or change the > MySQL log in info. > > Good luck, > > Jeffrey > > > Chris Carter wrote: >> my code: >> >> >> >> >> > $username="chris"; >> $password="carter"; >> $database="chris_phpb1"; >> >> mysql_connect(localhost,$username,$password); >> @mysql_select_db($database) or die( "Unable to select database"); >> $query="SELECT * FROM phpbb_banlist"; >> $result=mysql_query($query); >> >> if (!$result) >> {exit("Error in SQL");} >> echo ""; >> echo "Companyname"; >> echo "Contactname"; >> while (odbc_fetch_row($result)) >> { >> $compname=odbc_result($result,"CompanyName"); >> $conname=odbc_result($result,"ContactName"); >> echo "$compname"; >> echo "$conname"; >> } >> odbc_close($conn); >> echo ""; >> ?> >> >> >> >> >> My error: >> >> Fatal error: Call to undefined function: odbc_fetch_row() in >> /home/chandan/public_html/deb.php on line 19 >> Companyname Contactname >> >> Also .. I am trying this live on cPanel compiler coz I could not install >> the >> PHP thing on my localhost. I have apache-tomcat-5.5.17 which works >> perfectly >> with jsp files but I do not understand what does it take to run a php >> using >> apache. >> >> chris smith-9 wrote: >> >>>Chris Carter wrote: >>> Hi, I am new to PHP, just trying a peace of code to access mySQL database to fetch and show result on web page. But getting errors. Can you help me with this code please. Or if you have a very basic code where in I can do some insertion in the database. >>> >>>There are hundreds of mysql + php tutorials on the 'net - do a search in >>>your preferred search engine. >>> >>>If you *still* can't work it out post a sample of the code you're trying >>>to use and the errors you get. >>> >>>-- >>>Postgresql & php tutorials >>>http://www.designmagick.com/ >>> >>>-- >>>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 > > > -- View this message in context: http://www.nabble.com/simple-issue-tf2683559.html#a7487209 Sent from the Php - Database mailing list archive at Nabble.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php