• Register

Recent questions tagged mysql

0 votes
1 answer 7 views
Problem: What is mysql_fetch_object in php? How can we use this function?
asked 6 days ago prog_learner 1.5k points
0 votes
1 answer 10 views
Problem: Hi, I am new to php database operations. i have written the query and it shows the error column count doesn't match value count at row 1 mysql. INSERT INTO Student VALUES ('Name', 'last name''class');
asked Nov 16 prog_learner 1.5k points
0 votes
1 answer 5 views
Problem: I have a project and i need to create a login page that checks for the user role and redirects depending on the role.
asked Nov 14 prog_learner 1.5k points
0 votes
1 answer 16 views
Problem: When i try to setup my databse using xampp phpmyadmin i am getting an 1932 error table 'phpmyadmin.pma__tracking' doesn't exist in engine. I need assistance how can we overcome this error.
asked Nov 13 prog_learner 1.5k points
0 votes
1 answer 14 views
Query: My small project requires me to monitor my sales database using php. The page must monitor any new entries of the database so that I will be able to respond to the sales request. If it is possible, it is a minute per minute update. My code is working fine except that I need to ... ="main"> <div id="activity"></div> <div id="notification"><?php echo $sales; ?></div> </div> </body> </html>
asked Nov 12 Grace Butan 340 points
0 votes
1 answer 10 views
Question: I need to display list of recipe titles based on the selected category. So what I need is to fill up the category dropdown list and then when I select any of the list, the table will show the recipes that is in that category. So I have two tables, one is the category table and ... /td> <td>Description xxx</td> </tr> <tr> <td>Dish 2</td> <td>Description xxx</td> </tr> </tbody> </table>
asked Nov 12 Grace Butan 340 points
0 votes
1 answer 14 views
Question: Hello, I am new to PHP and mysql, can someone show me how to upload images to the server and then save the link to the database?
asked Nov 12 Grace Butan 340 points
0 votes
1 answer 12 views
Problem: I need to filter my list of cities based on the country that I selected from the dropdown list. I'm new to PHP so I do not know much about how to do it. I already have a table of cities. Also, I need to know how to connect to the database. Here is the display that I want to show ... > </thead> <tbody> <tr> <td>City 1</td> <td>123891 SQ KM</td> <td>1.5 Million</td> </tr> </tbody> </table>
asked Nov 12 Grace Butan 340 points
0 votes
2 answers 11 views
Problem: I need to display certain set of values based on the selected item listed in the dropdown list without submitting the form. So my project is about the schedules of the sports. There are two main sections. 1) the Venue information and 2) the Promotion or any other instructions. Here ... > </div> <div class="col"> <div id="promotion"><img src="source.img">Promotion text</div> </div> </div>
asked Nov 12 Reina Joy 360 points
0 votes
1 answer 8 views
Question: I'm required to create a page that will monitor the chat message using php. So I have two fields, the "name" and the "message" fields. I am not allowed to use the form. But I am allowed to use javascript as well as button to save the message and the name and then list all the messages ... User 2</td> <td>message 2</td> </tr> <tr> <td>User 1</td> <td>message 1</td> </tr> </table> </div>
asked Nov 11 Reina Joy 360 points
0 votes
1 answer 8 views
Problem: My small project is working fine. But I need an interface that will allow me to submit the form through ajax. And then, after I submitted the form, it will display a table of the last 10 entries on the right side. What I mean is that on the left side is the entry and the right side will be the ... "] ?></td> </tr>'; <?php } ?> </tbody> </table> </div> </div> </div> </div> </body> </html>
asked Nov 11 Reina Joy 360 points
0 votes
1 answer 11 views
Problem: My project allows my user to upload multiple images to a specified folder. And when they click the upload, the images should be uploaded into the server and at the same time save the link to the table in mysql. I have no idea on how to do this. So could someone paste a code here so that I can copy them and incorporate it into my project?
asked Nov 10 Reina Joy 360 points
0 votes
1 answer 6 views
Problem: I have a form table for my small project. I have few issues in this because first, I need to enter the list of names that I wanted to save to the database. But my problem is that when I want to add more, then I have to run this page several times. ... echo "An error was encountered!<br>".$conn->error; } } } ?> Is there any way for me to add or delete dynamically multiple textboxes?
asked Nov 10 Reina Joy 360 points
0 votes
1 answer 13 views
Problem: I need to insert the json file to mysql table. I pasted my json file here for you to review so that someone can help me how to do this. { "Employees" : [ { "userId":"jmitchel", "jobTitle":"Developer", "firstName":"James", "lastName":"Mitchel", " ... ":"JosephSon", "jobTitle":"Program Directory", "firstName":"Joseph", "lastName":"Son", "emailAddress":"*Emails are not allowed*" } ] }
asked Nov 9 Reina Joy 360 points
0 votes
1 answer 7 views
Question: Is there any example of a dynamic php pagination based on the data from mysql?
asked Nov 9 Reina Joy 360 points
0 votes
1 answer 5 views
Problem: I have two tables, one master and the other the details. What I need to retrieve the data from the master and then, in every master the details also. So I don't know how to put them into a variable for me to process later. Here is my diagram: Items: 1 - Boxes - ... - Blue 2 - Crayons - 8 Colors - 16 Colors - 24 Colors Anyone who can show me with an example or demo on how to do it? Thanks
asked Nov 9 Reina Joy 360 points
0 votes
2 answers 17 views
Need Help: How to make an ajax call to populate my dropdown list when the page is loading in Php? And, how to make the ajax call to refresh my table when I make a selection on my dropdown list?
asked Nov 9 Reina Joy 360 points
0 votes
1 answer 9 views
Problem: I need to filter mysql records via search text input. I need to search either partly or full city or country of my transactions table. What do I do? Do I need to have two text input? Here is my code: <?php $conn = new mysqli($servername, $username, $password, ... tr> <?php } ?> </tbody> </table> Is there any possiblity also that my page will not refresh when I submit the search form?
asked Nov 9 Reina Joy 360 points
0 votes
2 answers 22 views
Problem: How to delete the row in a table taken from the database using a button? For example, there are three records in the table and I wanted to delete the second one. So how should I do it? I pasted my table here for better understanding: <table> <thead> ... should I do it with a button? And another thing, is it possible that after I press the button that the display will be updated instantly?
asked Nov 8 dorothy 300 points
0 votes
2 answers 17 views
Problem: I managed to create a table on phpmyadmin. I also keyed in some values into that table. But I want them to be displayed in a table of a page. I am new to PHP and Mysql so anyone can help me is greatly appreciated. Here's my format: <table> <thead> <tr> <th>ID #</th> < ... <tbody> <tr> <td>1</td> <td>Field_1 Value</td> <td>Field_2 Value</td> <td>Field_3 Value</td> </tr> </tbody> </table>
asked Nov 4 azriel 590 points