7,368 Topics
| |
I'm hoping that another set of eyes will see something that I'm not. I'm having an issue with a script that I just added a little routine to, so I know the issue is in the routine, because the sript as a whole was working before adding this... the routine … | |
<?php if (isset($_POST['Login'])){ $Username = $_POST[ 'UserName' ]; $password = $_POST[ 'Password' ]; $user = 'localhost'; $pass = ''; $db = new PDO('mysql:host=localhost;dbname=ovs', $user, $pass ); $sql = "SELECT * FROM Voters WHERE UserName=:UserName"; $query = $db->prepare( $sql ); $query->execute( array( ':Username'=>$UserName ) ); $results = $query->fetchAll( PDO::FETCH_ASSOC ); foreach( … | |
I have written a code to add users into the database and validate their credentials when a user logs in. Only the added users are allowed to login and for non valid users, simply a username/password does not match error message is echoed. Password encryption and checking codes are not … | |
Hey guys, me again. OK, I have this form that gets and populates the select boxes with the necessary info. Now, what I would like to do is to take the id field of the select box and use that to do a select query on the relevant table. So … | |
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 ) | |
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` … | |
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? | |
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? | |
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 … | |
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 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'])) … |
The End.