Win a copy of 97 Things Every Java Programmer Should Know this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

How to know whether my PHP software having a PHP server with a MySQL Database

 
Ranch Hand
Posts: 388
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

How to know whether my PHP software  having a PHP server with a MySQL Database?

Suppose after you advise like this check..blah--blah-blah..

then i don't find it in my PHP then what to do and how to get it so that if i develope something in PHP web form and then i need to interact with huge database tables?



Thanks much..
 
Ranch Hand
Posts: 127
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry, but: uhm, what?
May let me suggest you to re-phrase your question?
It's not really clear what you're asking.
If you want to check if you have access to database connectivity you could check if modules like mysql/i/nd or pdo are present - if they're not loaded one may think of implement a mysql driver by using fsockopen - and I'm sure someone already has done it.
The other way would be: On whatever server you want to run your code one, unless you're its admin, you can always ask the admin if php, any database (there'Re more than just mysql/mariadb) and the required connector are installed.

This question somehow reminds me of what I got once from someone:
"Yea, we'd like to develop some sort of firewall-breaking proxy code ... blah blah blah" - I just replied: "Well, if you have your software run at some remote location and it requires a connection back to your server tell the admin to set up a VPN - or at least open the required firewall ports." - We argued about this for about 1 or 2 weeks and then I said: "Well, k, I don't even know my way around DotNet / C# and I think your approach doesn't seem doable - aside from all of the security issues - I'm out". TLDR: If you have some requirements don't try to figure out a away around it - talk to the admins to check if the requirements are met and demand what you need. That's a way to go within hours instead of wasting weeks on something doomed to fail.
 
John Ken
Ranch Hand
Posts: 388
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I was able to find it under XAMPP (Conrol panel V 3.2.4 ) and I just started 'MySQL' from it then executed my SQL query in My Sql data base( not sure whether i have selected correct data base here) then  i got this error :-


CREATE TABLE `task_list` ( `task_list_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `task_details` text NOT NULL, `task_status` enum('no','yes') NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;'



But when  I just  clicked on 'Go'  button there then  got  this meesage  ' MySQL returned an empty result set (i.e. zero rows). (Query took 2.2344 seconds.'  

Is it any  error or my table got created successfully ?


 
Saloon Keeper
Posts: 6448
158
Android Mac OS X Firefox Browser VI Editor Tomcat Server Safari
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MySQL has a command to list all tables; that'll tell you.
 
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic