Hello! I have a problem with a MySQL database that I haven’t been able to solve no matter how much I tried, either with internet guides or with free tools. I really don’t want to pay hundreds of dollars to a company so please, if anyone knows of a solution, help me because I’m desperate. I was running XAMPP 7.1.22 where I had said database and I decided to install XAMPP 7.2.10 without backing up the database. After that, the site wasn’t working so I figured the problem was the database. And indeed PHPMyAdmin wouldn’t recognize it. I reinstalled the …

Member Avatar
+0 forum 0

Greetings! I got a mysql database "backup" that someone made and I have to use it, trying to get a website back online. Its a Joomla web database. The person gave me a file "database.txt" (not database.sql) which opens with Notepad. Trying to "import" in phpmyadmin does not work and just gives out errors like " * Ending quote ' was expected. (near "" at position 4438), and " 42 values were expected, but found 21. (near "(" at position 3967)* I'm attaching 2 screeshots here so that you guys can see the contents of this file,somewhere it says mysql …

Member Avatar
Member Avatar
+0 forum 2

Hello, I have a products page which lists the pics of the products. I added pagination with bootstrap classes. I have 10 products in my database. I want to limit per page to display only 6 so then the second page should display 4. The issue im facing now is that the second page button doesn't "change" to the second page. but if i click >> button it does change. pic for visualization: ![1.JPG](/attachments/large/4/f576dd88594468eb6302102f5b57891b.JPG "align-center") code: $per_pageAll = 6; if (isset($_GET["page"])) $pageAll = $_GET["page"]; else $pageAll = 1; $start_fromAll = ($pageAll-1) * $per_pageAll; $stmtAll = $conn->prepare("SELECT id, name, price, type, …

Member Avatar
Member Avatar
+0 forum 1

Hi, I would like to ask for help with regards on my problem on my phpmyadmin - mysql database. I am using wamp server 2.5. So here's the scenario, I try to insert data on two tables (accounts, user_info) on mysql @ phpmyadmin using php ajax. Now the problem is that, the data pass from ajax to php file was successful and the data only inserts on user_info table but failed to insert on accounts table. Then for the second time, I try to insert another data but it failed to insert on both table. Please help. Thanks, Jeff

Member Avatar
Member Avatar
+0 forum 1

Hi, Not done any programming for a few years so am somewhat rusty again. I have two tables **users** table and **users_profiles** table. I want to update **users_profiles** table on the condition that **user_uid** matches on both tables (**users.user_uid** and **users_profiles.user_uid**) and where **users.user_login ** = 'johndoe' and **users.user_uid** = '11'. It wil be executed in a php script, so johndoe would actually be users username (whatever is stored in session and same for users_uid. For simplicitity i added dummy data. I run the query in phpmyadmin and get syntax error near INNER JOIN. I just cannot figure out what …

Member Avatar
Member Avatar
+0 forum 6

Hello, I am trying to reset mysql myphpmyadmin password: Cannot log in to the MySQL server Username: root Password: 12345 And have not been successful yet reseting it. This is my config.inc.php <?php /* * This is needed for cookie based authentication to encrypt password in * cookie */ $cfg['blowfish_secret'] = 'xampp'; /* YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH! */ /* * Servers configuration */ $i = 0; /* * First server */ $i++; /* Authentication type and info */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = '12345'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['AllowNoPassword'] = true; $cfg['Lang'] …

Member Avatar
Member Avatar
+0 forum 2

when ever i am inserting any of the symbols like cosec^2Ɵ (cosec power 2) it will display inline. i won't that to be displayed with raise to 2 or subscript or superscript of it. How to get Displayed that using utf-8 unicode characset ?

Member Avatar
Member Avatar
+0 forum 1

Linux Mint I logged into phpmyadmin and set the password option to 'no password' and now I can't log in. If I enter the password I was using I get this error -> `#1045 Cannot log in to the MySQL server` and if I don't user a password at all I get this error. -> `Login without a password is forbidden by configuration (see AllowNoPassword)` Any ideas on how I get this working again so I can log back in? One more question about phpmyadmin. If the computer I do my development from is a different computer than the one …

Member Avatar
Member Avatar
+0 forum 8

hello, I am having a problem opening my database. Before this I could directly go to phpmyadmin after logging in to cpanel without entering username/password. Today, I was directed to a page to enter username/password before going to the database so I did but I got this warning: Warning in ./libraries/plugins/auth/AuthenticationCpanel.class.php#636 mysql_connect(): Access denied for user 'dhsbnet'@'localhost' (using password: YES) Backtrace ./libraries/plugins/auth/AuthenticationCpanel.class.php#636: mysql_connect( string ********, string ********, string ********, ) ./libraries/plugins/auth/AuthenticationCpanel.class.php#377: AuthenticationCpanel::cp_mysql_auth_check( string 'dhsbnet', string '*)9$I8uDnQE}', ) ./libraries/common.inc.php#871: AuthenticationCpanel->authCheck() ./index.php#12: require_once(./libraries/common.inc.php) Notice in ./libraries/plugins/auth/AuthenticationCpanel.class.php#500 Undefined index: auth_type Backtrace ./libraries/common.inc.php#876: AuthenticationCpanel->authSetUser() ./index.php#12: require_once(./libraries/common.inc.php) so I can't open the database to see …

Member Avatar
Member Avatar
+0 forum 1

i have continued my developing my code on e-commerce website to grant the discount to client on basis of coupon code entered <?php /** * Consider and apply voucher codes * Types of voucher code * - = FIXED AMOUNT OFF * % = PERCENTAGE OFF * s = SET NEW SHIPPING COST * @param voucherCode String * @return void */ if(isset($_POST["submit"])){ $code=$_POST["code"]; $coupon=new coupon(); $coupon->Vouchers($code); } class coupon { function Vouchers( Registry $registry, $voucherCode ) { //The voucher code value is checked to ensure it is not empty // (as per point 1) if( $voucherCode != '' ) { …

Member Avatar
Member Avatar
+0 forum 5

hello every one i have one small doubt i have the following code i want the user to enter the coupon code which has been randomly generated and saved in database now i want that when user enter the coupon code it is cross checked from database i.e entered coupon exist or not // html form <form method="post" action="ted.php"> Enter The Coupon Code:<br /> <input name="code" type="text" size="10" /> <br /> <input type="submit" name="submit" value="submit" onclick="coupval =this.form.coupcode.value; ChkCoup();" /> </form> //php script <?php $db=new mysqli('localhost','root','','shop'); if(mysqli_connect_errno()){ echo 'Could not connect to database:Plz try After Some time..'; exit; } //Function to …

Member Avatar
Member Avatar
+0 forum 6

hello every one i am creating form of 15 question length for 5 questions it worked but when i increase the length of question to 15 or 18 dont work plz help me it's urgent <?php //Start session session_start(); //Include database connection details require_once('connection/config.php'); //Array to store validation errors //$errmsg_arr = array(); //Validation error flag //$errflag = false; //Connect to mysql server $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if(!$link) { echo"Not Connected"; die('Failed to connect to server: ' . mysql_error()); } //Select database $db = mysql_select_db(DB_DATABASE); if(!$db) { echo "Not Selected"; die("Unable to select database"); } //Function to sanitize values received …

Member Avatar
Member Avatar
+0 forum 1

Hi All, Please let me know the steps to install PHP, MySQL and PHPMyAdmin on RHEL machines.

Member Avatar
Member Avatar
+0 forum 2

Hi All, I am developing a website in which i am selecting some values form database by a query When i am running query on PHPMyAdmin i am getting desired results but when i am using this query in actual PHP code, i am getting value of Last row. Can any one tell me , whats happening wrong?

Member Avatar
Member Avatar
+0 forum 6

Hi guys i'm creating a new table in sql to allow users to register with my website, this is the sql code that I'm suing does this seem ok to you? CREATE DATABASE `dyscaculia` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; USE `dyscaculia`; CREATE TABLE IF NOT EXISTS `users` ( `Firstname` varchar(1) DEFAULT NULL `Lastname` varchar(1) DEFAULT NULL `Username` varchar(1) DEFAULT NULl `Email` decimal(1) DEFAULT NULL, `ConfirmEmaill` varchar(1) DEFAULT NULL `Password` varchar(1) DEFAULT NULL `PasswordEmaill` varchar(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; I've only connected PHP via the ADODB connection and nnot mysql so this is new to be any …

Member Avatar
Member Avatar
+0 forum 14

Hi, I am using VB6 and phpMyAdmin connected by WAMPServer for my system. I am new in this language. Here's the code in my that seems to be wrong: Private Sub cmdsubmit_Click() Dim rs As ADODB.Recordset Dim strsql As String strsql = "insert into table1 ( surname, firstname, middlename, house, street, village, brgy, city, gender, kind, birthday) values (" _ & "'" & txtsurname.Text & "'," _ & "'" & txtfirstname.Text & "'," _ & "'" & txtmiddlename.Text & "'," _ & "'" & txthouse.Text & "'," _ & "'" & txtstreet.Text & "'," _ & "'" & txtvillage.Text & …

Member Avatar
Member Avatar
+0 forum 6

hello all I am a beginner... I want to move a wordpress site from a local computer to live server... live server: plesk parallels I followed some tutorials and it says: you must create a new mySql database on server... ok I went to parallels plesk panel and I created it... created some user ... and now I click on webadmin button (I guess that is how I go to phpmyadmin) and I get error message: > Welcome to phpMyAdmin > You probably did not create a configuration file. You might want to use the setup script to create one. …

Member Avatar
Member Avatar
+0 forum 7

Hey All, I think I messed up.. I went to PhpMyAdmin and clicked export and exported all my databases with the default options to a sql file. And I downloaded a bzip file with my sql file in it. If I open the sql file it looks like BZh41AY&SYò)É<91>^@B"_<80>P^Pz÷ÿúÿÿÿðÿÿßð`4^^òPÇ»w^Fç-îä»o11ãwÞ|ú^AÜ^Aëo¨ú½Ðî^Nï:.Ó§;Såñݱèó¦ô<9b>ÓÎÞe·<92>ó»7×Ú;<98>£§Nɤ)lÓFP<94>^Tå<8b>Û^T'<86>ǭܦî°:n±@÷Þ=öõôût[Àûî÷¼>D<94>}5D7¸ÏyÕ^]zâªR<90><<9c>$P@Ð^H^B50§<94>{Th&Ò<£F<9a>^L^SLF^F<99>^@¢<9a>(hh^Y^@^F<9a>^@^@Ð^@^@^BA$^R<9e><89>詵=ªm4<99>4^Y^@^OPô<9a>h^Z^@^@^Rz©(ÔÊz£ÔñA£&<8d>© ^M^@È^M^@^@^@^H<92>^P #!4ÒzL<9a><9b>Q<99>SÄ<8d>1<88><9b>@<9e><8d>C@ this makes me worried because then I deleted the database so I can't export it again and when I try to import this file into phpMyAdmin elsewhere it says there is a syntax error... Any ideas?

Member Avatar
Member Avatar
+0 forum 1

Hi, I have imported a csv file but for some reason in some values the data after . is missing for e.g. If my value in csv is 0.5 it displays 0. and 5 went missing but in my csv file i have value as 0.5 I don't what step i am missing on import.

Member Avatar
Member Avatar
+0 forum 9

Hi, I have imported .csv file and column is appearing as Col 1, Col 2... and the data I want as a column name is appearing as a first row. How do I convert my first row into column name in phpmyadmin. Thanks in advance

Member Avatar
Member Avatar
+0 forum 6

I am getting this error when inserting a query into the SQL tab of a database, it only adds 2 tables when it is supposed to add more, but the error is stopping it? Screenshot: http://gyazo.com/b62b31137708228beb791ed6c8ad01ea Query im inserting: http://pastebin.com/rMJeA0Xb Software: MySQL Software version: 5.1.68-cll - MySQL Community Server (GPL) If you can help me out, I'd really appreciate, thanks!

Member Avatar
Member Avatar
+0 forum 5

Hi guyz, When I click the tray icon of WAMPServer and select the phpMyAdmin option, it issues an error **Could not execute menu item (internal error)..... The system cannot find the specified path.** Previously, I could access it without any problem. Any ideas?

Member Avatar
Member Avatar
+0 forum 1

Hi I finally screwed up.In order to get rid of a minor problem I uninstalled Wamp Server and reinstalled it.Now when I try to start it it will not accept my old password.What can I do? Do I have to uninstall everything mySql, Workbench,Wamp server and maybe php? Another thing, I installed all these programs separately, is there a single package to get all these in one single install?And if I have to redo the whole thing in which order should I install these programs? Thank you

Member Avatar
Member Avatar
+0 forum 3

Hi all. I'm developing a quiz application consisting of multiple choice questions. Here are the tables that I've come up with. CREATE TABLE IF NOT EXISTS `student` ( `s_id` int(10) NOT NULL, `s_name` varchar(30) NOT NULL, `s_email` varchar(30) NOT NULL, PRIMARY KEY (`s_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `instructor` ( `i_id` int(6) NOT NULL, `i_name` varchar(30) NOT NULL, `i_email` varchar(30) NOT NULL, PRIMARY KEY (`i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF NOT EXISTS `result` ( `r_id` int(6) NOT NULL AUTO_INCREMENT, `s_id` int(10) NOT NULL, `i_id` int(6) NOT NULL, `r_status` text NOT NULL, `r_score` decimal(6,0) NOT …

Member Avatar
Member Avatar
+0 forum 4

I could not put Wamp on line because port 80 was used by IIS7, so I changed it to port 81 and the icon became green,is on line. If I click on phpmyAdmin though I get error 404 not found.I read that phpmyAdmin also uses port 80 so should I change it to 81 too?And how do I do that? Thank you for your help.

Member Avatar
Member Avatar
+0 forum 6

I have 2 tables: tblUser: +------+-----------+ | id | Name | +------+-----------+ tblItems(this table accepts multiple checkbox value depending on how many user selected): +------+-----------+---------------+ | id | items | name_id | +------+-----------+---------------+ `name_id` will get the value of `id` in `tblUser` I use this code to get the value of id of `tblUser` to `name_id`: for ($i=0; $i<sizeof($checkbox);$i++){ $sql2="INSERT INTO tblItems VALUES (NULL, '".$checkbox[$i]."', (SELECT id FROM tblUser))"; $result2=mysql_query($sql2); } It works fine on the first `INSERT` of data that will look like this in database: +------+-----------+---------------+ | id | items | name_id | +------+-----------+---------------+ | 1 | Bucket …

Member Avatar
Member Avatar
+1 forum 3

Hello Community, Is there a website that has a database like phpmyadmin that i can access from my website? Please help...

Member Avatar
Member Avatar
+0 forum 6

I have a similar mysql database both onine and in offline, with a few common tables in them. How can I synchronize both the databases to make sure the 'similar tables' in offline & online databases have the same data. How can I do this with phpmyadmin.

Member Avatar
Member Avatar
+0 forum 1

Hi, I've two tables, one called users and one called playerweapons. In `users` it carries information and is defined by a Username field. In `playerweapons` it has the same define with using Username. I want it so when I update the Username field in `users` it will then update the username in `playerweapons`. Here is the screenshot of the `Users` table and `playerweapons` table. `Users`: http://pokit.org/get/img/ce10f6ee0db75165ddf4ddd4dca2e979.png `playerweapons`: http://pokit.org/get/img/997ea313624ca26d57bb4dc4ffd4f346.png I try to set it up but I get this error in the screenshot: http://pokit.org/get/img/85c25f8aad2fe805fe0946e79395c53b.png I hope you can help. Thank you.

Member Avatar
Member Avatar
+0 forum 3

Hi Friends i like to know more about the difference between mysql, Phpmyadmin, sql and also which one is more safe and secure for webpage. Can any one help me to know about it.

Member Avatar
Member Avatar
+0 forum 4

The End.