10,942 Topics
 | |
| | 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 |
The End.