Comments by W∴ Balboos, GHB (Top 200 by date)

I will say it again: what is the level of the class you entered since you should be in a beginners class. And also, when did classes start? I don't know where you are located but in most of the world the university year starts in September.

No one here will do your work for you so figure out something else. Or maybe study subjects for things you like to do.

What are you doing in that class? If it's not a beginners class then you don't belong there. If you don't learn to do your own work and learn how to learn you are starting your career as a failure.

Do you want the type='submit' on that button - submit is for forms and is looking for an action. Perhaps try a plain button with 'submit' merely displayed text?

This is a re-post - DO NOT POST THE SAME QUESTION MORE THAN ONCE!
If you need to, fix the original.

Also, you php/HTML mixture is an extraordinary mess and likely will not work the way you think it will.

Actually I'm having a hard time finding the php in you code.

I wasn't even going near indices. Just the simple coding with a bunch of like clauses that may or may not have content along with the %'s vs. building the query piece-by-piece and just not adding the WHERE bits that aren't used.

That second path became necessary for one of our queries, indices and all, but it was heavily but necessarily over-stuffed with optional user filters. Even then, it took a while for the tables to grow large enough for it to show (i.e., a timeout). It's been preemptively applied to a few sister queries.

Mostly, tuning is done with indices and such. My boss (DBA) knows the inner workings and fixes these. Mainly, there's a boiler-plate root design because we most of this is done by the two of us - SQL mainly by him - and productivity takes a back seat to performance at times - since no one else, here, can do this.

Instead of "YES" I use a date-time stamp. I also separate the jobs (clients), freelancers, and the responses into separate data tables instead of perhaps on with longer rows. A response record, the table I mentioned, has a reference to client, freelancer, and the date/time if and when they respond.

You could even use this to resubmit to multiple freelancers until the double-yes is achieved and, once this is achieved, remove from active use any other references to the task. That is to say, a job is offered until it is accepted (common sense). You could even add another level and further separate your data by removing the task information from the client and just referencing the client with it. Now you can have a client list, freelancer list, task list that references the client and finally the responses that uses a combination of the first three.

I've got to go, now.

As you will be told, at least on this website, time and again: What have you tried? We're not here to do your homework - it's given to you so you struggle a bit and finally learn how to not only do the task but how to do other new tasks by learning how to learn.

SO - show us what you've done.

And what have you tried to mirror it (show code)?
There graphics available via javascript, as well, like SVG.

You say you tried it but I don't see it in your CSS . How can I determine what's wrong if it's not there? The link I included explains z-index. Make yourself a test page and experiment with it until you understand.

I was going to add, and maybe should have, that this might be some of the kindest advice he gets. I understand you took it as a berating but it's also a wake-up call. I didn't call him stupid or anything like that. It may be someone who is on the wrong life course - possibly pushed into it by parents or friends.

I'll try to soften it, but shouldn't there be some way of telling the poster that maybe they're in the wrong field?

It has been over four months since you first posted this and you still seem to have tried nothing. If this is important then maybe you should hire programmer.

Glad you solved it - for future reference:
If you get a solution that works the mark it "accepted" to close the question.
I understand your confusion. The "Solution" area is for solutions offered to the problems and not posting your solution to your own question (even though it seems to make sense). If you wish to post it, you can Edit your original, or, more commonly, put it in the comment thread of the solution that worked.

No harm done - but do remember to mark the Solution (Solution 1) as "accepted" to close the question.

First, that's not quite javaScript - it's jQuery (which I do not use).

However, it's great that you worked it out. You get two lessons out of it. One is the techniques that worked are now deeply learned. The other is the way to test you code to find out where it goes wrong (if you don't have a debugger then you can use alert() in javaScript and similar things in other languages).

Now - one thing to remember (here and in the future): if you get a satisfactory answer in Q&A then mark it accepted so that the question is marked "solved" and helpers can put their help into new questions.

The best option is for you to make a very simple page to work out what you're missing. Create two lists - only a few hand-coded entries each - where the values for both lists correspond. Add the onchange event.

If it works then you can look for error in your original - if it doesn't work on it until it does work and then update your original.

ALSO: in the function for the onchange event, put in an alert(val), especially if it doesn't work, to see what is actually being sent to the function. Also lets you know if it even gets to your function. You can even try this in your original version. Just have the alert() and comment out the document.getElement...().value.

Your instructor is being paid to instruct - ask him or her to do so.

Quick Hint: make your query first - then, once it's working correctly plug it into your code.

How ought we figure out anything when we don't have any of your actual code?

I cannot speak for ASP.NET, but CSS is not "glitchy" in this way - there is an error, somewher, perhaps other members of your CSS class (no way we can tell).

At his point, without seeing your data, I cannot go further. It may well be it is giving you the correct answer for the data you have. The UNION (even without DISTINCT - it's implied in UNION) supplies only unique records.

You do not need to run it twice with what I posted for you. It gets them all in one shot so if you run it twice each one will give them all and you get two of each!

Really? Twelve months? And, so far as your posting goes you have nothing to show for it?

If you want to be a programmer then you're not showing anything like realistic effort or (not intending to be mean to you) absolutely zero aptitude.

From an earlier question you posted you state " I have tried every tutorial but still have problems." - and it leads me to likely two conclusion:
1 - You're really in way over your head in attempting to write a program, even a web program
or
2 - You're trying to milk the work out of others, piece by piece, so you don't have to do anything yourself.

I'm done.

As you said, yourself "I have not tried anything yet, still confused on what to do. I have only made a regular table so far". You telling what you would like is not the same as you having actually put in anything like real effort. Your description "my effort" - does that mean your part and the remainder is for someone else to do? At best, you entered data - and created a wish list.

Do you even know how to code? If so - what have you done? If nothing, as I've said, come back after you have so we know it's worth some of our time because you think it's worth your time.

It seems like your asking us to supply you with the whole point of your assignment. You need to learn how to dig this stuff out of the internet. Just typing in code will not take you far in programming.

You have obviously missed your calling - time for that career change?

If not Shakespearean theater, perhaps kiddy show host?

Look at his code:
"var txtNewInputBox = document.createElement('div');"
and then
"// Finally put it where it is supposed to appear.
document.getElementById("newElementId").appendChild(txtNewInputBox);"

and finally you look at what he has tried - well look where the target for the string is being mapped:
"txtNewInputBox.innerHTML = "

Do you see it? NOT an element per se, but an object gotten from creation of the new node (element). For all practical purposes it can be anywhere. It doesn't need an ID or NAME attribute. The reference to the node was already created. His point is to give a NAME and ID to the element he just added to the DOM.

Your solution ignores his methodology - which is to create and add child-elements. Why do you think I didn't do the obvious and simplistic method you chose? Your route isn't very useful unless the original exists and has an ID of its own for the innerHTML method. Right answer to the wrong question.

In which case I gave the second version using "myObj" where it doesn't need the ID.

So where's your php? All I see is javaScript.

That, and of course, you already posted this question and had an answer.

Are you hoping someone will do all of this for you?

Well - it certainly wouldn't be the first posted code to have an error. Or maybe you're missing something?

OK - I don't know what the page is all about but suppose that $def['id'] is supposed to be $_SESSION['id']? Where would it get any $def values from, anyway?

When you say it 'Im not being able to get pass through that "if" ', do you get an error message? I'd imagine it could say something like 'undefined index' or undefined for $def, itself? You've got to describe the error.

You could try print_r($def) and, if it's defined, it'll show you all of the members of $def array. If it's not defined then it will give an error of its own.

https://www.w3schools.com/jsref/met_win_open.asp
On this page you'll see an example of opening a child wind, how to make sure it's in a different tab, and, at the bottom, the return value
"Return Value: A reference to the newly created window, or null if the call failed"

You can use that reference to access things within the window you created from the window that created it. NEXT, look at the examples on the page - they show you how one page can put data on another.

Note: if you find your question answered, here on the Q&A, then please remember to mark it answered with the answer you have used (to help others in need and save the time of helpers who will know it's done).

My first learn/exporsure to databases was a book with a title like 'database programming with C++ in 21 days'. All the examples seemed to be for FoxPro and finally I emailed the author on how the others stuff is done - and he admitted to me he didn't know how to use any other databases.

That, even with as written tutorial, should be instructive to you in its own right. Also, that entire book series isn't worth a used piece of bathroom tissue.

I do not write code for you - I tell you what needs to be done and possibly things to consider. You will learn nothing if I do it for you.

Telling you the methods to use has given you the answer. Computer programming requires effort - at least if you really want to do computer programming.

Think about why I picked out those two methods - how will they help? Solving problems takes practice - not google.

Actually, no samples beyond what you got in the previous email: <br>. You need to dig in and figure it out - and thus learn from this.

There are other ways in HTML to make a space:
Margins, for one, and <br> for another

So, you have an ADD button and onclick='addEmployee()'

And what happens in that function? Are we to guess? Considering that the contents of that function (at the least) are critical to the form doing anything at all, perhaps you should enlighten us!

For completeness, could you also add the "ANY" key to the switch?

As a general rule, no one here will click on your link and risk the virus/malware/etc. attack that may occur.

Give code.
Give error message if any.

Aside from agreeing with those first two comments, I have found that when I start a session it is best put on the same line as <?php

Now I'll ask you a question!

Extra functionality: does that mean features not part of CSS3 or just different ways to access them? Like jQuery not really adding to javaScript but just wrapping parts of it up as simplified access features?

If it does, indeed, supply unique functionality I'd keep away from it, myself as it would lock me into Microsoft's environment. A beauty of web development is that it crosses O/S boundaries effortlessly.

My sympathy for having a client tell you how to code.

I'd do a typical problem isolation by rolling back to the simplest level and then incrementing forward.
First - put the style in the element via a style= attribute and make sure that works
Second - go back to your sheet but change it from a "#" declaration to "." and then add that class as an attribute to your element first, as a in-file declaration and then via your external style sheet. This also checks your path!
Third, - go back to "#" if you think it necessary.
Finally, when all of the above are satisfactorily settled, return it to SASS.

If it works - done - you probably found an error somewhere. Done.

If it doesn't work, SASS is the enemy. Have you ever used it before? I have not - my editor is not VS, but MS Expressions 4 (obsolete, simple, and obedient). Do you have a simple and working SASS page for comparison?

Just break it down to small pieces and isolate the problem.

One problem is using a framework - and now you exchange some ease, up front, for a loss of true flexibility and control. That's your choice.

The solution you posed is, essentially what my second paragraph says: use the returned array and index through it adding items that are correlated via the index.

That depends a lot upon what you want to do with it.
AJAX returns are always as an ECHO of some string. It would also need a target element for the data or some other use - and that really depends upon what you're doing with the data. See https://www.w3schools.com/js/js_ajax_intro.asp for how to use AJAX - but beyond that

it's really up to you to return the data (as a character string!) in some manner. If you want to return the array then you can use JSON, as well, with the AJAX.

If/when everything's working, mark the question "answered" so it doesn't get unnecessary attention.

That's small enough to download the entire table. I talk about the arraylist object because you can access elements of its (changing) length via a random function of your choice and remove it from the arraylist. Pick another, etc.,etc.

Not via random access, but I've downloaded some rather larger arrays from SQL to javaScript on the page and used it to page through a table some fixed number of records (forward, backward, wrapping). A thousand is very small vs. a beta test of the paging we conducted with 50Kb data.

Adding/removing a sting in php code is generally very simple - that you have to ask means you probably wrote little of the code your using - maybe none.

If this is a problem for you then you should think about learning the languages before you mess around with the code.

/ Check if $myList is indeed an array or an object.
if (is_array($myList) || is_object($myList))
{
// If yes, then foreach() will iterate over it.
foreach($myList as $arrayItem){
//Do something.
}
}

Makes the error go away. Think: that means it doesn't try to execute the foreach() loop. That means the it failed both of your conditional tests. And if you think about it, that is why it fails in your program.

Check to see if you're actually putting data in $myList before you try to loop through it. If it has no data (but exists) it may be null or an arbitrary value.

What you posted, above, does nothing to help solve the problem.

Depending upon the server, file names may be case-sensitive.

I don't know where your files in in what sort of folder structure: you do. If a file cannot be found it is because what you are asking for is not there. Find out what's wrong with what you are asking for: Where is your page, where is the not-found page it wants to open? Exactly how is it spelled?

Now it also seems, with that copyright notice, that you copied the code from somewhere - Maybe you should figure out what it does and what it need. PERHAPS YOU DIDN'T COPY OVER THE FILE IT NEEDS SO IT CANNOT BE FOUND BECAUSE IT IS NOT ON YOUR SYSTEM.

I think his problem is that 'Nothing" is case sensitive.

Just a question on what may be a matter of taste.

When I'm incrementing through an array, for example, that needs to restart at the beginning when it reaches the end, I use modulo division and don't bother with the conditional. (such as

colorIndex%=colors.length;

in this case).

Any opinions?

You say you had a "hard time to find the right answer". I am hoping you're trying to learn to program. You shouldn't be looking for "the right answer". You should be looking on how to create an answer. How to do some specific thing - which is learning how to do something you can use again and again.

I pulled it from near the top of the list - it was apparently updated that day. So, by who? The OP, perhaps? Someone pulled it back to the unanswered cue's top with the update.

Maybe they were still waiting!

You don't have any time anymore?
How did you spend your time between when you got the assignment until now?

My stuff, at work, is mostly absolute or semi-absolute. The latter, div elements that that contain internal components that are absolute and it's location . . . depends. This came about, initially, because the workplace was split between FireFox and IE7 (at first) - now it's just FireFox but in order for me to pages work I turned to absolute positioning - and got quite used to it.

Since all my pages are born from php, I have the convenience of making pages that can calculate spacing/positions so everything always fits.

You don't have to declare your positioning type for every element. Now I do realize that % is very tempting. I've found certain other style don't seem to work without a real value. I live in px land but some new ones exist that I really should look into.

There's no simple answer: I just found https://web.dev/min-max-clamp/ and it would seem to be able act as an alternative to the media styles, each with different values. Some places give "best practices" - I say - you're own experience and way of thinking will create your own practices. I love tables - and don't give a crap that they want you to use div's, instead.

You've got to play around with this stuff until you develop your instincts (really knowledge that just flows).

Last thing: for this or any Q&A: if you get your answer mark it 'accepted' so it doesn't keep getting attention.

Just a thought for you - maybe it will save you from further searches and inquiries:

If a blog could be done much more simply, as you'd wish to do it, wouldn't that be something already done and tutorials available?

I can give you one comment, a bit peripheral:

Letting your users do this is a recipe for disaster - unless they're already quite astute with database usage. You'll still get your calls, only now, after their debauchery, you'll have a mess to clean up as well and will end up doing what they did so it works.

Toxic or thoughtful?   your question, if this was truly your purpose, was to bait someone into a negative response for a strong implication of laziness. Find someplace else to be with others who think their first impression should be negative.

However - if you feel it's toxic (indeed, I hope you do), you are welcome to leave. I'm sure stackoverflow will greet you with a hug and a kiss.

The response you want is the response you got - and . . . you're welcome!

Here's how you convert multiple related rows in a table to a single row.
SELECT A.commonality, A.val, B.val, C.val
FROM ATable as A
INNER JOIN ATable B
On A.commonality = B.commonality
INNER JOIN ATable C
ON A.commonality = C.commonality
-- The WHERE clause, although optional in theory will be necessary
-- to pick up the data you actually want
WHERE A.something is something
AND B.something is something_else
AND C.something is another_thing

Another point: if you will not always get a match for all columns and you want the results anyway then you will need to do things like LEFT JOIN or RIGHT JOIN to pick up the sets that are incomplete. Now if the value isn't always present for all of the 'columns' you are making they'd still show with a NULL for the missing values.

Experiment on something simple - once you get it you'll know the power!

I don't use vue or know anything about it. I use straight javaScript and straight php (HTML5, CSS3) - in other words, I'm independent of the whims of those who build these frameworks. You can pick up PHP pretty quickly at W3Schools if you don't already know it.

It (like javaScript and so much else) like 'C' - and even shares a lot of the same name functionality. I'll give you one heads=up to be very careful about.

If you start a PHP session, the session_start() must be the absolutely first thing on the first line - once other "headers" are sent you cannot start it (you'll get an error). Start the session on every page you wish to be aware of the values.

Finally - if you think all is well, mark the question as answered so it doesn't distract helpers from helping others.

somehow got popped to the main part of he list of active questions - makes it easy to overlook the dates. Hopefully he's enjoying driving his ice cream truck.

It was updated 10 minutes ago (!).

So, for lack of more information, it sounds like you copied a lot of code from online sources and want one of us to assemble it for you into a working project ?

Start here: https://www.w3schools.com/php/default.asp . Everything you need to know is there. With examples. If you need their SQL/MySQL tutorial, as well, it's there.

Post back with real problems based upon your own work (copy/paste from online sources does not count as work or a "what you tried".)

No - it would be going back (or forward) through the tab's history. Assuming, of course, you don't modify the history, first.

DOM can control the content of a page and also send you to new ones - I guess it may be whether or not you consider location, history, &etc part of DOM of javaScript.

A long-term hint: if you give it proper thought, you can set up your numeric array indices so that they actually identify the data. This is particularly easy in php since you can declare an array element without having to create the intermediate ones. An example would be using the year as an index dimension, then at the next level, the month (etc.). This way, if you had something you needed to put into January 1984 you could have an array element: stuff[1984][1]

Since it is php, you don't need to have empty useless ones such as stuff[1492] but you could create it at any time if you need it.

The idea is the value gives the index - you don't have to search: it defines itself.

Don't forget: if my or some else's solution solves your problem mark the question answered.

OK - then do just that: replace the dummy array entry, when you have a real one.

One thing you might want to do is to not have one big giant array for the whole week. Why not the same array for each day array and have each day in a member of the day-of-week array?

But you need to learn more about array handling in php - it's really easy but you absolutely MUST learn this!

Start here: https://www.w3schools.com/php/php_arrays.asp and don't miss the link to the various array functions (PHP Array Referenc) you can use along with just directly accessing members. https://www.w3schools.com/php/php_ref_array.asp

My style of responding is to not "give away the answer" but guide the user into to to get the answer - to lean - so they can do it themselves forever after,

I gave you a link for tutorial help. Also, the major hint "subquery" which can be used to control what you see in, for example, your WHERE clause. SUBQUERY - a lovely thing sometimes.

I have to assume you can do the following:
Write a SELECT query requesting the MAX() of some value
Write a query that can ORDER BY some value in DESCending order
Write a query with a SUBQUERY and understand the comparison operators such as <,>, =, != (etc).

You may wish to look into a tutorial as all of these are pretty basic:
https://www.w3schools.com/sql/default.asp

Maybe you're looking in the wrong spot.

Where do these dated come from that fill your table? If it's a database you have the ability to do this server-side.

Why not make your life a lot easier and use a simpler editor for your website - no inteference from VS and all of it's defaults and background handling.

I use Expression Web 4 - a now FREE Microsoft product. It understands (i.e., autocomplete) HTML, CSS, javaScrit, php . You save text files to the place you want to save them. If you create (or add) your files to a "website" in VS it handles searches and interconnected changes nicely.

It's simple. You get to know more of what you're doing.

No - I'm very simple about this. You can build a query string in a loop so it handles each of N components.

Another way: create a #temp table with on substring's match results. Then deleted from that table all that do not contain the other substrings.

That's really the same net result as the bunch of AND'ed LIKE clauses.

Nothing mysterious - straight up direct. If I were doing this I'd be building my string in php (or C or C++) and sending it to the server already built.

The splitstring results, in a series LIKE .... AND LIKE ... seem like they'd do the trick. AND's force all the matches but anywhere in a string would do it for each.

You need to build the QUERY dynamically based upon the number of elements in your split-string results (or should, it' makes a better exercise)

You still haven't said what's wrong - did you try anything and get an error? What was it? If you don't get an error message, what is happening? If you don't see an error message then you need to see what your SQL looks like - it all may be working and your asking it to change something that's not in your table.

Does any of it work?


You can't expect me to rewrite the entire section for you.

As a free bonus help: if you are using an indexed data type, like your $row[], you need to wrap it in curly braces if it's within a double-quoted text string.

Like this: $text = "My name is {$row['name']}";

How will your code know who-is-who? How do you know who-is-who? - use that information to differentiate you from not-you. Store each players "me !" information with them. PHP Session variable? Local Storage? Whatever is appropriate.

That link I gave you to W3Schools - they have a MySQL Tutorial, as well. The rest follows what I answered, initially.

Someone had to do something to push it up towards the top of the list - although in this case I think I agree with you. Well - at least now it's off the list.

Well someone posted this in your code sample,above:

"select * from Kitaphana" - my suggestion? Maybe try to learn some SQL before you try to use it.

To read one column you use it's name instead of '*'. You can list whatever columns you want, combinations of them and many other things - but '*' just means show me all of them.

Tell me - would you use a youTube video before doing your own dental work? How about fixing an automobile transmission?

Go here: https://www.w3schools.com/js/default.asp and learn the language - it's done in a very relaxed manner with the ability for you to try things out. You didn't even know what language variant you were using in your topic selection

Considering you are new to programming that is a rather ambitious project. I can't be sure about this but it seems either like homework, or worse, someone, somewhere will need to depend upon you design - possibly paying for it.

If it's homework, the struggle is where you learn.
If it's real work and someone is going to depend upon it (aside from you, yourself) then they are being cheated by the person who assigned this to you.

Again, I cannot be sure - but such posts lean in that direction

Each of your list has an onchange='someFunction()" event and its own ID (lets call them id='s1' and id='s2' .

When either is changed it goes to you someFunction() script.
Inside the script it tests the value from both

function someFunction () {
var test1 = document.getElementById('s1').value;
var test2 = document.getElementById('s2').value;

switch(test1) {
default: return a value when no s1 selection;
case a-possible-test1-value:
switch(test2) {
default: return a value when no s2 selection
cases that handle combinations of tes1 and test2
}
break;
case another-possible-test1-value:
switch(test2) {
default: return a value when no s2 selection
cases that handle combinations of this test1 and test2
}
break;
case etc etc etc
} // end of switch(test1)

You need to handle the various possibilites - including if either has no selection. How you pick your values is up to you.
}

Addendum to original answer: set up a screen dump of the actual SQL you're sending to the server. Is it what you think? Are the quotation marks properly matched. If you build the option lists as I noted, the values sent to the form target are ready for insertion "as is".

For example, is

 $sql = "INSERT INTO files VALUES (
   (SELECT * FROM customers c WHERE c.cust_name = $cust_name),
   $register_date,
   (SELECT * FROM objects o  WHERE o.name_object = $name_object)
   )";

really giving you what you want for input?

In my original answer I gave you a link to a tutorial that makes it very simple with examples. Please go there and see how it is supposed to be done and then you can understand why yours doesn't work.

My script, with the ". . ." was not a script. It was an example showing the beginning and end of the query. In other words, it was incomplete (that's what the . . . means).

If the error was something else then you should remember that if you don't post the error message no one can solve your problems.

You can also download and install the free WAMP server, Vertrigo. MySQL support is built in. Plain SQL add-ons, available free from MicroSloth.

I've used it for years . . . run's half the company where I work on a single instance.

Let's just consider the effect of the add-blocker (usually on client side).

It's an additional step that parses the page and removes object or not, based on it's logic. As an additional step it cannot help but take more time.

HOWEVER, IT'S NOT THAT SIMPLE!

If the ads it blocks are themselves slowing down the site then blocking them can actually spend lest time then rendering them.

Normally, the first consideration, above, dominates - but not always.

I gave you a method to answer your question which you will also to be able to continue to use for improving your work into the future:   speeding up your queries.

Presently I have my own work to do and cannot delve into the logic of your specific query as you keep expanding the scope of your question.

I think we need a new icon for Q&A: something symbolizing "pull the handle to flush".

At least as posted when I saw it, the loops are nested. I re-did the code wrapping and it's easier to see. Maybe this is an updated version and you're referring to the previous one ?

The formatting is really weird - printing by columns instead of rows. Somewhat of a mess - the displayed output doesn't jive with the code.

And how are any of us supposed to know how to get your store code when, at the very least, we don't know how your data is stored?

That, and from what you have tried, you don't ask for it, wherever it is.

Try using the debugger or other such contrivance to see what size is actually be set for the font.

Just a thought based upon how you wish to update the multiple-duplicate instances:

You would be creating a new set (smaller by 1) of duplicates. How do you propose to handle that, if at all? At the least, you'd need to run your procedure multiple times to get through this. Alternatively, you can serialize the duplicates.

My email? Not going to happen.
Use the forums -

Don't forget to mark the question answered so attention can be given elsewhere!

I cannot diagnose your system from here.

You have 'no idea where to look for problems' - what have you done?
Have you Googled for answers? Gone to any forums dedicated to such problems?

????

My suggestion (i.e., my php teacher): W3Schools
(actually, it was php 5, there was no 7, yet). I use it's references and those found at Official Manual.

I affirmatively do not use any form of ASP - my preference is for the open software available to everyone (free) and not likely to make arbitrary changes that force me to buy O/S upgrades.

There's no reason php cannot connect to pre-installed MySQL - if you have the connection string correct. I connect to MS SQL - totally separate application. Even on totally separate servers. I don't use IIS -

From your writing, it sound like you already have php installed. Is it working as php? Why bother at all with that limited version of IIS when the Vertrigo server is a full implementation of all of its contents? PHP->MySQL is a built-in set of functionality by default.

I would conclude that you can't connect because you have the connection code incorrect or you haven't given yourself access to MySQL.

Debugger . . . . ???

If any of the solutions answer your question, don't forget to select it an mark the question as answered (and thus allow attention to be given to other questions).

It's all in that WAMP package - all nicely integrated together (apache for your server, php for it's www folder content.

What flavor of php you have depends upon what version is with the Vertrigo you install. It's complete, as is.

Currently, where I work, that freeware serves about 100K pages/week without a hitch and has done so for years.

Generally, it should just work - what do you see (or not see?).
If you see nothing at all, then just for laughs, give it a real length and width.
If you see an empty rectangle, try copy/paste from your URL. First, another page in your domain and then other. Just t be sure you've got your syntax correct.

Whatever your reason, the rules for php won't change for you. You need to define a variable before you use it in such context's as an array index or function argument.

Supposed it let you do what you wanted - from where would it get a value?

You need to get a value into $transaction_id before you use it.

You haven't told me it's yours - and a good thing, since the commentary is clearly not yours on grammatical and syntactical grounds. You come here for help - but not for your own work but to have us complete the acts of copy and paste so that it works. The disrespect is, in fact, your trying to use this forum to do your work for you.

For help, yes - for grabbing hunks of code and trying to pass it off as their own and needing help to make it work because they're clueless about even the fundamentals? It is getting more common - and is pathetic. Don't confuse "help" with "plagerism"

Thanks. I'm rather old-school and used to do various numerical modeling applications. Often, an "call" would happen tens of millions of times. That really adds up with functions vs. inline. Remember, too, how much slower CPUs were. So - the habit sort of sticks - doesn't cause any harm if it's a one-time event.

Think of a pecking order of efficiency:
Direct inline conversion
Function-conversion via by input strings
Function-conversion, a character at a time.

The last, obviously extreme, emphasizes the point - although I'm quite sure you already have it. Someday, you may even need it.

Neither is bad - but the if this were done a lot, each function call would have overhead such as pushing and popping stack values. Now if this is compiled, the function could possibly be inlined and do this anyway.

It just saves overhead but requires you code a loop instead of a function call with an input and returned value.

Internally, one way or another, you'd be using the lookup table concept in a function.

There's available free version of SQL Server - limited number of connections.

I suppose you could dig up a copy of FoxPro, somewhere - although far better than Access, it hasn't been supported in years.

If his equipment is so old it cannot support any of this - he's long passed the point of saving money by not updating.

When you finally figure out how to use the data from the answers, consider, as well, how to make sure you actually have pairs of IN/OUT times for each employee - if they didn't do an OUT - what will you do? What if they skipped OUT on day one and IN day two ? Summing the daily differences is, in fact, the easy part.

Your code is NOT javascript. Maybe jquery? You should make it your business to know what you're using - the answer depends upon it.

1) Why didn't you ask the source on stack overflow?
2) At the least, come back AFTER you try something - this isn't a code-writing service. Try to figure out what to do.
3) If (1) and (2) don't work, then perhaps just find something else to keep you busy.

I disagree.

Take for example his "expected solution" post. It really means "wanted solution" - he wasn't given what he wants on a silver platter.

On a different Q&A, I went against the crowd and gave an hint - even if it was homework - because it was a push in the right direction and still required their homework to be given some work.

Here - it strongly indicated someone who'll spend their life looking for someone to give them "The" answer.

Googling, itself, is a skill. One anyone in this business of ours should learn and learn early.

A developer needs to use their brains and figure things out. If you think you'll find everything exactly as you want it you are in the wrong business.

Expected Solution?
If you know what to expect then do it.
If you don't know how to do it how can you expect anything?

In either case - you call yourself a 'developer'. No - you want to be a developer. You've a ways to go.

Google it - not much harder than posting here.
And bookmark the anyplace that's a good reference.

It's unlikely anyone will read that book of code you posted = unable to connect almost invariably implies either your connection string is bad or you don't have permission. Trim the above down to the connection string.

Every element can be read, via the DOM, for example, as a value, or, in some cases, as the innerHTML. As for which to read - you could associate the id of the text containing area with the id of the checkbox (area1->chk1, area2->chk2). There a so many ways to do this sort of thing, depending up the circumstances. If you must use a form, then the checkbox state can set/clear a value in a hidden form element. If value not empty, save; if empty, ignore.

Use some imagination!

Also - you're using jQuery, not just javascript. There's a difference.

Now, I didn't mention a country - so you clearly have one in mind.

However,

I've seen and used software made in "The Land of the Call Center" and it reeks of the quality of how the programmer-curricula are designed to turn out huge numbers of incompetent fools. Sad, indeed, because some excellent programmers will be lost in the vast crowd of substandard drones.

Upon reflection - even the standards for the call centers have gone down.

Check how you are initializing the value - it should be zero. What have you done to make it otherwise? You should be controlling the indices values, possibly in a loop. How is your loop initialized? If this is the basic start of the application than you need to make sure you do not assume any of the initial values for your symbols. Test them !

The debugger is your friend.

It returns a string - ECHO it

If you've just been cutting/pasting and don't really know how to do this I suggest you try: HERE

For VIEWS, use

CREATE VIEW viewName
AS
. . . put your SQL in here . . .

See here: https://www.w3schools.com/sql/sql_view.asp
You'll never learn to do things until you struggle a bit with actually doing them.

Also, when your question is answered please pick the answer you like and "accept it" to close your question.

In general, and slightly leaving the scope of the question, would a DISTINCT directive be a good idea to add to this? Not knowing what the data looks like, the potential for any number of duplicate records exists (particularly if there's no unique id'ish type field in table2 or table3)?

Of course, they may want the duplicates.

One problem with your reply . . . it doesn't change the fact that you're trying to get through school on other peoples brains. The quality of development I've seen coming out of India only goes to confirm my assertion.

I suggest you retrain for work in a call center.

For now, get over this idea of 'certifications'. Being certified doesn't make you good at anything. Perhaps knowledgeable, but no skill in usage is implied . . . certainly not in real life. Like studying music doesn't mean you are able to play music, let alone play well.

This would be an incredibly dangerous feature if it existed. You data and personal information can be passed system-to-system for any purpose. Sessions were not designed for this. Consider them a mechanism to keep you client and the server coordinated during the brief periods they must share information - before the server drops interest in you until the next data request.

Data can be transmitted, for example, via the URL across systems.

Try running this without wrapping it in a transaction - if it works than adjust your code/query order appropriately.

Do you have google on the internet where you live? If you do, did you try it to find entity classes? A long list of v's as to what you've done so far is not going to encourage anything in the way of a response.

Did you run it? Does it work? What is it that you want us to do?

Not using built-in methods? Does that mean for the date difference or does it mean anything having to do with dates?

Please revise your question to a specific question.

As noted, non-conventional.

Since it's internet based - how much loss will really be observable in performance?   It's not how I'd do it. It appears, as submitted, that the activity of the items is link-based - so no events (if you don't count clicking a link) are in jeopardy. It does, in its way, illustrate my strength and hamartia: Aut inveniam viam aut faciam

And ultimately - it will, at least, work.

What you can take away from the above answer to the question and your own comment is that you need to plan your data storage carefully. The difference can be between making things easy and making things very difficult or impossible.

It is one of the most important steps.

Good catch. I guess he'll need to leave the commas in place! Meanwhile, tail between legs and grinning on this end.

Philosophical Interlude:

A few things are all but ubiquitous, like "googling something". On the other hand, the internet is a big place and room for an unlimited number of private views of its world. Still, one becomes familiar with their view and can forget that it is a unique place.

For example - here, at CP - approaching 14 Million members - so one can safely assume that most people have not heard of it. It's all a bit amazing because of the scale, flexibility, and constant change.

So - nothing to be sorry about.   In fact, I've been into photography since my pre-darkroom days (B_&W, of course). Not as a collective - my world, but I should get around to more of that. You've supplied me with reference material.

That's why I called it a back-handed solution, although I wasn't thinking of it as homework. Aside from that, neat way to recast the problem, no?

Aside: For the small arrays, shown, that would be OK. However, if the matching fails then the search needs to continue just past the last initial match to see if the substring still exists further down the big string. Just noting, really for the original questioner, that "it ain't over 'till it's over"

Demagoguery? In your vocabulary, that seems to translate to any suggestion of imperfection another might observe in you. Well - if that's how you see this place, why not find another more to your liking? Let me ease your conscience with the assurance that you will not be missed.

Neither did you write as to whether or not you'll bey at tonight's full moon.

The Point?   We don't know what you won't do, just because you didn't mention it. The information you mention, DOB, has legal restrictions on its distribution - is it not better I err on the side of caution?

Well - I didn't know about IMGUR until just now. Don't assume that something very familiar to you is familiar to others. The real point is, however, that a link can be pointing to a malicious website (or one newly compromised by a third party).

I would NOT want my private information, such as my birthday and email address, posted to any third party cite without my permission (like mailchimp). That's some serious personal information you're giving away!

I would suggest your first study on how one creates a search engine, and/or, trains one where and how to search.

You don't give us any information at all - presumably you have no clue as to what you are doing. Building a website is more than just putting words and pictures on a screen. If you want to know how to build a website - or do anything else in this world - you'll need to study how it is done.

Well perhaps because I don't complain about it (because I'm among the hapless who answer them when they reappear because who checks?).

What drew my attention was the down-vote that was, as it turns out, given across the board. I suppose it can be traced, but likely the account is abandoned and a new one created.

Per your reply to Solution 4 - I just pulled it off the list - which I rarely if ever check for currency as it's the 'live' list. But Alas, the deed is done.

2014 !

Do you really think a good solution is to retype the table? He may as well type his original data into a spreadsheet and manually pivot it, for example, with Transpose, as needed

Well - so far you've done nothing. If you're just learning, the first thing you should learn is how to look things up and not ask someone to point the way.

I gave you a site, somewhat pre-selected to your needs, that will teach you how to make a link.

I mean, really, what did you expect from your post? Ready-to-run code (ASAP, no less)?

You learn by DOING and STRUGGLING not COPYING!

Consider that once you hide a row with a button-click, if you wish to un-hide it how do you do it - aside from a separate button to "unhide all"?

Is that all you have? One incomplete statement? How are we supposed to know what you are doing and what you have done.

What do you do and and what happens for you to decide this doesn't work?

Let me rephrase for you what is in the past several responses:

You show us what you tried. Well? What happened?

As you wrote it, for all we know, what you tried worked perfectly.

Why do you has AS to name the return field in subqueries?

It would, of course, be useful, too, if you:
1 - gave us the actual error message your received
2 - respected us enough to actually write out words and not use texting garbage abbreviations.

Did you check the page source to see if your script even got there, and if so, that the relative paths are correct?

That's quite a chain of events you wish the store procedure to implement. From your "What I have tried:", the answer is apparently - nothing.

Quiz systems are available all over the internet.
Try some google searches.

Thanks for the thanks. As an aside, if you post in Q&A and get a satisfactory answer, you should mark it 'accepted' and thus close the question.

It's not done nearly enough - but good housekeeping and all.

Oh - a coding tip:   I comment my code. Not for just other programmers but for myself. You good stuff may be use for years and YOU WILL FORGET!

Somehow I remember doing this type of thing in the past - but obviously not with the div. If you check my revised answer, I gave a link to one of the various work-arounds. Now I'm wondering if this was something I did in .NET just transferred the idea without check. Glad you caught it. The idea of hiding the link (via div) would work but isn't really what's asked for.

So you can't look into Access features and find the same functionality? If that's too hard to do, or too difficult to grasp - you should consider another field of study as soon as possible.

A bit of a warning for your future coding.

Although, in javaScript it doesn't matter, there is a difference as to how calculations will end up if you use 1000000 and not 1000000.0 - in how they are stored, which number is first in a calculation if you mix types, and any number of other rules for a language implementation.

Round off errors during calculations could give you unexpected results.

"Seriously" - from the small patch of code you include with your question and all the missing information (like how and where do you build $connection), that's all the information that I can offer.

Several different tests you can do. That's how you debug a problem. Break it down until you see the bit that's not working.

Try using a debugger to see where your code goes wrong.. If you don't have one and plan to continue writing code, you should get hold of one.

So, since you say it looks the way you think it should and it works when run directly, you need to check your php connection.

$result=mysqli_query($connection,$query);

And I don't know you parameters, password, or system, so that's something you'll need to work out yourself.

ONE MORE THING: Does your code even get as far as the MySQL call? Check that, too.

I asked two questions:
1 - Does it look the way you expect it to look?
2 - If you run (the result of 1) it directly on you MySQL server, does it work?

If it works than you need to check you connection string.
If it doesn't work when used directly - then it would not work through php, either. You need to fix it.

But first, make sure it works without php. If necessary, post the result of '1'.


If it

No problem with php before the DOCTYPE.

In fact, a session must be started ABSOLUTELY as the first statement following the <?php or it will throw an error (headers already sent).

Try debugger.

Am I to understand you correctly:   you don't know what you need to do to divide by twelve ?

Don't know how to create what? A key? At table? The query to use a key?

SO far, your error description is a 'blank page'. How is anyone supposed to help you with that error? It's your code on your computer - so find out the error.

.

If you want the search results to be triggered from your table you need to populate the table with reference to the links (link or AJAX). I would use AJAX.

However, if you just started learning PHP, you should spend some time learning it before you make a project spanning so many features. The expression "crawl before you can walk; walk before you can run". AJAX calls php through javaScript.

Check any maintenance cycles which correspond to this failure schedule.
Also, check your applications for memory leaks.

C# has a namespace for access to the databases
- build the query that calls your stored procedure and use it.
- when the results come back - do what you want with them.

You "WANT" a lot - well, then start looking up how to do it! You have amazing resources available to you with the internet. I taught myself to do these things from real books - limited resources - and a lot of resolve. You need to make the effort - which is usually hard work.

Also, note that "c.customer_id = 'cus1' " in your query, above, is going to really limit your results!

I do so on a consistent basis.
Are they on the same instance of the MySQL server? Are all the permission in place?
You may need to link the servers.

Since you've not supplied your actual query, I can only guess at some general problems.

Maybe he did and got an Indian customer support service call center and . . .

Maybe, since you also seem to have c# available, you should read the flat file and use String.Split() on it? Then you can insert it in a preexisting table and be done with it.

If your talking about each individual row, you can add a new field of type INT, and then, per the link I gave your, convert it to an IDENTITY field. It will automatically fill with sequenced numbers.

You can now select any record for any process by referring to this value in your WHERE clause. It will always return just that record as these values are NEVER repeated. You have to determine how your list knows which record identity to associate with each item. Fill the list via a query or hard-code it.

NOTE: if you find a answer that solves your question, mark it as accepted so it can be properly closed.

When I think about it, I don't actually know what a 'banker' is, except for someone who works in a bank in some way.

But - you've been an IT Tech for seven years and started school in this last year. You really don't qualify as 'new' to the point that your question's quality implies.

Where I am, there are IT techs - keeping everything running. They do not (and generally, can not) write code. They set things up and fix things. Some help users. The very clever ones even have access to account maintenance. But they don't code.

That's OK - but the question, after all these years, is what are you looking for? The way to code is to attack the question with all your resources - look things up (and thus learn them) - particularly, the basic operators for our language of choice. 'C', by the way, is not an easy starting point. How did you come to select a course in 'C'?

Two things:
1 - easiest solution all around - let simple Q&A go as just that
2 - Why does Sean have a negative rep-points total? Does he have so many it rolled around in a signed int, or . . .

Now I feel like a hamster running in one of those wheels.

Wheeeeeeeee!

Checking the dates - I can see how that makes sense. I'll probably end up doing it again because, alas, I often zone-in on things (quickly) and reading the question, existing answers, and determining if I've anything of value to add consume most of my mental threads.

None the less, I'll still try to keep check-the-date in mind, somewhere. Maybe when I read the "what I have tried" part.

Maybe a way to close out a question (after a year or so) to any further answers might be a solution?

Well - I pulled it from the 'current' list. Something brought it up. I noticed, now that you pointed it out, that answers are mainly 2012, another at 2014.

Perhaps solution 8 will satisfy whoever keeps activating it? For whatever reason, it was just updated. Maybe they're still working on this problem?

I only follow links from trusted sources -

Is this even your code? You don't know what language it is and apparently haven't a clue as to what you're doing.

Maybe you should find out who made it and ask them!

Duplicate Entry - Other already answered.

It sounds like a product for a business - which they will use to make money. If that is the case, they should pay the developer. If that is someone here, at code project, then they should be compensated for their time.

I was going to help - but I saw your attitude.
So - you continue to get nothing.

Stop Re-Posting this question.
You've posted it (at least) three times.

Stop Re-Posting this question.

Please reread my previous comment.
Or find a WordPress forum, somewhere, with people who like and know WordPress.
I am not one of them.

I suggest that you pause in your work and study how WordPress actually works (if you plan on continuing to use it). I create my web pages "from scratch" and they are just plain files (.php, .js, .htm, .h and .css for example) and they are stored exactly where I put them. You are in WordPress' world and you need to study how that world works.

It's not likely anyone will read your listing - especially since you don't even give a hint as to where it's gone wrong. Reformulate the question so that the problem is highlighted - not hidden.

Wordpress is completely database contained. Even the pages. There are probably online forums about where these things are stored and how they work together - but that requires you have access to that particular database. Unless it's your own copy, you most likely don't - will need to find whatever interface it has available for such control.

Both myself and answer (1) have supplied you with some help. Problems pointed out and alternate methods of getting date difference.

That's help. "Do my work for me", if that's what you mean, is not help.

Contact your bank - and hopefully they'll tell you that you cannot do this! If anyone could write software to access bank accounts so easily, you'd be quite a fool to put any money in them.

Path where you need to put the cookies? No - cookies are put in a browser determined location.   Mozilla: the cookie jar; IE, each was a file; Chrome: whatever.

Check the cookie filter settings on Chrome. Also, are your cookies being set for your current site or for a third party site? That matters.

Your answer's close enough to mine that I won't submit one. Here's the change.

int counter[2]; 

Then, for all numbers you could simply have:

counter[num&0x01]++;

Just a nuance, but I thought you might find it interesting.

Think of it as an assault on castle. You have powerful allies, like google or even bing - especially if you have an error number or cut/paste the exact error message.

Like programming, itself, it's really always made of a lot of small pieces. Even the failures often end up helpful.

That being said, it depends upon where your strengths lie. You'll find many programmer on this site more knowledgeable than I. My strengths are in (very rapid) problems solving (and clever retorts). No compartmentalization of knowledge. Your assets will likely be different. Your contribution to countless gestalts.

Google is your friend (C# stacks)
https://www.dotnetperls.com/stack - for example

There are a few basic commands push, pop, peek -
You need to do the comparison based upon whatever type you are trying to compare. In your case, the type you'd most likely use is string - and depending upon your source, you can make comparisons case sensitive or not (human or machine generated).

Stacks are really powerful and important tools - essential for a parser - which is what you're making.

You push 'opening' items, be that tags, parenthesis, quotes, whatever. For things like tags or closing parenthesis, peek at the top item on the stack it must match if things are to close in the order opened. If it matches, pop it off the stack (it's closed and thus complete). If it doesn't match - you have found your problem.

Select A.Colum1, Sum(A.Colum2) - is only looking at data from the "A" return values. The only thing your join is doing is acting as a filter to limit those that come back to those that have matches.

You can join a table to itself. It's actually common.

I use it, for example, to take rows and convert them to columns. Actually exactly what you're doing if you think about it.

Just give each version of the table its own letter
SELECT A.x, A.y, B.y, C.y from TABLE as A
INNER JOIN TABLE as B
ON A.x=B.x
INNER JOIN TABLE AS C
ON A.x=C.x

This will give me the key (x) and the values for y as three additional columns. You probably want to name the columns, as well, so they can be told apart.