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