11,093 Topics

Member Avatar for
Member Avatar for nana.k.denise

<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> …

Member Avatar for nana.k.denise
0
372
Member Avatar for skyscraper11

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 | …

Member Avatar for cxzei
0
710
Member Avatar for kgizo

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. …

Member Avatar for kgizo
0
299
Member Avatar for Yassine_1
Member Avatar for jeffmarlon

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?

Member Avatar for Bachu
0
43
Member Avatar for nevek

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` …

Member Avatar for diafol
0
253
Member Avatar for Yorkiebar14

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: …

Member Avatar for kanuriyesu
0
294
Member Avatar for Udeme_1

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(); …

Member Avatar for samfoster017
0
170
Member Avatar for CarterLangley

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; } …

Member Avatar for CarterLangley
0
264
Member Avatar for mydreamgirl

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?

Member Avatar for cereal
0
78
Member Avatar for Alhussaini.Eng

**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 …

1
273
Member Avatar for CarterLangley

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 …

Member Avatar for CarterLangley
0
197
Member Avatar for prem2

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 -- …

Member Avatar for diafol
0
364
Member Avatar for Shft

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 …

Member Avatar for pritaeas
0
114
Member Avatar for amna zafar

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 …

Member Avatar for diafol
0
357
Member Avatar for zeemon

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?

0
104
Member Avatar for amanu092

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 …

Member Avatar for williamwalker
0
313
Member Avatar for nadiam

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 …

Member Avatar for diafol
0
3K
Member Avatar for joshmac

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 …

Member Avatar for joshmac
0
376
Member Avatar for lukwagomedia

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 …

Member Avatar for lukwagomedia
0
176
Member Avatar for nadiam

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 …

Member Avatar for nadiam
0
510
Member Avatar for johnsapante

I have a problem of creating mysql that return a single value, calculated from values in a column.what kinds of function i think to use?

Member Avatar for rch1231
0
202
Member Avatar for baloch123

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 …

Member Avatar for diafol
0
18K
Member Avatar for rpv_sen

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 …

Member Avatar for Rahman_1
0
330
Member Avatar for LRNPHP

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 …

Member Avatar for diafol
0
224
Member Avatar for ethan.david.376

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"

Member Avatar for veedeoo
0
168
Member Avatar for anita_86

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 = …

Member Avatar for EvolutionFallen
0
418
Member Avatar for nadiam

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 …

Member Avatar for Assembly Guy
0
279
Member Avatar for nadiam

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. …

Member Avatar for nadiam
0
231
Member Avatar for CarterLangley

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 …

Member Avatar for diafol
0
295
Member Avatar for dorkwad

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 …

Member Avatar for asadjaved64
0
2K
Member Avatar for rpv_sen

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'])) …

Member Avatar for rpv_sen
0
341
Member Avatar for urbanthistleuk

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 …

Member Avatar for urbanthistleuk
0
416
Member Avatar for paramesh23
Member Avatar for Wale Adegbite

I will appreciate if anybody can put me through how to convert project coded in PHP MySQL into standalone .exe

Member Avatar for diafol
0
81
Member Avatar for oanahmed

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 …

Member Avatar for oanahmed
0
346
Member Avatar for Borderline

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 …

Member Avatar for Borderline
0
258
Member Avatar for Iikeloa

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 …

Member Avatar for urvisha
0
166
Member Avatar for jacob21

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 …

Member Avatar for Alberto Bucur
0
196
Member Avatar for Syria Elisha

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 …

Member Avatar for diafol
0
252
Member Avatar for williamwalker

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 …

Member Avatar for williamwalker
-2
291
Member Avatar for ActingRude

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 …

Member Avatar for Alberto Bucur
0
158
Member Avatar for danieldake

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; …

Member Avatar for diafol
0
5K
Member Avatar for mehran.abdi.9

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

Member Avatar for mehran.abdi.9
0
320
Member Avatar for CarterLangley

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 …

Member Avatar for jj.dcruz
0
505
Member Avatar for swshyamash

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 …

Member Avatar for swshyamash
0
82
Member Avatar for rajeshwari_ib

Hi all, i am new to python how to store image into database blob using python please help me for this its urgent

Member Avatar for Gribouillis
0
2K
Member Avatar for dre-logics

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 …

Member Avatar for dre-logics
0
655
Member Avatar for paramesh23

What is the best Way to start working on projects if u already familiar with php and mysql?

Member Avatar for engrjd91
0
123
Member Avatar for centenond

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 …

Member Avatar for centenond
0
189

The End.