Search the Community

Hi All, Im building a Web App with 3 different types of users: Students Parents Teachers Should I store them all in one database table or separate tables? I am looking for the scalable best practice option with 4000+ minimum users. All in one table option, I would have a column with 1, 2 or 3 to specify the users type. Any help would be great, I can do both but looking for best practice really. Thanks in advance!

I posted this on Apache Friends but thought I'd post here too. I upgraded to Yosemite. I downloaded and installed the most recent version of XAMPP. I changed / updated the root and pma passwords in the config.inc.php file. I can see all DBs and tables, but cannot access any tables (!! exception = I can access the phpmyadmin tables). I can create new tables in any DB. Every time I get a #1146 - Table ... doesn't exist error. It is exactly the same problem as described here on stack overflow (with no solution): http://stackoverflow.com/questions/26438068/xampp-not-working-os-x-yosemite HELP! Thanks!

I have a need to generate many (50+) accounts. I can do this rather easily directly in the DB using PHPMyAdmin or the like. EXCEPT for the passwords. I am following the password creation methods using a hash as you have laid out in your book. Thus I cannot figure a way to create them directly in the DB because of the hash encoding used in the PHP code. Is there a way to create passwords without having to create them in the registration / edit user pages? Can it be done directly in something like PHPMyAdmin? Alternatively, is there a way to quickly create multiple accounts? (They could even have all the same password in this particular case I need). Hopefully the topic and questions make sense. Thanks! --David

Hello Larry, I am working my way through Effortless E-Commerce and can't seem to create a stored procedure using the downloadable code from your site. My issue I believe is my version of phpMyAdmin 2.8.0.1 isn't supporting delimiters. I continually get this error. Is there a way to work around this? ErrorSQL query: DELIMITER $$ CREATE PROCEDURE select_categories( TYPE VARCHAR( 6 ) ) BEGIN IF TYPE = 'coffee' THEN SELECT * FROM general_coffees ORDER BY category; MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER $$ CREATE PROCEDURE select_categories (type VARCHAR(6)) BEGIN IF ty' at line 1

Hello, I am using PMA Version 4.1.3. I created a datbase named "cars". I tried to create a table on that database, but noticed that there were three missing columns/directives. They are the following: MIME Types Browser Transformation Transformation Options Without these, I can only scroll horizontally as far as "A_I Comments". I understand so far that I have to create some additional table (phpmyadmin, maybe?) in order to enable these and other advanced features. But if that's the answer, I don't know how to do that. And the information on the web is rather unclear. I want to use phpmyadmin because of this book, as well as the ubiquitous nature of pma, in general. I bought a book on pma, and am using that, too. But I am taking that thing "page by page" and am not currently using it as a reference. I don't want to start using it to "put out fires" that I don't yet understand. Thank you, in advance, for your help! Roland

Hello Everyone, Below is a tutorial on how to enable Configuration Storage in PHPMyAdmin. XAMPP does it by default. But if you install MAMP—or if you install PMA as an individual component—Configuration Storage (and several other advanced features) are NOT enabled. However, I don't know if the same is true with LAMP or WAMP. Anyhow, you can view the tutorial at David Powers' website http://foundationphp.com/tutorials/pma_config.php. Best, Roland

Hello again, friends! I changed my password in MySQL, keeping the "root" component for the username. However, when I go into PHPmyadmin by typing localhost and then entering the PHPMyAdmin section, access is denied with the following message: "phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server." I am wondering what I need to do to be able to access the PHPMyAdmin area as I haven't done any work at all in PHPMyAdmin up to this stage. Please kindly advise--hopefully with some detail about the code if I need to re-enter the password and username I used in MySQL into PHPMyAdmin. Thank you!

Good morning everyone...when I start wampserver and try to get into MYPHPADMIN I get the following message Error MySQL said: #2002 - The server is not responding (or the local MySQL server's socket is not correctly configured) I've been able to access MYPHPADMIN for over a year and for some reason I can't now it is saying that "Access Denied: I'm not very technical and would need some simple steps to fix this problem. Can anyone help or point me in the right direction?...Thank-you....Tom