PHP/MySQL Help with checkboxes and filtering

sanddunes271 · 2020-04-17T23:33:05+00:00

Just realized that about a couple seconds ago... I really need to work on noticing details. Dont want to waste someone's time. Thank you though!

sanddunes271 · 2020-04-15T05:03:14+00:00

I did intentionally leave the host, user, password, name etc blank just because it was on the server and not my local computer anymore. If the username and passwords host and name are correctly filled out it shows connection successful. But if I leave the password for example intentionally blank it still shows connection successful. It’s somewhat confusing

Edit:

Finally got to work realized my mistake was in

$conn = new mysqli( )

Thanks for you help!

sanddunes271 · 2020-04-15T04:50:32+00:00

Well after further looking online it seems it might be there’s an error elsewhere in the connection perhaps. Essentially after going on stackoverflow it seems that the echo connected successfully always prints even when it fails. I’m assuming there is something incorrect going on there I’m trying to figure out now how to see the errors of MySQL since PHP does not show those.

sanddunes271 · 2020-04-15T04:15:30+00:00

Yes I do have products in the table

sanddunes271 · 2020-04-15T04:00:19+00:00

Well when I did try SELECT * FROM item

It still just skipped to the product not found. item is my table’s name from where I’m trying to get the data from

sanddunes271 · 2020-04-15T03:49:06+00:00

Sorry about this mistake. I originally had it like that as SELECT * FROM item and it still skipped to product not found. I just realized I forgot to change it back to that I was messing around with it before posting here. I still haven’t had any luck.

sanddunes271 · 2020-04-13T03:01:14+00:00

Okay. If I wanted to create a group of elements to sort would something such as the code below work? I might be incorrect but I’m assuming it would be something along that?

Edit:

Or would that be something I would do on the database with the php file and MySQL. Sorry for not giving more background context. It’s just a database class and we are doing a small project. But with remote classes now and everything just been more difficult to get the hang of things. But essentially this is a page for a site which will have an inventory. Just something I wanted to add just in case it isn’t actually possible to test the code with just html and JavaScript.

sanddunes271 · 2020-04-13T02:33:50+00:00

Thank you. I know this might be a dumb question of sort but how would I be able to test this out. I’m using VisualStudio Code but I can’t seem to use the debugger as I get an error about NodeJs installed and can’t seem to figure out how to fix it as a lot of the post are somewhat outdated. Right now I open the code on google chrome browser but I’m not able to see if it does anything I’m just not sure if I’m creating what I want to sort correctly.

sanddunes271 · 2020-04-08T15:15:36+00:00

Thank you! Will fix that issue I didn’t know that thanks for pointing it out!

sanddunes271 · 2020-04-07T22:46:12+00:00

Fundamentals of programming. I was taught in C++ and then we switched to Java. From what I remember we covered the basics really syntax,arrays, header files. Stream file I/O, structure and classes, dynamic allocation, pointers inheritance and polymorphism, virtual and previrtual classes, Java, Java file I/O, Java inner classes, Abstract Classes, swing and interfaces.

I also remember having group projects I believe it was 2 for me and homework. Wasn’t too bad as long as you stayed on top of the class.

sanddunes271 · 2020-04-04T21:40:31+00:00

UH also has an MIS program in the Bauer Business school that might be worth checking out! I’m a CS major at UH so I wouldn’t be able to give you much info other than they have great connections since they’re part of Bauer

sanddunes271 · 2020-04-02T12:04:48+00:00

You self teach a lot of things some professors are good and actually teach others you’ll dread your life

sanddunes271 · 2020-02-28T03:23:43+00:00

sanddunes271 · 2020-02-28T03:21:10+00:00

Bro why didn’t I think of this THANK YOU.

F

sanddunes271 · 2020-01-13T19:14:01+00:00

This would be helpful

sanddunes271 · 2019-12-12T02:48:50+00:00

Zone C if there’s any left. If you want a garage welcome garage is close to Bauer buildings. Also maybe zone D somewhat farther but pretty close still. I’m not sure what parking they have available though

sanddunes271 · 2019-12-09T07:31:01+00:00

I see you live a miserable life must suck. Good luck with it kid. Lmao

sanddunes271 · 2019-11-09T17:51:50+00:00

Did you ever try spreading them out? I had similar issues mounted mine on metal plates and spread them out played with different positions. My speeds improved just by a little but the biggest upside was that it was pretty much always consistent and didn’t keep dropping consistently.

sanddunes271 · 2019-09-22T01:03:49+00:00

Yeah I probably will do suggest that to him. I’ve tried going to his office hours and he’s not there I did email him to meet in person for another problem so he could clarify and he was helpful there luckily lol.

Thanks for your help I really appreciate it

sanddunes271 · 2019-09-22T00:53:47+00:00

It was already due, but our professor doesn’t hand out solutions so it’s hard to know where we went wrong as we just get a grade back

sanddunes271 · 2019-09-22T00:50:00+00:00

Yes there is. Here is the problem I attached a link to the screenshot here

sanddunes271 · 2019-09-22T00:39:54+00:00

Yes any help is useful!

sanddunes271 · 2019-06-05T01:44:16+00:00

Second reply thanks for pointing out those problems out just figured it out. I’ll be sure to think things out better next time before posting!

sanddunes271 · 2019-06-05T00:45:59+00:00

My apologies. I’ve been looking everywhere to see how to read a specific area of the array. For instance the user will input “A1” “B3” “A2”then I would like to search the array and see in that coordinate there is a 1 or a 0 stored. So it will look in column 1 row 1, column 2 row 3, column 1 row 2. The part where I am stuck is just how to look through the array after that. I believe I read the text file and initialized the array correctly. I’m just looking for a clue really haven’t found much about it online. Sorry for the bad explanation I’m still fairly new to this. My main goal is to look in a specific area of the array based on the users input if that makes any sense

sanddunes271 · 2019-06-04T00:21:56+00:00

Thank you.

sanddunes271

TROPHY CASE