Tagged Questions

0
votes
0answers
3 views

Make same column in two tables always have same data?

I have two tables in my PHP/MySQL database. On table which stores users details usernames etc and one that stores images that users have uploaded along with the username of who has uploaded that ...
0
votes
0answers
24 views

What is the best way to keep a MySQL table replicated across multiple web sites?

I have multiple sites running the same custom CMS software. While the content needs to be different, it would be nice to have a shared member database (just for the convenience of a single sign on). ...
0
votes
1answer
25 views

Advanced Organization of my database, need tips

I hope it's easy for you guys to understand what i'm trying to do. I'm working on a project with cakePHP where it will allow users to log there drug use. Be it alcohol, caffeine, or whatever else. ...
1
vote
2answers
26 views

MySQL/PHP Search Engine - Without Refresh? Examples and documents provided

My question is rather lengthy, so I'll get right to it. I have a search engine set up that sends data (GET method) to a php script which queries a MySQL database and then displays the results. You can ...
0
votes
2answers
43 views

MySQL and PHP databases?

I am doing an exercise with PHP and MySQL database management, and I'm trying to return an amount from a field in a table with PHP. I am trying to get the value from the CalsPerServ in the foods table ...
0
votes
2answers
14 views

Why is my drop down list not populating with the table data?

WHy is my drop down list not populating with the table data? (dropdown box is empty) And what is used to display data upon selection of an item in that drop down - is it a "VIEW" (please do provide a ...
-2
votes
2answers
46 views

How would the database look like?

<?php $view=mysql_query("select* from tbl_jadwal jadwal, setup_kelas kelas, setup_pelajaran pelajaran, data_guru guru where jadwal.id_kelas=kelas.id_kelas and ...
-3
votes
1answer
31 views

Can you use PHP to gather columns from a database to include as choices in an HTML drop down box? [closed]

I am currently working on a school project. My goal is to develop a dynamic web page that allows people to retrieve data from a database. I want to create a few drop down boxes that allows users to ...
-2
votes
0answers
41 views

mysqli_query not working with crypted data

Im trying to use PHP crypt to hash passwords on my database. Before, I was able to use mysqli_query to insert the data on the table, but its not working anymore. Actually, the return value I want is ...
-2
votes
1answer
36 views

Codeigniter Upload CSV to Database

thank you in advance for the help you give me, I'll explain my situation. Based on tutorial File uploading Forum : Just a nice csv upload and populate the database function Form creating insert ...
-4
votes
0answers
49 views

Search for my site [closed]

enter code hereOk guys I have search box which only searches my website. Now I have it as full text indexed for the field in my database and also I am using the match syntax to pull data from the ...
0
votes
1answer
32 views

Where to save credit card detail? is it good to store in database [duplicate]

I have created the e-commerce site where user can buy product by credit card. I don't want to ask client credit card detail again, if once he purchased the product.Next time it should be ...
4
votes
2answers
50 views

How do you monitor a file on a web server and log every access, ideally by IP address, in a database (MySQL)?

For security reasons, there is a certain file on my web server I want to be able to monitor access to. Every time it is accessed, I want to have an entry added to a MySQL log table. This way, I can ...
0
votes
1answer
30 views

SQL append “-large” to every second row where column name is “clean_name”

Is this possible? I want to append the string "-large" to every second row within my products table, where the column is clean_name
0
votes
0answers
28 views

MySQL/PHP Search Script - Setting Search Parameters?

I have a MySQL table with contains a lot of trivia questions. Each entry (row) has a few columns (ID, Question #, Category, Difficulty, Question, Answer). I have a search engine set-up that queries ...
1
vote
2answers
25 views

Updating MySQL table with PHP and checkboxes

I have a table called products, with an: id: int, primary key, auto increment product_name: varchar highlighted: int (1 or 0) So, I want the highlighted field to be totally updateable via my admin ...
1
vote
2answers
90 views

is it safe to have a big table in database?

My client's site has a 'online evaluation' section, which consists of a 40 field form. Each field requires user input which I have program to allow from 50 to 200 characters depending on the question. ...
-4
votes
1answer
43 views

My php login system logs users in without a password [closed]

The page will login with any password when should be checking... The code should only let you login with a username and password, but it lets you in with just a username. Please help me fix this as I ...
0
votes
1answer
23 views

need to target 'delete' button to elements pouring out of a while loop in PHP

I have the following loop, which creates a list from a database: for ($i=0;$i<count($tutor_subj);$i++){ $query_tutors = "SELECT level, subject FROM level, subject WHERE level.id = '$tutor_lvl[$i]' ...
1
vote
3answers
22 views

PHP MYSQL Join and output unmatched results

I've two tables : One called "Collected_items" and the Other "Wrong_Collected"..As shown below : **collected_items** item_no qty x1 10 x2 20 BB 5 Z1 20 x13 13 ...
0
votes
4answers
37 views

Delete button not returning correct values to delete query

I have a table which displays data drawn from 2 different tables in mysql.The table has a delete button on each row which, when pressed, would send run a delete query which would delete the row, and ...
3
votes
0answers
41 views

Fast way of delete MySQL record [migrated]

I have a 1.2 million record in a database table( it use index column also) I want to delete old 1 million record. I try to do it using PhpMyadmin but it take more time. DELETE FROM `table` WHERE ...
0
votes
1answer
35 views

Not Able to Insert uniqid() value into MySQL database

I've inserting rows into a database from a test form and when I bring in uniqid(), it doesn't work. The form works fine and inserts the data but when I bring in the unique row it doesn't. I ...
0
votes
1answer
19 views

import .sql file into database found on a server

i am using phpmyadmin and i exported the database which I had locally. The exported file has an extension of .sql. I want to import the exported database into a database found online on the server. ...
-5
votes
2answers
43 views

PHP Way to generate and send to database a random number [closed]

I want to have a PHP page with a Generate Key button, when the users click it, it generates a random and unique number and sends it to a database. Is it possible? Thanks!
0
votes
1answer
37 views

Registration Form - Checkbox Is Inserted on new rows in Database

I'm Practising PHP programming. I have made a Registration Form which has 2 Text Area (For First Name and Last) 2 Radio Buttons (For Gender Selection - Haven't started work on that yet) 8 Check boxes ...
0
votes
1answer
60 views

SQL Join doesn't show up correctly

i'm trying to find a solution, i'm trying to get a data from different tables using same id. Here is my code "SELECT * FROM menucat LEFT JOIN vmenutab ON menucat.cat_id = vmenutab.menu_id"; I need ...
0
votes
0answers
24 views

Where/when to implement some COUNT() statements in my MVC application

Ok so I have my CustomerMapper mapping my Customer domain object perfectly but today I was in the middle of some business logic in one of my domain objects which uses my Customer object and I realized ...
0
votes
0answers
26 views

MySQL auto adding multiple records

first of all I would like to mention, that I do not understand PHP + MySQL that much yet. Basically I know only what it is and what possibilities it probably has. (So please do not catch me on that ...
1
vote
1answer
19 views

Multiple Database Connections slow down my website PHP MySQL

I am new and I tried to find my answer in the questions but I did not find something even close. I have a website that is displaying data from 6 different databases. This is the code i use to connect ...
0
votes
2answers
44 views

Selecting from 2 tables using session variable

I have a website where users can create SubAccounts and assign them to different locations.I'm trying to create a page where users are able to see their SubAccounts and the locations they are tied ...
-1
votes
3answers
79 views

Insert data into table using php [closed]

My html form is like below: <html> <body> <form action="createconnection.php" method="post"> Firstname : <input type="text", name="fname"> </br> Lastname : <input ...
0
votes
2answers
20 views

How do you replace a comma in an input box with another character on post to the database?

I have an input box which will have data separated by commas. I want to post to the database these to be replaced with an alternate value. How could this be done? I am still new to PHP so I would ...
0
votes
3answers
41 views

PHP reading fields in database

I have a script that reads my database table fields. Its not reading the first column which is the id.It reads the other fields and adds them into the array. I have added in the for loop a -1 to get ...
0
votes
2answers
39 views

populate mysql table on the basis of another

I have 3 mysql tables containing a few fields. Please refer to the following -------- -------- -------- table 1 | table 2 | table 3 -------- -------- -------- a_id | b_id | email ...
-4
votes
1answer
38 views

Notice: Undefined index php [closed]

I'm getting error Notice: Undefined index: q_id in D:\pinnaclequizsoft\USBWebserver v8_en\root\test.php on line 21 Notice: Undefined index: option in D:\pinnaclequizsoft\USBWebserver ...
0
votes
2answers
31 views

php - MySql select from table with multiple conditions

I need to select all from database when "main=1" once, then select all from database when "main=0" and use them within the same request. Can I do this in one request? this is the request 1. $result ...
-2
votes
1answer
28 views

Create a link for a user as this http://mysite.com/profile.php?id=12 [closed]

Hello everybody I created a full Login and SignUp System, And I needed to create for each user ID a link that shows his Information as this Link http://mysite.com/profile.php?id=5.
0
votes
3answers
65 views

How to output mysql database text type in php? [closed]

I created a database table called animal_types, made my list and put them all as "text" type instead of the "varchar" type as I just want them as a list for when people select them in a drop down. I ...
-4
votes
2answers
43 views

If link = to mysite.com/profile.php?id=15 then [closed]

now I have created a full log in and sign up system in PHP, Now if user sign up his/her ID is added to mysql database, what I need is if the link = to http://mysite.com/profile.php?id=15 then echo ...
0
votes
2answers
15 views

Displaying specific data from mySQL using sessions IDs

I'm trying to display the users first name after they login. They login using their email and password. Though, I would like to collect their first name and display it. Their name is in the same table ...
0
votes
2answers
30 views

Storing data in multiple rows vs serialized data in MySQL

I have a question related to saving large amounts of data in a serialized form as opposed to multiple rows in a table. In my table, I store certain profile related info about my App user's Facebook ...
0
votes
0answers
57 views

Can I query 2 columns to return 1 row in Mysql?

The company database has duplicate entries for ID due to different locations so I'm trying to return the database queries on the website by ID # AND zip matches. I can get the the code to query the ...
0
votes
1answer
42 views

PHP: Image not uploading to folder

Hey guys I think i need a fresh set of eyes on this. I have an insert script that inserts data to the database along with the URL of an image that gets uploaded to a folder called uploads. The problem ...
-4
votes
1answer
40 views

Relationship with multiple tables [closed]

I have Tables; Category, Subject, and Grade. Category -> id, name, desc; Subject -> id, name, desc, category_id; Grade -> id, name, desc, subject_id. And I have another table, Price. It ...
0
votes
4answers
31 views

Adding a required column to a database table

If I were to add a column (i.e. EIN Tax ID) to an already existing database for my customers,would there be any effect on the already existing customers who may not have anything in that field when I ...
0
votes
0answers
13 views

php kohana functional testing database environment

I've got an application developed in kohana 3.2. I want to write some functional tests that will affect database content. I would like to load the database from a dump file each time I run all ...
-8
votes
0answers
40 views

Creating a website multiple times however with unique content based on url [closed]

I am trying to find the best way of creating 100 websites, all with the same design however different text and different URL's. I previously created 100 separate websites and uploaded them separately ...
0
votes
0answers
14 views

how to implement complex analytics and tracking for existing system in php

We are in development of a system using Symfony2 with Mysql database and now we have a new requirement for the project: we need complex tracking and analytics for the data that will be stored in the ...
-1
votes
1answer
43 views

MySQL Database ignoring solid code? [closed]

The following code executes but apparently does nothing. It does display "Table has been created." and does not show any errors. However, when I look at my Database in MyPHPAdmin, no table has been ...

1 2 3 4 5 … 155
15 30 50 per page