18,960 Topics
Hello, my website is created almost intirely in php, its dynamic and we have everything working under mysql database. It has printable cuppons for free, the coupons are inside a form, everything works perfectly. Now im trying to find a (php preferably) script that will count how many times that …
hi am currently learning java on my own and am kindly assistance with code for a database search button. thanx for help
I want to show on Messagebox the value max and min value in my database. Help guys query = " SELECT Emp_ID, MIN(Log_Type) as min , MAX(Log_Type) as max FROM tbl_timelogs" mysql_connect(True) cmd = New MySqlCommand(query, SQLConnection) reader = cmd.ExecuteReader()
Entry.php <?php require 'config.php'; if (isset($_GET['logout'])) { unset($_SESSION['isLogged']); unset($_SESSION['isLogged']); session_destroy(); header('location: index.php'); exit; } if (!isset($_SESSION['userLogin']) && !isset($_SESSION['isLogged'])) { header('location: index.php'); exit; } ?> <!doctype html> <html> <head> <meta itemprop="image" content="mainlogo_title.png"> <title>SEA TURTLE NEST MONITORING RECORD</title> <link rel="shortcut icon" href="mainlogo_title.png" type="image/x-icon"/> <link rel="stylesheet" href="css/link.css" /> <link rel="stylesheet" type="text/css" media="all" href="jsDatePick_ltr.min.css" …
Hi everyone, I am working on an small inventory management application for learning about swing and i am using jTable to display the contents of MySql table i have to refresh the contents of my jTable instantly whenever i Add an new customer but i couldn't do it because i …
Hi there, i need hel whit this one : i'm learning how to develop MVC but evry time that i wand to create a data base whit visual studio express 2013 i get the classic connection to DefaultConnection : Data Source=(LocalDb)\v11.0;AttachDbFilename=C:\FRANCESCO\Project\OdeToFood\OdeToFood\OdeToFood\App_Data\OdeToFoodDb.mdf;Initial Catalog=OdeToFoodDb;Integrated Security=True Ho can i set as a connection …
Please, my login form could not login to user homepage, it display (SELECT * FROM members WHERE email = 'wareez' AND password = 'lord') and this is the login.php code <?php Please, my login form could not login to user homepage, it display (SELECT * FROM members WHERE email = …
Hello, I am building a multidimensional array with the following code: $array_two = array(); $arrayIndex=0; $loopCount=0; $second_index=""; foreach ($result as $myValue) { $loopCount = ($loopCount<5) ? $loopCount : 0; switch ($loopCount) { case '0': $second_index="cName"; break; case '1': $second_index="local"; break; case '2': $second_index="days_times"; break; case '3': $second_index="contact"; break; case '4': …
As some of you might know I'm working on a movie database to help track my movie collection. For a while I was having trouble getting the output I wanted for that, but I finally figured out some sql code to help with that problem. I'm going to be working …
how to update /delete and search in datagrid using mysql database?
I am going to ask you, about some **Web App Ideas**, to make a web App , Now a days am working in php & mysql and Codeignitor , i want to make web app which may take 2 or 3 months to make and also have a scope of …
I have been racking my brain trying to think of how this would work to no success. Can anyone explain how this could be done?
Hello, i'm trying to solve this problem for 2 weeks with no luck. I'm using sql lite to pull data from my database but it doesnt show up the last item. I've tried to use an other server but again nothing! Even if i try to re-create the database the …
Hi all, I am working on Bank Management System,,i wanna connect my programm to MySql Can anyone refer me Book(s)/links where i can learn so...i have know how of Mysql already and worked on it
Complaint table id company_id user_id source id=coplaint_id user_id=user which filed complaint company_id=complaint againt company source=source of complaint I am trying to get user_id who have filed complaint via same user_id and against same company. one user can filed multiple complaints against same/different company
Hi, I'm currently working on a site in which a user basically clicks a button repeatedly, gaining 1 extra point each time he clicks it. Anyway, I'm trying to do a MySQL update so that when the button is clicked, it updates his score in one of the MySQL tables: …
My dear friends, I'm stuck in the middle of my project because I'm unable to figure out how this problem could be resolved. I have to implement a time constraint ( admin supplied ), MCQ type of quiz with a fixed structure of only 4 options which is to be …
Hello, I want to insert single or double quotes into mysql without using \ or anything else i tried mysql_real_escape_string but it did not work it gives SQL Syntax Error : Check what to use near error...Plz Help... Here's the code... [CODE]<?php $name = isset($_POST['name']) ? $_POST["name"] : ""; $description …
A Database Error Occurred Unable to connect to your database server using the provided settings. the above error am getting when i load the localhost and my database.php and db_driver codings are given below $db['default']['hostname'] = "etc.com"; $db['default']['username'] = "etc"; $db['default']['password'] = "etc@etc"; $db['default']['database'] = "visiting_link"; $db['default']['dbdriver'] = "mysql"; $db['default']['dbprefix'] …
hello good people, i am trying to make a small program that takes input from 4 text fields and adds them to the database(i am using mysql through wamp server) and some other database operations. my Exit and Clear buttons are working. I am using Swing class but have done …
I got a database which contain data of jobseeker and employer. I create a form to search for jobseeker . The form contain textform and checkboxes . The problem is after i fill in any field and submit the result is not shown . Is there anything wrong with my …
Hope someone can help me with the folowing. I have a date in a data table Works perfect to put a date in the table. But when i delete the date and the update with an empty date it wil update me the date of today. But i want it …
I am trying to search a mySQL database in PhP using POST, but I get these errors: **Notice:** Undefined variable: ban1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 266 **Notice:** Undefined variable: banner1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 268 **Notice:** Undefined variable: bantl1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php on line 270 **Notice:** Undefined variable: banreason1 in /Applications/XAMPP/xamppfiles/htdocs/bans.php …
hey buddy's, i'm creating the program of employee details and i will inserted the fields are ADD,UPDATE,DELETE,EXIT,. I hope the all thing to find the exact solutions but, particular one thing only, that was UPDATE and these are the following some tips and code: 1.the input is not going store …
I am using MYSQL and php version 5.4.16.My table structure is as given below. I want to sort the temp_id cat_id and colors based on the cat_id as given in the second table. The com_id same values should not come at once. My Table is something like this: col1 col2 …
Recently I've need to do some table repair and got into my variables and noticed some bizzare numbers. For those of you that know MySQL, these may be familiar to you, so I'll just list the variables and values: max_join_size: 18446744073709551615 max_seeks_for_key: 18446744073709551615 max_write_lock_count: 18446744073709551615 myisam_max_sort_file_size: 9223372036853727232 myisam_mmap_size: 18446744073709551615 The …
Hello there.. I want to backup my database (MySQL) using a command button in VB6...How can I do that? thank you for answering... :)
Im using LOAD DATA INFILE to import a csv file, the files date format is 29/11/2010 and the database format is 2010-11-29, what can i use to format the date inside the query? I've tried str_to_date: `SET date_start = STR_TO_DATE(@from_date,'%Y-%m-%d'),` but that only inserts 0000-00-00
for example i have 100 files , i want to make it 10 links per page. with previous and next links by using php ... i have some code but it is just showing the data from mysql table by using title and descripton. i want to make it links …
I have a project that must have centralization of databases that will have access to the web on a PHP script. I can merge MSSQL and MySQL databases if and only if they were both: 1.) On a same server or 2.) Of the same server type The problem is …
Hey everyone, I'm looking for a free tool to administer MySQL databases. I currently use PHPMyAdmin, which is great, but I'm looking for the same functionality in a desktop software. I've actually found quite a few, but wondered if you any of you could recommend one for me. My only …
<?php include 'connectMySql.php'; $emri=$_REQUEST["emri"]; $mbiemri=$_REQUEST["mbiemri"]; $email=$_REQUEST["email"]; $data=$_REQUEST["data"]; $ora=$_REQUEST["ora"]; $nr_persona=$_REQUEST["nr_persona"]; $query="INSERT INTO rezervim(emri,mbiemri,email,data,ora,nr_persona) VALUES(' ".$emri." ',' ".$mbiemri." ',' ".$email." ',' ".$data." ',' ".$ora." ' , '".$nr_persona."')"; mysql_query($query) or die(mysql_error()); mysql_close($conn); ?>
Hi all,, A module of my Bank Management System which should display the user account details after successfuly entering his/her details calls to a function: void display_acc(int n) { account acc; int flag=0; ifstream inFile; inFile.open("account.txt",ios::in); if(!inFile) { cout<<"File could not be open !! Press any Key..."; return; } cout<<"\nBALANCE …
Hi I need to update a colomn with the result of colomn 1 divided colomn2 I have tried update TABLE set colomn =SUM(colomn1 / colomn2) but get [Err] 1111 - Invalid use of group function IF anyone can help please
Development Environment used: 1.Microsoft Visual Studio 2010 2. Programming Language: C# 3. Database MySql I am trying to use BCrypt class by Derek Slager for creating and authenticating username and password. A form is use to create new user to save Username and Password to database, but this Password is …
Greetings, i just want to ask how to insert a data with fk. Like if i insert a data on tblPatient, the patientID will be displayed on the tblRecord. is it just a normal insert into tblpatient or is there another code for it? Thanks.
i have a problem,i log in even though im not registered in database, please help me urgent!!!!!!!!!!!!
Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you
I'm having a weird situation here. I'm trying create a PDO object, like this: `$dbh = new PDO('mysql:host='.$hostname.';dbname='.$dbname,$username, $password);` I have rewriting ON in my .htaccess file. when I try to run the script using a URL that will trigger a rewrite rule, it shows me the following error: `Fatal …
Hallo, I am trying to make this search box works. This is my code: navigation.php <? //This is only displayed if they have submitted the form if ($searching =="yes") { echo "<h2>Results</h2><p>"; //If they did not enter a search term we give them an error if ($find == "") { …
i am bit confused by the nature and working of query , I tried to access database which contains each name more than once having same EMPid so when i accessed it in my DROP DOWN LIST then same repetition was in there too so i tried to remove repetition …
this front page: Form.jsp <html> <head> <title> Data Inserting Form </title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1"> </head> <body> <h1>ENTER THE EMPLOYEE DETAILS</h1> <form action="./Insert.jsp" method="post"> <table cellspacing="5" cellpadding="5" border="5"> <tr> <td align="right">Employee Name:</td> <td><input type="text" name="EmployeeName"></td> </tr> <tr> <td align="right">Employee_id:</td> <td><input type="text" name="Employee_id"></td> </tr> <tr> <td align="right">Nationality:</td> <td><input type="text" name="Nationality"></td> </tr> …
Hi Everyone, I am struggling to fix this stupid problem I have with pdo php insert. I have this working on a different insert, but for some reason, this is just not working. I keep getting the error "You have an error in your SQL syntax; check the manual that …
I have an accommodation reservation system that allows managing agents to list all the properties under their control. There are various 'locations' that have a priority such as:- 'Beach Front' has priority of 1 and 'Off beach' a priority of 2 etc. Setting these are pretty much a straight forward …
Good day all ! am a newbie in the world of web design. i recently installed (after download) wampserver (ver 2.1) and adobe dreamweaver (CS5) on my windows 8 machine to enable me kickstart with a very important job. supprisingly, each time i try to connect to my DB (either …
<?php include 'connectMySql.php'; if(! $conn ) { die('Could not connect: ' . mysql_error()); } $sql = 'SELECT * FROM users '; $result = mysql_query( $sql); if(! $result) { die('Could not get data: ' . mysql_error()); } while($row = mysql_fetch_assoc($result, MYSQL_ASSOC)) { echo "ID : {$row['id']} <br> ". "USERNAME : {$row['username']} …
Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. …
I am creating a site and I am trying to put all the posts within a mysql database (phpmyadmin). How do i put articles/posts in the DB?
I am trying to do a count of all types in there(hardware and software) I thought i had the correct structure...but I guess i am wrong... $count = mysqli_query($mysqli, "SELECT COUNT(*) AS total_count FROM assets WHERE cust_id=$custID AND (asset_type='hardware' AND asset_type='software') "); echo mysqli_error($mysqli); $count = mysqli_fetch_object($count); $count = $count->total_count; …
I have the following query which joins 5 related tables to get the desired result set of 10 rows, I did my best to solve the issue by adding indexes and re-writing the query in many different ways but I ended up either unexpected result or a very slow query. …
The End.