Paranorman's Posts
Nairaland Forum › Paranorman's Profile › Paranorman's Posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 (of 43 pages)
Hello all. Can anyone recommend a simple application that I can use to test http request/response messages? |
Olyboy16:Thanks, figured it out. |
xampp 7.0.1 is what I use for executing my PHP scripts. the $_SERVER[] superglobal appears not to have these indexes when I print_r() it. What am I missing? do I have to modify something in the config files? |
Hello Coders, Was wondering if I can get some SQL dump or any other data format of Nigerian/Lagos roads and their class(private drive path, two lane highway, dual carriageway, express ways, etc.). if I can't get it in data format, can I - at least - get a link to view the thing? can anyone post a link or so? Thanks. |
Hello all, Can anyone provide me with a link where i can get list of all roads in Lagos/Nigeria, this list should come with the class/type of road too, i.e., Expressway, Private drive pathways, Two-lane highways, Dual carriageways, Expressway etc. Thank you in anticipation of your replies. ![]() |
Notepad ++/vs code/code writer Simple, lightweight and dies the job for now. Notepad++ taking the first spot for its ease to customize. |
9.7 billion?! Some very powerful people bought these! |
Chai! |
I don't know if your tables are properly normalized, But if you wanna extract data from four tables, you needa use Sql joins. If you can't post the tables' structures here, post the tables and how the are related, I mean the primary keys in a table and the corresponding foreign key in a related table. I will check out your code when I get on PC |
MySQL joins will solve your problem. Take your time and learn simple join examples from W3school website. |
You mean the statement to executed should only contain unique operands(the numbers) that cannot be repeated, but the set (1, 3, 4, 6) may not be exhausted. You may use all operators, combine or just a single one? |
Craigston:Sure bro. I've only scratched javascript's surface, ain't pro. Still learning. My approach will work fine for a small range, but if the range spans accross thousands of data one will grow white beards, especially for a not-so-patient person like me. Besides, it just a challenge anyway. |
Craigston:Hahahahaha, I pray so Bros. I am still a rookie sha. the op was going on about using range, functions bla, bla, bla... I just solved his problem using a single function, the second function wasn't even necessary. |
i did PHP, using a recursive function, Mr. kodejuice function jarvis(&$i, &$j, &$count) { |
I will post my solution tomorrow. I like challenges. |
I don't have an idea of the rent of flats in the island, never cared for such. Rent can be quite expensive on the mainland, but choose where you can easily get straight buses to the island. Traffic situation after work hours is also something to consider. For me, I lcan do with Berger, Iyana-Ipaja, Ikeda, Oshodi. |
francollimasso:please do and post the solution here. |
francollimasso: |
'sale' is a noun, used in the wrong grammertical context in your topic. It should be 'sell'. Make corrections, pal. What is 'spacially'? You meant 'especially'? |
![]() I thought I was the only one that felt this way. I once was offered a position in an app/software development company; I was gonna be trained in few languages, especially good o' PHP. When I was told I wan gonna be starting with ZEND, lost interest. I specifically told the HR dude I don't like to be get started with frameworks. I just don't like building skills/foundation on frameworks. |
For the umpteenth time, programming languages are tools, they have their strengths and weaknesses. |
Gbemishile1:Been looking for such games a for a while now. From which site do you download yours for free? |
It's 'brand' new, not 'brown'. Make the due correction pal. |
The surname, firstname and other-names are a pair that makes up your full name. So, "my name is" is the correct form. ![]() |
Template of the view code: CREATE VIEW viewNoServiceYear AS After the view as been saved in your employee database, Query the view thus: SELECT FROM viewNoServiceYear When creating the view, include the fields/columns of your target from their respective tables from your database. This should solve your problem. Remember views are 'read only'. Content of your database cannot be modified from a view. So, views are safe and are updated automatically. |
Bro, if you want to sacrifice performance for flexibility, then you can create another column for the current date and/or time. MySQL has a function for that. Alternatively, you can create a View using the query I wrote up there. Sql views are saved and updated automatically,they are 'read only' too. |
oga OP, all you need is a calculated field in your SQL query. for a table to be well normalized, calculated fields must not be part of the original design. so your column 'C' should not be part of your DB table, instead, you generate it using a query - calculated virtual fields your table only need a column containing info about each employee's employment year, say 'employmentYear'; then query your db thus: study the following mysql functionsSELECT CONCAT(A, B) FORMAT(X, D) CURRDATE(), CURRTIME() NOW() MONTH(), DAY(), YEAR(), WEEK(), WEEKDAY() HOUR(), MINUTE(), SECOND() DATEDIFF(A, B) SUBTIMES(A, B) FROMDAYS(INT) |

