Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About phdphd

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling
  1. Hi All, I want to insert a Google static map. I noticed that there may be some loss of information (e.g., loss of the name of narrow streets) when using lower value for the size attribute of the map. For example, http://maps.googleapis.com/maps/api/staticmap?&size=600x600 may show more details than http://maps.googleapis.com/maps/api/staticmap?&size=150x150. On the other hand I want the static map to display on smartphones, adjusted to their width. With some JS I could get the width of the smartphone and inject it in the size attribute, but that could lead to some loss of details. So here is my question : is it possible to load the map, say, at 600x600, then shrink it to the width of the smartphone (in the same way as shrinking a jpg image where details are not lost, but just rescaled) ? Thanks !
  2. Thanks. mysqldump -uroot -p --databases db_name --routines --events --result-file=file_name.sql did the trick.
  3. Hi All, I am in the process of moving my database from a local Windows system to a Debian VPS server. So far to back up my database I have been using this syntax : mysqldump -uroot -p --databases database_name --routines --events> filename.sql In this page http://www.it-iss.com/mysql/mysql-copying-a-database-users-and-privileges-between-two-servers/ the author recommends to use also the --result-file to prevent line end issues when moving from a Windows system to a Linux system. Would the right syntax be as follows then ? mysqldump -uroot -p --databases database_name --result-file= filename.sql --routines --events Thanks!
  4. Well, so far, I tried nothing, as for spanish lists of words. It is just that googling terms like "SPANISH_COLLATION" gives no result. For example, when properly ordered in Spanish, "lleno" would come after "lomo", and "chico" after "cosa", since the alphabet order in Spanish is "a, b, c, ch, d, ....k, l, ll, m, n, ...z"
  5. Hi All, I want to display lists of words (utf8 encoded) correctly ordered in Spanish, where "ch" and "ll" are considered as letters in the alphabet. For French, I use the following : $col = new Collator('fr_FR'); $col->setAttribute(Collator::FRENCH_COLLATION, Collator::ON); $col->asort(<array-to-sort>); What would be the equivalent for spanish? Thanks!
  6. Hi All, I have a page organized in tabs, each with its own div. I have a js that displays a given div when the user clicks the matching tab. There is a leaflet map in the first div, built from thousands of markers. There is a login form in the other div. Displaying a div by clicking its tab works great. If the user fails the login process, the page is reloaded and he is redirected back to the login div (and a message displays about the error that occured). Now here is the issue. Suppose the login process fails. If the user clicks the map tab, he will see a badly-formed map, like shrinked in the upper left corner of its container. My feeling is that the js that deals with the tabs runs before the end of the execution of the js that builds the map. The body has an onload="init()" associated with the tabs script. Thus I guess the tabs script would run only after the page has loaded. Since this does not seem to take into accound the map DOM, I tried and found a solution by applying a short settimeout (500 ms) in the tab js, more precisely to the function that grabs the tab links and content divs from the page. Now if the user fails the login process and clicks the map tab, he will see a well-formed and fully interactive map. However I think this is just a workaround. Is there a better solution? Thanks !
  7. You are right. My mistake. I am using phpMyAdmin. I should have made the tests through SQL statements instead of inserting a row via the Insert tab or editing a value via the View tab.
  8. Hi All, I have a table to which I added 2 computed columns like this : ALTER TABLE foo add number2 DECIMAL GENERATED ALWAYS AS (number*2) STORED, add nombre3 DECIMAL GENERATED ALWAYS AS (number*3) STORED Two issues : 1. Updating a value in "number" column does not updates "number2" and "number3" columns 2. Inserting a new row generates the error "the value specified for generated column is not allowed". Thanks!
  9. Hi All, I am presently working on media queries. Is there a reliable way to assess the physical width in inches of the screen ? On my 17-inches laptop, at a 1920-px resolution, I have a web page that displays a series of divs, with 4 divs per row. At a 1366-px resolution, the same page will display 3 divs per row. (Reducing the divs’ size in order to have 4 divs per row would make them less readible.) However, there are screen devices wider than 17 inches, but with a 1366-px resolution. On those screens, displaying 4 divs per row, instead of 3, would be appropriate. Is it possible to play with the physical size of screens in inches ? Thanks !
  10. Hi All, Just wondering whether it is possible to resize a jpg image to a specific size in bytes (while preserving height/width ratio). Thanks for any clues!
  11. Hi All, I have a function that I want to trigger multiple times on different parts of the document, with a 1 second delay between each run. The structure of the function is as follows function intro(param1, param2){ //processing goes here }; I call it like this : $(document).ready(function(){ intro('#hello', '#world'); intro('#hi', '#all'); intro('#hola', '#amigos'); }); I would like to trigger intro('#hi', '#all') 1 second after intro('#hello', '#world') starts, and intro('#hola', '#amigos') 1 second after intro('#hi', '#all') starts, and so on. Thanks !
  12. Here is a screenshot. Note the lines appear for just a fraction of a second.
  13. Hi All, I need some technical clarification. I am using uWamp as a stack. uWamp has a dialog box that shows the CPU consumption % by Apache. I have a jQuery animation on my webpage, where squares move randomly. CPU consumption % by Apache is around 5%. If I disable the animation, then the CPU consumption drops to nearly 0%. I don’t quiet understand the relation between both, since Apache is server-side and jQuery is client-side. Also, suppose I have 3 tabs open in my web browser, one of them being for my website. If I move to another tab, then again the CPU consumption % drops to nearly 0% (however the animation keeps going). 1/Shouldn’t jQuery use computer (client) resources instead of Apache for displaying the animation ? 2/In a production environment where 20 users are viewing this page, would Apache globally consume 100% of the server CPU resources ? Hard to believe this. Thanks !
  14. Hi All, I am working on a jQuery implode effect. At the end of the animation some vertical and horizontal white lines display. Is there a way to prevent this ? The fiddle : https://jsfiddle.net/9dnraqj6/ Thanks!
  • Create New...

Important Information

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.