Tagged Questions
-1
votes
2answers
24 views
Pulling from mySQL database. Text, Enum or Set? [closed]
If I have a row that contains a list of instruments that a tutor can teach how should I store them? If they teach more than one then it's like 'guitar', 'drums', 'piano'. Then. I am creating the ...
0
votes
2answers
36 views
how to select more than one row with same value in one column in mysql?
I'm trying to make a comment system using PHP and MySQL. I have made a table named "comment" which stores the details--
id | date |product_id | user_name | email_id | comment
| ...
-2
votes
2answers
34 views
How to make a website for sending and receiving messages? [closed]
I am working on a project that is related to send requests from mobile through sms to our website and website replies to that person through sms itself. I don't know how to start with and what ...
0
votes
2answers
55 views
Storing website visitors without running out of MySQL connections
We have an analytics application which allows users to run a number of different reports. We have a single master - slave MySQL database setup.
One of the things which we track is visitors on our ...
0
votes
1answer
39 views
can't retrieve all rows from a table
I've tried the past hour to figure a way for the server to recognize if a user already owns a similar row in my MySQL DB
can any of your guys help me...
here is the code ive done by now
$nummer = ...
0
votes
0answers
219 views
MySQL Host 'hostname' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
My website is working perfectly on a localhost 'Wamp' server. However, as soon as I upload it to my web host for others to use, I get the following error:
Host 'stats.starfish.arvixe.com' is blocked ...
-6
votes
0answers
36 views
Connecting MySQL Server to URL [closed]
So I downloaded the latest MySQL community server to my PC. How can I actually connect my server to a website/url address, making it a part of the website?
0
votes
2answers
35 views
Best methods and ways of protecting website
I'm almost ready to transfer my website to my web host, but before that, I'd like to make it as well-protected as possible. I've heard about MySQL injection and other problems that you can face, how ...
0
votes
3answers
295 views
Good idea to migrate PHP/MySQL website with rich UI to Google websites or Google App Engine?
I have a full fledged PHP/MySQL dynamic website for a medium-large business with a rich jQuery and AJAX UI, and am considering migrating it to Google Websites or Google App Engine. (The website ...
google-app-engine
-1
votes
0answers
47 views
Trying to secure my website and securing the urls [closed]
Ive created a website that consists of many database queries, however a person can just jump to different pages through the url and access pages which should only be access with username and password. ...
0
votes
4answers
48 views
PHP code submitting to MySQL isn't working
I have been tying to figure out what is wrong for a long time, but I cannot figure it out. I have been trying to connect to a local MySQL database. When I run this, no error is thrown. Also, I know ...
0
votes
2answers
91 views
mysql_fetch_array issue
Here is the code:
<select name="op1" id="op1" class="op1">
<option value=""> -- please choose -- </option>
<?php
while($row = mysql_fetch_array($query)){
...
1
vote
1answer
52 views
How to set up MySQL database when upload site to host?
I'm trying to upload my web site to public host and make it live for the first time. My web site is placed on my home computer. I use XAMPP as working environment and Joomla 2.5.9.
I suppose I should ...
-3
votes
2answers
67 views
Making a searchable online database with data CSV file [closed]
I have a CSV file which contains four columns :
SEARCH QUERY | url1 |url2 |url3 |
foo | http://abc.com|http://xyz.com |http://lmno.com|
.
.
. and so on
I ...
0
votes
0answers
43 views
What is good free/open source php based website software? [closed]
I am currently learning/experiencing with Apache and MySQL using XAMPP. Is there any open source/free basic website software sort of like phpBB is for forums? I created my own phpBB forum and I am ...
0
votes
2answers
91 views
How to prevent users to open same page more than once at a time
On my website people earn points by seeing a page. They get 1 point for each second they keep the page open (the page keeps rotating Advertisements).
Some people have started exploiting this by ...
-5
votes
2answers
58 views
getting this error in wamp..Undefined index: User_id in C:\wamp\www\Testing1\index.php on line 3 [closed]
Undefined index: User_id in C:\wamp\www\Testing1\index.php on line 3
<?php
session_start();
echo "<br/>".$_COOKIE['User_id'];
include_once("scripts/connect.php");
$sql = ...
0
votes
1answer
56 views
need to upload a txt file to database, which method is doable godaddy or something else? [closed]
Hey guys so i'm have a text file on my desktop and I want to create a website with a database that will show that data online. I had found that godaddy lets you create a site and also lets you have a ...
-2
votes
1answer
45 views
How to insert data from html field into mysql [closed]
So I want to set up a simple page that allows the user to enter his/her name, address, birthday, etc. into fields, and then press enter. When they do, I want that data to be entered into a database. ...
0
votes
1answer
66 views
Which database users architecture should I use for serving a high frequented website?
I am creating a mysql databse in order to serve a high frequented website and I am struggling with the choice of how to rule the access to this DB.. Should every single user of the website have a ...
0
votes
0answers
72 views
INSERT command denied to user 'xxxx'@'sssss' for table 'jos_session'
I am using webmatrix and I uploaded a website on azurewebsites.net using joomla. this is the second time that I get the error and I don;t know hot to fix it. The first time I completly deleted the ...
azure
-1
votes
1answer
183 views
Creating a website builder with php [closed]
I have been given the task of creating a website builder that allows people to create websites about their buisness etc. clients are going to be non technical so It should be simple and easy to use, ...
-1
votes
2answers
50 views
Error #1064 in PhpMyAdmin 121223
DROP TABLE IF EXISTS PREFIXmovies;
DROP TABLE IF EXISTS PREFIXmovie_categories;
CREATE TABLE PREFIXmovies (
movID int(11) auto_increment PRIMARY KEY,
movheadline varchar(255),
...
1
vote
1answer
72 views
Tracking visits to specific products on a website
I am building a website for a clothing firm. They will be displaying around 20 items in the site and need to track the visits to each of the items, so they know which items are getting more interest ...
0
votes
5answers
55 views
MySQL: Getting all data once for future use
Well this is kind of a question of how to design a website which uses less resources than normal websites. Mobile optimized as well.
Here it goes: I was about to display a specific overview of e.g. 5 ...
1
vote
6answers
208 views
Fetch data in mysql Databse automatically to a website
I have configured a table which insert temperature values to a database. Now I need to retrieve database value to a website. I am new to web developing. Are there any templates that I can use for ...
-1
votes
1answer
67 views
How to Optimize my mysql database (Really confused) [closed]
I use alot of select statements all over my website, and also I have my website connected to my forums, so every time a user refreshes a page it's connected to the forums, which is connected to my ...
0
votes
1answer
68 views
MySQL Error Code 1054…Newbie in need of assistance
I am a new website developer and I have recently picked up a "PHP and MySQL In Easy Steps" book to assist me in learning the languages.
Everything worked fine and seemed pretty straight forward, but ...
0
votes
3answers
110 views
What do I need to successfully run a website in my browser that executes Python scripts?
I currently simply have a local website on my Mac. I can view the webpage's HTMl and CSS and run the javascript functions in browser on my computer, but the next step I want to take is incorporating ...
0
votes
3answers
306 views
How to return multiple rows from a table in in php using mysql
I've decided to build a website for fantasy football for my family but am getting stuck with returning multiple rows from the database.
What I want: to make a single sql call and get the entire list ...
