Jump to content
xisto Community

TavoxPeru

Members
  • Content Count

    865
  • Joined

  • Last visited

Everything posted by TavoxPeru

  1. I just uninstall the XnView viewer and i have CCleaner, so, i will follow your suggestion right now and later i will post the results of this, thanks. Best regards,
  2. Yes yordan, i remember to refresh the Explorer window and i also do what you suggest but nothing happens and the problem stills. Also, i did not forget to uncheck the "hide extensions for know types" in the Explorer's Folder properties. Best regards,
  3. As yordan said you can select data from several tables by joining all of them in one single sql command, but you can also select some data from one table and then select some other data from another diferent table, for example, there are situations where you need to get some data from a table and then get some other data from another table that depends on one field of the first table, something like this: <?php$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');if (!$link) { die("Error, Can't connect to server: " . mysql_error());}// make foo the current db$db_selected = mysql_select_db('foo', $link);if (!$db_selected) { die ("Error, Can't use db foo : " . mysql_error());}$tx="<table width='100%' border='1' valign='top' cellspacing='0' cellpadding='0'>";$resultOne=mysql_query("select * from tableOne",$link);$nRowsOne=mysql_num_rows($resultOne);if($nRowsOne>0){ while($rowOne = mysql_fetch_array($resultOne)) { $nRowsTwo=0; $j=0; $idOne=$rowOne["id_One"]; $tx.="<tr>\n"; $tx.="<td width='100%' align='center' valign='middle'>\n"; $nameOne = trim($rowOne["Name"]); $tx.=$nameOne; $tx.="\n</td>\n</tr>\n"; $resultTwo=mysql_query("select * from tableTwo where (tableTwo.id_One=$idOne",$link); $nRowsTwo=mysql_num_rows($resultTwo); if($nRowsTwo>0) { $nRowsTwo=$nRowsTwo/4; $jTwo=0; while($jTwo<$nRowsTwo) { $tx.="<tr>\n"; $tx.="<td width='100%' align='center' valign='middle'>\n"; for ($h = 0; $h<4; $h++) { if($rowTwo = mysql_fetch_array($resultTwo)) { $nameTwo = trim($rowTwo["name"]); $tx.=$nameTwo; } else $tx.=" "; } $tx.="\n</td>\n</tr>\n"; $jTwo++; } } }}$tx.="</table>\n";echo $tx;mysql_close($link);?>There is no command to close a table, what you can do is to free up the memory used by your result data that you get from your sql command with the mysql_free_result() function. You can use the mysql_close() function to close the connection to your database. Best regards,
  4. As you, i think that the Yahoo! Search BOSS will be very similar to the Custom Search Engine offered by Google, but after reading the Yahoo! Search BOSS documentation i notice that it is a more robust and complete product than the one offered by Google. I'm planning to use Yahoo! Search BOSS with my next project, i'm waiting for my client to decide if we use it or not. Best regards,
  5. The url given by faulty.lee shows in detail all the data type storage requirements, but if you need it quickly here there are: DATE: 3 bytes. FLOAT: 4 bytes. TINYINT: 1 byte. SMALLINT: 2 bytes. BIGINT: 8 bytes. VARCHAR(x): x+1 bytes, usually 0 to 255 bytes. TEXT: Maximum 64Kb. Take into account that for the VARCHAR(x) and the TEXT data types this value depends if it is a binary string or a non-binary string -for the first one it represents the declared column lenght in bytes and for the second one in characters- and which character set you will use with them, because some character sets are multi-bytes like UTF-8 (up to three bytes per character) or UCS2 (up to two bytes per character). BTW, i don't think that you can reach the 500MB limit unless you will use your database to store images or binary data like music or video. Best regards,
  6. First of all thanks for your help, and second, my answers: Yes, i do. I recently install an image viewer called XnView, but none of the products you mention, so, i will uninstall it to see what happens. In this case, the problem i had as i said is related with Windows Explorer and i don't install any plug-in or skin, also, it is stange because the thumbnails preview works fine in case of html files. Do you remember exactly which registry settings you change??? Best regards,
  7. Hi, since a while i got two problems related with images files in my Windows 2000 machine, both are very closely related because them happen with Windows Explorer and with Internet Explorer 6. The problems are: Windows Explorer Thumbnails Preview: The problem with this option of the View menu is that it doesn't show any thumbnail preview of any image in my hole computer, i verify this problem for jpg, jpeg, gif, png or bmp files, but it works fine and generate the thumbnail previews for html files. IE Save as... dialog and JPG files extension: Every time that i want to save an image with Internet Explorer while i'm surfing the net, the default extension that the Save as... dialog shows for jpg files is *.JPEG, but before this dialog shows *.JPG for them, this is not a really problem because i can simply type jpg while saving but i prefer the previous behavior. For the first problem i really don't have any idea on how can i fix it, and for the second problem i'm thinking that this problem is related with the default settings for jpg files. I hope that someone can help me. Best regards,
  8. Last wednesday (2008-07-09) Yahoo! Search launched a new service called Yahoo! Search BOSS (Build your Own Search Service) which is a web services platform that allows developers and companies to create and launch web-scale search products by utilizing the same infrastructure and technology that powers Yahoo! Search. Some capabilities of the new Yahoo! Search BOSS service are: Ability to re-rank and blend results Unlimited queries Total flexibility on presentation This service is based on Python and is available to everybody, to get started and Build your Own Search Service you only need to go to the the Yahoo! Developer Network and get a BOSS app Id. For more information visit Yahoo lets you build your own search service. Best regards,
  9. As i said in my first post, this tool will help you to verify the status of any page by checking its HTTP status code. For example, when you are updating a website you usually make things like changing file names, add, delete or update page content, move inside another folder a page or group of pages located at your root folder, delete a page, etc., so, with this tool you can verify that every thing is fine and any search engine can be able to view your changes. And thanks to tansqrx to post the complete list of HTTP status codes. Best regards,
  10. Marketleap is a website that offers three free search engine marketing tools that i think can be useful for search success. Link Popularity Check: The Link Popularity Check tool help website owners to find out who is linking to their site. With you can check the total number of links that a search engine has found for your website and for your competitors. You simply enter your website url and up to three comparison URLs and optionally your industry and this tool will generate a report with the number of links that a search engine found for your website. The Link Popularity Check tool works with Google, Aol, HotBot, Yahoo, Fast and Altavista. Search Engine Saturation: Search Engine Saturation refers to the number of pages a given search engine has in its index for your website domain. With this tool you can create some meaningful benchmarks for your search engine marketing campaigns. You only need to enter your website domain name and optionally up to five comparison urls. Keyword Verification: This verification tool checks to see if your site is in the top three pages of a search engine result for a specific keyword. The Keyword Verification tool works with Google/AOL/HotBot, Google, Lycos Pro, MSN, Netscape and Yahoo!/FAST/AltaVista. Simply enter your website domain name and the keyword/phrase you want to verify. Best regards,
  11. The following pages shows some live examples: Almost 3d Blocks Using CSS borders Three state 3D Buttons Using CSS - 1 Three state 3D Buttons Using CSS - 2 Best regards,
  12. You are not wrong, the code apply to one page only, but, what i'm trying to explain is that i want to include only some extra javascript code to only one page not to every page of the website. I put your code inside a file called library.js and i create another file called library1.js with one function only: <script type="text/javascript"> function three() { // some code here } </script> The idea is to include to every page of the webiste the file library.js and then include the file library1.js to only one page that needs this extra code. Best regards,
  13. So many keywords, so little time -trying to keep track of your site's ranking for every phrase can get pretty hectic. That's even more true if you intend to keep tabs on multiple search engines. Luckily, the Search Engine Keyword Position tool can help. The Search Engine Keyword Position tool is very easy and simple, you only need to enter your site's address and a key word or phrase, and it will determine where you stand with Google, Yahoo, and MSN. Best regards,
  14. The Check Server Headers tool is another helpful online tool that you can use to check and verify HTTP status codes of any page. Server headers and HTTP status codes are a matter of particular importance in ensuring that search engines see your content. But checking them can be a bit tricky. The Check Server Headers tool is very simple and easy to use, you just need to enter a valid URL, and the tool will give you one of seven HTTP status codes. It will also -and this is important- give you an interpretation of the code. Best regards,
  15. We don't have the choice to know if the problem is fixed, because the starter user of this topic don't say anything but It seems that the problem is fixed.Best regards,
  16. In my opinion this function could be very useful in the event that you need to add some additional javascript functions to only a specific page not to all pages of the website. Generally what i do is to separate the components of every page in modules, and then start loading these when needed, first the header, then the main body, then the footer and so on of any page. In the header i include a general javascript file which all the pages of the website will use but in only two pages i need to include some additional functions to them. The first thing that i do is to include an extra script tag inside these pages, but when i validate both pages, they don't pass the validation process, so, i use this function to add the additional code needed and after that both pages pass the validation process. Best regards,
  17. The View New Posts problem was resolved I just try it and every thing works fine. Best regards,
  18. You forgot to include an echo statement, simply add it to your code like the following example: <input type="text" name="name1" value="<?php echo $_GET["name1"]; ?>" size="30">The GET method is used if you want to send information somewhere via a browser URL. Youâve seen URLs that send information; they look something like: http://forums.xisto.com/no_longer_exists/ In the above URL, the part after the question mark is information sent to handler. Multiple information chunks are separated with an ampersand. The GET method can send only a limited amount of information. The limitation depends on the server where the server where the information is sent to. The limitation can be as little as 256 bytes but is often 1k or more. Another limitation of the GET method is that the information being sent is visible in the browser's address bar. In some cases this is of no consequence. In others, it is unacceptable. The POST method is the most common method used to send information from a form to an information processing program or function. The POST method can send much more information than the typical GET method. Most browsers and servers limit the amount of POST information to about 32k. With POST, the information is not sent via the URL. The sending is invisible to the site visitor. Best regards,
  19. Thanks, i just check it and it is another good option we have. Best regards,
  20. Yes it is, the first url opens an ad-page so don't waste your time visiting it, only the second url is useful.Best regards,
  21. The problem still exists, i notice this since yesterday when i try to do the same thing as Miles, a solution of the View New Posts option is by using the My Assistant option, once you open this link it shows up a pop up window with four tabs, select the New Posts tab to view there the last posts of the forums. Best regards,
  22. As i said in my previous post, you can obfuscate your HTML code to hide it from prying eyes using some kind of encryption method or with an html encoder, like this one HTML Encoder - Encode URL, Text and Decoder that i just found at the Audit My PC website. The HTML Encoder tool is free and very easy to use. You can use to encode or decode html, url or text. Additionally at the bottom of the same page you will find a tool to help you to escape or unescape text called the Text Escape tool, this tool will look for any special characters and escape them. So, take a look to the HTML Encoder - Decoder tool may be it can helps you. Edit: The Encode/Decode HTML entities is another tool which you can use to convert text to HTML entities. Best regards,
  23. I think that this error happens because of the server name parameter, as wutske said use localhost instead. The database server name parameter is a string that can include the port number the MySql server will use in case it is necesary. Also, you can use a path to a local socket ":/path/to/socket" for the localhost or even an IP number. So, the following ones are valid strings which you can use to specify your MySql server name: localhost localhost:3306 example.com example.com:3307 /tmp/mysql.sock localho http://forums.xisto.com/no_longer_exists/ 127.0.0.1 127.0.0.1:3306 For more information visit the mysql_connect() php function page, and if you need the exactly mysql error number use the mysql_error() function, like: <?php$db = mysql_connect($host['naam'], $host['gebruikersnaam'], $host['wachtwoord']) OR die("Mysql Error: " . mysql_errno() . " - " . mysql_error());?>Generally i use a function when i need to connect to any database, and instead using the die() php function i use the exit() php function when an error is generated. Here is my general database connection function: <?phpfunction dbconn($server,$uname,$upwd,$dbname) { if(!($link=mysql_connect($server,$uname,$upwd))) { $errorText = mysql_error(); $errorNum = mysql_errno(); echo "Connection to the database server fails.<br />MySql says:<br />Error Number: $errorNum<br />Error Message: $errorText"; exit(); } if (!mysql_select_db($dbname,$link)) { $errorText = mysql_error(); $errorNum = mysql_errno(); echo "Database selection fails.<br />MySql says:<br />Error Number: " . $errorNum . "<br />Error Message: " . $errorText"; mysql_close(); exit(); } return $link;}$host['naam'] = 'CENSORED'; // my host$host['gebruikersnaam'] = 'righto'; // my database username$host['wachtwoord'] = 'CENSORED'; // my database password$host['databasenaam'] = 'odinms'; // my database name// To connect you can use this way$conn = dbconn($host['naam'],$host['gebruikersnaam'],$host['wachtwoord'],$host['databasenaam']);// or this way toodbconn($host['naam'],$host['gebruikersnaam'],$host['wachtwoord'],$host['databasenaam']);?>Best regards,
  24. As far as i know there is no way to perform that, what you can do is to obfuscate the html code by encrypt it, about the php code you can use an encoder to encode your code prior to distribute them to your client. One php encoder that i know and you can use is PHTML Encoder, comes in two versions -free and pro- and the free one is available to download from here. You can use this with all versions of PHP between 4.0.6 and 5.2.4. Best regards,
  25. Your query don't work because your variable stores a string like "2008/06/13", the "/" character cause this error to happen. To fix it simply change your variable's date format to: <?php$reg_date=date("Ymd");?>But this can lead to get problems with the register_date field, i'm not sure about this. A better solution is to change the data type of the register_date field to date and change the sql query to: <?phpmysql_query("INSERT INTO members(username, password, email, register_date) VALUES ('$user','$pass','$email', NOW())") or die("Failed to register.<br> Error:".mysql_error());?>Best regards,
×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.