MySQL is an open-source, relational database management system.
0
votes
0answers
5 views
Ubuntu EC2 instance Mysql Database Issue [migrated]
I have a ubuntu ec2 micro instance where I have setted up LAMP environment with mysql/phpmyadmin as well. However, my application in every few days getting 'database connectivity issue' and when I ...
1
vote
4answers
56 views
Setting up a LAMP VM server for Development and Testing?
Info: I would like to set up a VM server on my local computer which will serve pages in the exact same way as my current hosting (but only to me on my local computer). I currently pay a big web ...
2
votes
0answers
31 views
Managing Xampp on USB for Mac and Windows machines
I am working on some PHP projects (Wordpress mostly) with MySQL databases and primarily use my Windows Desktop to do the work on whilst running Xampp.
This all works great until I need to take my ...
0
votes
0answers
12 views
Good one-to-many relation practice in MySQL [migrated]
I am developing the structure of the MySQL database and I've faced a small decisional problem about its structure.
I have 2 tables:
All messages published on the site.
All comments published on ...
-1
votes
1answer
30 views
One CSV file is there split and upload the data into two tables using PHP [closed]
I have one CSV file I want to upload that file in MySQL table the CSV file contains 10 columns the first five columns stored in one table another five columns stored in another table in PHP.
-1
votes
0answers
32 views
Install PHP with MYSQLi extension [closed]
I am setting up a server with the php and mysql. I installed php version 5.3.25 and the latest version of mysql. All setups went fine. so i downloaded phpmyadmin and placed it in the webserver's ...
2
votes
0answers
39 views
Good security practice for writing a php/mysql web app [closed]
I'm about to create a web app that is php/mysql based. It should contain multiple users and two levels of admin accounts.
It will most likely not be very likely to be attacked in any way. Still I am ...
2
votes
3answers
97 views
Accessing PHPMyAdmin via URL (without cPanel)
I am having issues accessing PHPMyAdmin from cPanel. It will not allow me to as I am logged in a root.
I cannot seem to be able to make another account for cPanel either, and research indicates this ...
3
votes
2answers
54 views
Turning off Webalizer and/or AW Stats
On our dedicated server, we have AW Stats and Webalizer both running.
I see I can turn them off in WHM.
We use Google Analytics, but also AW Stats sometimes. We never use Webzlier. My question is: ...
2
votes
1answer
85 views
Unified data source for k2 installed Joomla websites
I am responsible for a few web sites of my organization.
I use Joomla! 2.5.9 for those web sites. They all are running at the same server.
I use K2 component for content managing.
I have a general ...
1
vote
2answers
75 views
Setting up a VM testing server [MySQL, HTML, & PHP webstore] Testing for SQL correctness?
Question: Is there a way to test for correctness once the SQL DB copy has been installed on the local machine so I can confidently move to step number 3? Is there any information on the web that would ...
4
votes
3answers
146 views
Do i need to have a separate page for each article on my website?
I am using a database to store data such as articles, titles, meta and so on. Do I need to Have a separate page for each article so that my articles show up in the list when searched on Google?
Is is ...
6
votes
1answer
161 views
Security: Hide mysql connection details file
Ok, so I know this must be a very basic question, but my problem is the following: I have developed my first PHP mini-app (so I'm fairly new to this) and I am pretty sure that there are two files of ...
2
votes
0answers
49 views
How many connection can my website have? [closed]
As the traffic increased my website hangs quite regularly. The page visit is now averaging 50k per day.
The static page loads fine, but when the page has mysql request it takes too much time to ...
0
votes
0answers
17 views
Scalable cloud based PHP-supported equivalent to Azure? [duplicate]
I am looking for a company that can sell me infinite scalable cloud based hosting for PHP projects like WordPress and other PHP/MySQL-based sites.
I just tried Azure, only to realize that they have ...
1
vote
1answer
92 views
How many pageviews can my server handle per day?
I'm sharing some space on a dedicated server, but I'm not sure of the exact specifications. It is very fast though, and the person who I'm sharing the server with say they spend about 1400 a month on ...
2
votes
1answer
96 views
Trouble creating new MySQL user/database with PHPMyAdmin
I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database.
I now want to add a new user and new database. So, I went to the ...
1
vote
1answer
49 views
Changing MySQL password in WHM
When resetting an account password in WHM, I get a checkbox with this option: "Sync MySQL password with account password."
If an account has multiple MySQL databases, what password is it going to ...
0
votes
2answers
46 views
mod_rewrite issue, won't work when links contain “-”
I've been looking into mod_rewrite for my simple PHP CMS for a couple of days now and I found a rule that was supposed to work for me:
RewriteRule ^(\w+)/?$ view_post.php?url=$1
This is supposed to ...
0
votes
0answers
55 views
How to improve overall site performance/security? [closed]
I use PHP and am avid in my development using that language. What means can I use that will improve the performance of my PHP site, and bolster its security?
-1
votes
1answer
608 views
How to retrieve an image from MySQL database and display the image as background on body? [closed]
How do I retrieve an image from MySQL database (I know how to display image by retrieving from database but here i want to display differently) i.e. display the image as background on body and image ...
0
votes
0answers
79 views
Joomla 3.02 : how to query MySQL and use the data [closed]
I have been googling for last few hours but no luck.
I am looking for a simple example on how I can query MySQL using PHP and then use the output in an input box.
My confusion is where do I put the ...
4
votes
1answer
87 views
MySQL can only log in as root, even after creating new users with their own database
Problem:
I just set up a Debian Wheezy installation for testing, and installed the LAMP packages and PMA.
I can log in as root with my pre-defined password, create/edit/delete both databases and ...
2
votes
0answers
15 views
Hosting advice for a write-heavy dynamic website [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I have built a website using PHP and MySQL and now I am looking for a hosting service. I am expecting about a 1000 ...
2
votes
1answer
61 views
i got mysql error on this statement i don't know why [closed]
i got mysql error on this statement i don't know why error 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 ...
3
votes
2answers
334 views
Looking for full web based booking system
I've searched around here but could not find any booking system that would suit my need. I hope maybe you can help me out.
I've already seen question #11379. Solutions provided there are not helping ...
0
votes
0answers
63 views
How can I make this script output each categories item per category [closed]
Ok so here is the deal currently this script outputs all the products in a parent category as well as the products in the child categories. What i would like to do is seperate the output based on ...
1
vote
1answer
88 views
get mysql_real_escape is giving me errors when I try and add security to my website [closed]
I tried doing this:
@ $db = new myConnectDB();
$beerName = mysql_real_escape_string($beerName);
$beerID = mysql_real_escape_string($beerID);
$brewery = mysql_real_escape_string($brewery);
$style = ...
8
votes
3answers
164 views
Is it worth it to change my entire user images file structure to take advantage of simple browser caching?
On one of my mobile sites, I simply store my user's profile images as '1.jpg' in their user folder, and incrementally go from there for any extra pics they upload. This means that whenever they change ...
-1
votes
1answer
71 views
displaying a list of files [closed]
In my web application I have the user sign up for an account, then the account data is saved in a mysql database. The user can then go to "index.php" and log in with their credentials. My application ...
1
vote
2answers
491 views
php+mysql account management software?
I need an account system added to my website as a plugin to all of my HTML pages. The account system plugin needs to,register new users, log in current users, remove users who want to disconnect ...
2
votes
2answers
183 views
2 Websites, 1 Database
I have 2 websites and would like to use the same database for both sites.
The MySQL database contains just a simple guestbook.
The websites are one seperate hosting accounts, but with the same host.
...
0
votes
1answer
967 views
Warning: mysql_fetch_array() expects parameter 1 to be resource [closed]
I was trying to connect to my database through PHP but I keep getting the error:
Warning: mysql_fetch_array() expects parameter 1 to be resource
I do not know what the problem is?
This is the ...
0
votes
1answer
197 views
mysql code need help asap [closed]
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 'order ( orderID VARCHAR(6) NOT NULL DEFAULT 0, ...
0
votes
1answer
728 views
Auto-Complete Search + SQL [closed]
I'm trying to build a auto-complete search for an internal Workflow-system builded in php and SQL. Do you know were can I find any pre-builded code or any help-material?
Many thanks in advance!
1
vote
2answers
2k views
Add more than one host to user login privileges in phpMyAdmin
As the title reads, I want to add more than one host into the Host field in phpMyAdmin's user privileges, to allow a user to login from a number of different hostnames.
How can I accomplish this?
3
votes
2answers
391 views
How do I disable username prefixes on mySQL databases?
I know of the potential risks.
The only "useful" thing I've been able to find after Google-ing is this, on the cPanel website, which has no context whatsoever.
Does anyone know how to do this?
My ...
1
vote
2answers
164 views
Connecting to my new server
I have bought the hosting and now I have successfully created a database and new user and I have enter phpmyadmin from cPanel to create database.
Now everything is done. But where can I find ...
1
vote
3answers
94 views
How do I make sure my website is live all the time? [duplicate]
Possible Duplicate:
Services to monitor and report if a web site goes down?
I've had an interesting day. I've been with a hosting company for 8+ years without a hitch. Today the MySQL on my ...
1
vote
0answers
262 views
Interspire Email Marketer Configuration [closed]
Im trying to setup Interspire email marketer for a client. I have a working configuration of it on the VPS but this one is having issues! I have transferred it from their old server and setup the new ...
5
votes
3answers
246 views
Printing Single Quotes from Database to Screen
I have the following string as a varchar field in a MySQL Database:
I'm
When I perform a query to extract the string and then print it to the screen using the PHP print command, I get:
I�m
...
0
votes
1answer
292 views
What database engine should I use? [closed]
I don't know if this is the right place to ask this question but I want to become a web programmer for my occupation very soon. I actually went to a store known a PC WORLD in the UK where my laptop ...
2
votes
2answers
719 views
Login script with member area/user
Is there a free script which I can use to:
Share some PDF with my partners. But i need the user to reach only those PDFs which they have privileges for. So I need:
login script with registration (i ...
1
vote
2answers
2k views
Could Jekyll/Octopress and other static blogging engines be a good option for a heavy online magazine? [closed]
(Disclaimer: I thought this question should be asked on SuperUser, but it seems that was not the right place. Hope this one is more appropiate.)
I'm exploring several options for setting up a static ...
0
votes
0answers
100 views
Recommended blogware for creating a dynamic programmable php-mysql blog? [closed]
I want to create a blog-like website. At the begining I'll need a simple one person blog software, but in the future I'd like to have full access to the code and database (control the way posts are ...
1
vote
1answer
97 views
How to confirm the Mobile Numbers of my users?
How can I confirm the Mobile Numbers of my users in order to reduce the number of scammers claiming to be in the US but who are actually in another country?
A free solution would be preferred. I use ...
2
votes
1answer
722 views
Can't log in to phpMyAdmin after removing MySQL root password
I get this messege:
#1045 - Access denied for user 'root'@'localhost' (using password: YES)
I tried changing the password in phpMyAdmin config.inc.php
from root to '' but all I got was
Cannot ...
2
votes
2answers
457 views
Can you host Magento on Heroku?
I have Magento running on Heroku but the DB is on Dreamhost (because Heroku doesn't host mySQL). I get a Database connection error from Magento whenever I try to connect. Anyone ever done this?
5
votes
1answer
798 views
Is sqlite3 faster than MySQL on shared hosting?
Can sqlite3 be faster than MySQL on shared hosting and small to average websites (less than 500 visitors a day).
I have an account in a popular shared hosting provider and I've noticed that it has ...
0
votes
1answer
375 views
SocialEngine Installation Error 500 (Step 3)
I'm trying to install SocialEngine (clean install, empty database, legal license key) but I ran into this error message 500 at Step 3 of the installation:
Step 3: Setting up MySQL Database
MySQLi ...
