Is there any way w/o majorly rewriting the phpMyAdmin source code to have a different theme chosen based on server? I see it's easy to change themes, but it applies to all servers. Reason I'd like to do this is so that when I perform a query on production it shows a different color right there and I won't confuse it with a query on de...
Hey SO PHPmyAdmin keeps rejecting this mySQL im pretty sure its right and don't actually need it to run, its uni work and just have to hand in, it looks right to me. the actual error I get is #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 '...
I've set up PHPMyAdmin on a Mac, and it's complaining that it can't load the 'mcrypt' function(s). Apparently the stock install of PHP on Macs doesn't have it. Can anyone tell me what the implications are? Neither the PHPMyAdmin documentation or the PHP documentation seems to tell me what kind of problem, if any, this will cause me. Th...
Running this procedure causes MySQL (or phpMyAdmin) to freeze. I have to stop MySQL with from XAMPP command, which freezes and "is not responding" about 20 seconds before stopping. I believe this is caused by the delimiter command, which on it's own begins the problems. I have tried using a different delimiter ("//") to no effect. Any h...
For my search I use multiple queries and I wanted to measure how long it takes mySQL to execute them all. PHPMyAdmin runs all the queries you give it, but It only give the results and execution time of the last one. Is there any way to see a combined execution time without getting out my calculator? :) ...
What I am looking for is a php function that takes an unformatted query like this: $sql = "select name, size from things where color = 'green' order by price asc"; so that it would appear in an HTML page something like this: SELECT name, size FROM things WHERE color = 'green' ORDER BY price ASC'; There's some co...
Thanks for all your help, I now have add, update, and delete functions on my database manipulation program. But I'm having difficulty on searching for records in mysql database. Please help me in correcting my codes, and if you know a site that I can use as my reference please do tell. Thanks, here is my search code: <?php ...
I have uninstall wamp server and now I need my database to restore. How can I do this process? ...
Table Name :: Feedback_master Fields 1. feed_id 2. roll_id 3. batch_id 4. sem_id (semester ID) 5.f_id (faculty Id) 6. sub_id (subject Id) 7. remark. 8. b_id Table Name :: subject_master Fields sub_id (subject Id) sub_name (Subject Name0 f_id ( Faculty ID) Table Name :: faculty_master Fields f_id (Faculty Id) f_name (Faculty Nam...
Here is the code that I'm working on: login.php: <?php $con = mysql_connect("localhost","root",""); mysql_select_db("koro",$con); $result= "SELECT * FROM users WHERE UNAME='".mysql_real_escape_string($_POST['Uneym'])."'"; echo $result; ...
We've decided to move one of our websites from one web hosting service to another. So, I backed up all the files and transfered them to the new host. Here's the problem I can't import the sql file into new database on the new host, I get "Access denied" error. weird. I'm using CPanel version 11. Any idea? ...
Please I don't have any idea. Although I've made some readings on the topic. All I know is it is used to make the data in the database more efficient and easy to handle. And It can also be used to save disk space. And lastly, if you used normalization. You will have to generate more tables. Now I have a lot of questions to ask. First,...
How to encrypt user password in php. please explain in a way a beginner can understand. I already have this sample code: $password="john856"; $encrypt_password=md5($password); echo $encrypt_password; Can you help me incorporate it in my current code, which does not do any encryption. <?php $con = mysql_connect("localhost","root...
I generally use phpMyAdmin on a server where it is already installed. However, I now have the task of providing a config file for an installation of phpMyAdmin. I have the server name, username and password. I also have created the config directory inside of the phpMyAdmin directory. I could use some help with the basic file content. A...
please, I suddenly forgot how to do it. and its consuming much time. ...
What should be the data type that will be entered in phpmyadmin if I plan to use a checkbox as an input? ...
is out there any Open Source phpmyadmin flash user intrface? ...
I got this tutorial from the Internet. But I don't even have a basic understanding on how backup of a MySQL database through PHP would work. http://goo.gl/YK5P Can you recommend some sites that I can use as a reference so that I can study it? ...
SQL Server to MySql conversion, i want convert the SQL Server query dump to mysql database. I have SQL Server query dump. Please give me a good conversion tool free of cost. I tried with phpmyadmin import feature, its not working. ...
Hi, I have a database that I use for a foreign language / vocabulary web application and was interfacing with it through phpMyAdmin (and of course php). I had about a thousand rows for Arabic text, which had been put into a char field. I wanted to expand the size of my entries, so I read that a text field could get me past the 255 cha...