11,093 Topics
![]() | |
<link rel="stylesheet" type="text/css" href="admin/css/style.css" /> <?php include('dbcon.php'); include('header.php'); ?> </head> <body> <div class="navbar navbar-fixed-top"> <div class="navbar-inner"> <div class="container"> <a class="brand"> <img src="admin/images/dee.png" width="150" height="50"> </a> <a class="brand"> <h2>UNITOUCH GLOBAL ONLINE E-VOTING</h2> <div class="chmsc_nav"><font size="4" color="white">Uniquely Touching The Universe</font></div> </a> <?php include('head.php'); ?> </div> </div> </div> <div class="wrapper_admin"> </br> </br> </br> … | |
im creating a voting system that add votes to the database but it seems that my update/submit button don't add numbers(INT) in my database. what could be the problem here?help my database schema: | cid | cpos | cfname | cmname | clname | cyr | cparty | votes | … | |
Good day What I would like to do is to alter a mysql table with data in it then add manipulated string data to that created column i.e I first add an extra column to my table then add a reverse string coded from data that had already been inserted. … | |
Hi all , plz , How to connect vb.net with mysql host (godaddy.com ) | |
I installed XAMPP for my PHP programming practice but when I run it then MySQL is not starting, while apache is running correctly. Can anyone please tell me the solution? | |
Hi The code below inserts data into a mysql db, for some weird reason IE inserts it 2 times and firefox just once. It should only insert it once. $KOSoep = $_POST['KOsoep']; $KOHoofdgerecht = $_POST['KOhoofdgerecht']; $KODessert = $_POST['KOdessert']; //insert query kinderopvang $insert_kinderopvang="INSERT INTO `menukinderopvang` ( `datum` , `soep` , `hoofdgerecht`,`dessert` … ![]() | |
Hello, I am a web developer who is having a hard time trying to get my scripts to connect to my new web host. The script works perfectly on my localhost (I'm using XAMPP) but once I try to use it on my web host, I get the following error: … | |
please guys i am making an app and i want to show the number of users online on the app i have this code function whoisonline() { //what are my variables values $email=$_SESSION['jwp_email']; $sqloo="SELECT `id` FROM users WHERE email='$email'"; #mysql_query($sqloo) if ($run=mysql_query($sqloo)) { $b=mysql_fetch_assoc($run); $b['id']; $c=$b['id']; } $ip=$_SERVER['REMOTE_ADDR']; $ip_ua=$_SERVER['HTTP_USER_AGENT']; $time=time(); … | |
Can never seem to get things to work! <?php if(isset($_POST['add'])) { $person_id = $_POST['person_id']; if (isset($_POST["cv"])) { $cv=1; } else { $cv=0; } if (isset($_POST["document_id"])) { $document_id=1; } else { $document_id=0; } if (isset($_POST["application_form"])) { $application_form=1; } else { $application_form=0; } if (isset($_POST["passport"])) { $passport=1; } else { $passport=0; } … | |
I have applied indexes and analyzed my table, but query on select is still very slow. Anything else can I do to speed it up? | |
**Hello Every body.** My toturial today how to make token input in the send data by form to the database by using php mysql it's so easily and useful . most people why use it or what's token take me to more secure. i answer : Did you ever think … | |
Hey guys, the code below is where I am having the problem. The error I am getting when trying to insert the record is *Could not enter data: Unknown column '3' in 'field list'* <?php session_start(); include("db_connect.php"); if(($_SESSION['user_id']) && ($_SESSION['access_level'] == 1 ) ) { ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD … | |
Hi team, Kindly, clarify the below query, i am confused the difference between in and like statements in the mysql. mysql> select count(id) as tablename from postings where is_active=1 and publish in (2) ; result -- 38 mysql> SELECT COUNT(*) FROM tablename WHERE is_active=1 and publish like '%2%'; result -- … ![]() | |
Hi, I just recently started a website with the hope of connecting a program I made with the licensing database that I've already created. I have all the usernames and passwords I need. on a side note, I'm using Visual FoxPro 9. But each time I try to connect I … | |
I am displaying the complete record of the user in the My profile section, I am fetching all the rows , but the problem is within the rows I've got two fields as arrays, which are 'secondarySubject' and 'secondaryGrade' now I want the display to be something like this 2002-2004 … ![]() | |
Hi, I need a master - master database configuration for a website wherein i need only a few tables to be in sync. All the links i tried on google give examples for full database replication. Does anyone know how to sync individual tables? | |
I want to develop a voip billing system in php and mysql. Do you gays able to help me by giving me some tutorial links.Or some technical suggestion as how to start and how can I do it final.Thanks all in advance for reading my query and trying to help … | |
hey guys. so first of im kinda confused as to which forum i should post to but i hope you guys arent mad if this isnt the appropriate forum. moving on, i have these bunch of images that i want to be able to be displayed after a button click … ![]() | |
I have some code that I edited for importing csv into mysql using PDO to bind parameters. I thought it was working before, but tested it again and the issue I have is that only one line (the fourth line) of the csv file is getting imported. The first line … | |
Hello everyone. I'm quiet new here and trying to get som helpå from you guys. My main problem is that I have made a form which I want to use to post data to my database. But it seem to never work. Firsta problem was; everytime the page loads the … | |
hey guys, so im not sure if this is the right forum, sorry if its not. anyway, i have to create a webpage that can do seating arrangements graphically. it would be like those seating plan softwares out there but this would be online. users can choose tables/chairs/etc which guests … | |
Hi I have dropdown list of domain names.Which is populated by mysql query(1st query). And when dropdown value is selected that value is used in another mysql query(2nd query). I've a submit button,when it is clicked.It is working perfectly. But i want to remove submit button and i need a … ![]() | |
Hi i am using array for uploading images but i am unable to insert it into database as well as in the folder. can anyone please help me to resolve it. $name = $_GET['name']; $gititle = $_POST['gititle']; $number_of_file_fields = 0; $number_of_uploaded_files = 0; $number_of_moved_files = 0; $uploaded_files = $_POST[$_FILES['images']['name'][$i]]; echo … | |
Hi Everyone, I'm building an app that inserts data into table A, then I want a trigger to kick off before new data is inserted into table B to confirm that the value exists in column string_Value and then take the data and add it into TABLE C. Is this … ![]() | |
How can I generate a weekly report given an end date and a start date? How should the query be? I try this one but it's returning an error. "SELECT * FROM table WHERE date >= startdate AN date<='enddate GROUP BY WEEK BETWEEN startdate AND enddate" | |
Hi, I am working on a script where I want to select parent id for a new user and save his parent id along with parents parent ids in mysql table. $last_id = mysql_insert_id(); //select parent id of last inserted user $sel = mysql_query("SELECT * FROM tbl_new_agent WHERE new_agnt_id = … | |
hey guys so this piece of coding is simple and straight forward but theres something wrong with it and its bugging me out because i can't figure out what the problem is. the error i get is this: You have an error in your SQL syntax; check the manual that … | |
hey guys so basically what i want to do is populate a table with details from a database. That is part of the problem. When i write the php coding to do that the other elements on the webpage sort of disappear. Ill attach some screenshots to make it clearer. … | |
Hi all, I have a table which holds 130 companies and their related details. I have done the code to insert the information into the table when new companies come along. But now I need to display the existing information. I am looking at doing it using a form for … ![]() | |
Hi i'm looking to create a dynamic website that allows me to showcase my personal picture collection. I want a table in a MySQL database that has the fields: -Image ID -Image Name -Actualimage -Description -Date Added -Views then i want a PHP script that creates a page (i assume … | |
Hi Friends I am trying to insert into my table. But i am getting an error message as below Notice: Undefined index: img_path in D:\xampp-portable\htdocs\cgoogle\entergoogle\addpages.php on line 21 Notice: Undefined index: img_path in D:\xampp-portable\htdocs\cgoogle\entergoogle\addpages.php on line 23 can any one please help me to resolve. **my code is** <?php if(isset($_POST['Submit'])) … | |
Hello, I am just after some information if anyone knows how to create a system in php that auto assigns a user at random when a record is logged in a mysql database I have been tasked to build a logging system for which uses a database to store the … | |
I will appreciate if anybody can put me through how to convert project coded in PHP MySQL into standalone .exe ![]() | |
Hi Friends! I want to create a dynamic website. So, to create it I need to know PHP and MySQL. I went to [amazon.com](http://www.amazon.com) and searched for books. I was showed by results of **learning php and mysql**, **learning php** and **learning mysql** book names. I couldn't figured whether should … | |
![]() | Hi I'm trying to create a page for a stallion showing his offspring. I used the distinct query in the hope of showing each of his children only once, but I'm assuming that because the other data in the row differs (there is a unique reference number called runid) the … ![]() |
Hi I have this table name age John 14 Katy 14 Mark 15 and I want the number of rows where the age is equal to 14 , so in this example the result should be (2) but my problem is that I dont know how to start , so … | |
Hi, Need suggestion for a query. I am trying to get count(c3.id) for all days of feb. As in cs.created_at some dates are missing.How can i use below clause. **group by day(cs.created_at)** something like group by day(month(cs.created_at)) not working.. select count(case when cs.id IN(select max(id) from complaint3_status where complaint_id=c3.id and … | |
i already searched about displaying the data fields, my problem is how to retain the checked item and then set its value as 1. please help. i tried some code but didn't work: <html> <form action='' method='post'> <?php $database = 'sample'; $table = 'checklist_stud_columns'; $mysql = mysql_connect('localhost', 'root', '') or … ![]() | |
Hi all, I'd like to create an interactive voice response menu system on my own. I'd like to use my MySQL database. I have a found an interesting idea (https://ivrhttpozml.codeplex.com/), but it's based on using a webserver. In short, the previously copied guide presents a simple XML code (more exactly … | |
I am struggling with this, I have a database (mysql where i am trying to delete a single row. The idea is a list of items populated from the database. I am trying to add an additional column where there is a graphic and it reloads the page and runs … | |
Hello Guys. I am fetching some results from database and show into a page. This is a CodeIgniter Project. Here si the code for that: This is the view: <div class="product_view"> <form action="" method="POST" name="form" id="form"> <?php foreach ($get_product->result() as $key => $result) : ?> <h4>Product Name: <?php echo $result->product_name; … ![]() | |
hi i am working on a project:auto parts web store With installation and I do not know where and how to start؟ help me | |
I am trying to populate a select box from my database. The value chosen must be the id of the item, and the text shown the name of the item so that once selected it will insert the id into the table column and not the name so that the … | |
I am working on online shopping website(e-commerce) website, in which I have a task to retrive products (product id, name, imageurl, price, details of product) Image having in image folder folder where stored images and that pah is given to database.. HereI want to fetch category on clicking menu categories … | |
Hi all, i am new to python how to store image into database blob using python please help me for this its urgent | |
I use visual basic 2008 and MYSQL (Storage engine is innodb) Is use this code to retrieve informatie (see below) The SQL string ="select * from articles where articlenb=12345" I want to check of this record is used by een othor user in the network. Can use innodb for row-based … | |
What is the best Way to start working on projects if u already familiar with php and mysql? | |
Didnt know where to post this question mysql or here, since im working with php i decided to put it here.. Im starting to learn mysql now :) SO i just wanna retrive a full name from a user how would i do this? im imaging this should be done … |
The End.