If the DVD drive is still working electronically, it will show up in the Device Manager. Just right-click on 'This PC' and choose Manage. Once the Computer Management console comes up, click on Device Manager. You should see DVD/ROM devices. Click to expand that and you should see your device.
If it is listed there, it should show on your File Explorer under This PC with the rest of your drives. If it is there, when you insert a DVD it should read it and then, after a few seconds, the File Explorer should show the name of the DVD. If that's not happening and you listen closely, you may hear the drive repeatedly trying to access the disk. If that is happening it's usually a sign of a dirty disk or dirty DVD unit. Check the disk carefully for smudges and try a couple of disks to find out which it is.
If you determine that your DVD unit is bad, it depends on your system what you might want to do. Since you have an LG DVD player (I have LG units on both my desktops), you might want to just buy a new one. They are extremely cheap if it is just a DVD and not a Blue-ray device. At Newegg, they run around $20. Refurbished units are even lower, around $15.
Good luck. I hope you find out what is wrong.