I have a database 'test' with two tables. Here is phpmyadmin dump: CREATE TABLE IF NOT EXISTS `tags` ( `name` varchar(100) NOT NULL, `id` int(4) NOT NULL, KEY `id` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `tags` -- INSERT INTO `tags` (`name`, `id`) VALUES ('tag_one', 1), ('tag_two', 1), ('tag_th...
Hello all, I am using XAMPP to develop my prototype website locally and will transfer the whole prototype to a web hosting company after everything is ready. Here are the questions: By default the content of the Authentication type and info section is as follows: C:\xampp\phpMyAdmin\config.inc.php $cfg['Servers'][$i]['auth_type'] ...
Ok I creating an application that needs to query records from my remote database. I am logged into phpmyadmin and I need to connect to this from my new PHP application. I have the cpanel access and the phpmyadmin tab. Is there something i can do to get the info needed to do this $connection = mysql_connect(DB_HOST,DB_USER,DB_PASS,true);...
I have two tables: members and renewals The two tables have a field called memberid which links the two data tables together. I am trying to construct a query which will extract the firstname and surname from the members table for the data that is being held in the renewals table. I have tried using the query below which is based on s...
Just wondering if someone can assist me with the following issue. I have a database in MySQL and I'm using PHPMyAdmin to interact with the database. So within the table example_table_name I have two columns product_item_short and product_item_long which have URL's in them. Now there is 3000 rows of data and as an example the URL in eac...
Hello all, We have been working for a few hours on a serious problem. We have the following code: mysql_connect("localhost","xxx","xxx") or die(mysql_error()); mysql_select_db("xxxe"); $q = "SELECT m.id, m.expired_date, u.email FROM jos_osemsc_member m, jos_osemsc_orders o, jos_users u WHERE o.order_id = $orderID AND m.m...
firstly i just clearify the problem. i am testing the page of login of my website. so i have two login files for testing that both contain same code but both are save in different place named "signin.php" & "login.php" resp. the problem is when i try to login from "signin.php" which located in root folder(www) gives an error:Access deni...
Hi folks, In my application there are two PHP are available. 1) PHP 5.1.6 2) PHP 5.2.6 Currently I am using PHP 5.2.6 version in my application. Also I'm using PHP 5.2.6 database ( phpmyadmin ). Here my question is I want to use another PHP's database ( phpmyadmin ) i.e. PHP 5.1.6 's phpmyadmin. I dont know how to do this, Please g...
If I have one table: IMAGES with columns imageID, Image, and categoryID*(this being the foreign key) and 2nd table CATEGORIES with columns categoryID, Category and peform query for example: $sql = "SELECT categoryID FROM IMAGES WHERE image = 'exampleImage'"; I would get the result as an integer of the category ID i.e 1 My ques...
Hi. If I want each new entry into my db to be automatically timestamped, would I set the Field Type to "timestamp" and have the Default value set to "CURRENT_TIMESTAMP"? Is this the correct method? ...
Hello, Im using phpmyadmin for a website i'm creating and have a question about a inserting values into foreign key. Im able to select an image table id when event col in events table is value x i.e... $event = "Partay"; $sql = "SELECT i.ImageID FROM images i INNER JOIN events e ON i.eventID = e.eventID WHERE e.event ='".$event."'"...
I'm designing a database in MySQL and PHP for a basic CMS. The CMS will have a front end which will allow sorting and searching. The backend will allow authorized users to upload files. I'm using PHPMyAdmin and I'd like help setting up my database. I am open to answers explaining various MySQL datatypes and what they are good for as w...
I have created a MySQL function to determine if a set of latitude and longitude coordinates are within a certain range of another set of latitude and longitude coordinates. However, the function is giving me a syntax error so I cannot test to see if it is working properly. Any help figuring out what is causing the error would be greatly ...
Hi, I want to make sure something is write. My database tables are utf8_unicode_ci and my site encoding and header is utf-8 etc and so on. I done a test and in my guestbook i entered this: á ʵßăāÇϢϞﻨ☺ ▓ ▓ẻ ▓ẻṎ ۞ ݤ Now great it displays on the webpage like it should and i tested other languages to etc, but on checking this in p...
How do you rename a MySQL table in PHPMyAdmin? (SQL command?) Are MySQL table names case-sensitive when working with PHP? ...
Hi all, What i did is: http://localhost/phpmyadmin/ Select Privileges In the user overview selecting the "EDIT Privileges" In the Global Privileges selecting "UN CHECK ALL" and hitting the GO button. That's the end. Right now i don't have any privileges. Now my need is: How shall i revoke my permissions back. thanks in advance.....
Hi, I already have a table in phpmyadmin that contains users records. Each user has a unique admission number. I now want to add a new column to this table and was wondering how I can import data for this new column using just the admission number and new data. Is this possible? I have a CSV but can't work out the best way to import th...
The VPS I was using used to have PHPMyAdmin pre-installation option but removed it stating it poses security risk. Does it? If so do you recommend an alternative for browsing DB on production (other than running SQL commands in console) ...
Hi, I'm running XAMPP on my local host, and i want phpmyadmin to add another field of server on login page, so i can manage an external mysql server as well.. Is that possible? Thanks ...
Is it possible that we have one domain where database and site is hosted on the single dedicated IP. If we wish to host domains subdomain on another dedicated IP address and use the domains databse to display quotes. Will it be done or not. Or we have to host the subdomain also in same domain with same IP address? ...