- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 2
- Posts with Upvotes
- 2
- Upvoting Members
- 2
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
49 Posted Topics
 | Hi! 1. Whats the difference between using these PL/SQL records? -Table Based -Cursor Based -Programmer Based 2. Whats the importance of using PL/SQL Table? 3. Whats the importance of using VARRAYS? 4. When to use these 3 RECORDS, TABLES, VARRAYS Thanks! |
| | Hi! Im kinda new to c# devt I used to do a php project and Im wondering if theres anyway sql commands in php have comparable commands in c# for example if I wanna read a data in php I use $query = "SELECT * FROM table"; then execute that …  |
| | After INSERTing record(s) to payments_table (from paypal IPN), $query = "SELECT sum(payments) FROM payments_table WHERE customer_id='{$customer_ID}'"; $result = mysql_query($query); //get the value from result here $query = "SELECT customer_id FROM discounts_table WHERE customer_id='{$customer_ID}'"; $result = mysql_query($query); //if row > 1 //loop until reached a certain condition THEN genarate a NEW … |
| | Hi! I have a table for payments what I want to accomplish is: once a certain customer Id reached a certain amount by his accumulated payment, it will trigger an insert into statement to my discount table to generate a code specifically for him. i understand thats trigger is only … |
| | Hi! Part of my website development is being able to recover a password and upon reading the owasp page i found out that the best one is having a temp password and an expiration my customers table doesnt have a date column nor temp pw column do I have to … |
| | If php file cannot be viewed from users browser, what are the advantages and disadvantages of having to process a form in same php file or processing a form with a different script? ie mail_form.php or with process_mail.php thanks! |
| | Hi! Could someone show me how to implement swap algorithm in php and mysql? ie: I have 4 records in a table each are sorted by column position say position 1 2 3 4 if I move an existing position from 4 to 1 number 1 will be moved to … |
| | Im trying to swap the values if taken already but its not working heres the code: [CODE]<?php ob_start(); require_once("../session.php"); require_once("../functions.php"); require_once("../../includes/connection.php"); include_once("../../includes/header.php"); confirm_logged_in(); if(isset($_GET['cat_id'])) { $category_id = $_GET['cat_id']; $result = get_specific_category($category_id); while($row = mysql_fetch_array($result)) { $category_name = $row['category_name']; $position = $row['position']; $visible = $row['visible']; } } if(isset($_POST['Submit'])) { $errors = … |
| | Hi, I have a pretty quick question regarding PHP code if script is hidden from client's browser and php code are rendered back as HTML to the user is there a way ever that someone can view your code using say a browser plugin? or getting your source file and … |
| | Hi! I dont know if this possible I have a payments table in a database what I want to accomplish is, once a certain customer id has paid say $100 USD my discounts table will generate a code for me automatically say I'll insert a new record is there such … |
| | Aside from sql injection if I sanitize data before querying or sending it to a database are there any issues that needs to be addressed concerning security of a web app? im building an e commerce from scratch as part of a school project using notepad++ and xampp. any recommendations? …  |
| | my goal is when user adds a product thats already in the cart, it will retain the product name and it will add 1 to the current quantity my code is: [CODE]$item_found = false; $index_of_array = 0; if(isset($_POST['product_id'])) { $product_id = $_POST['product_id']; if(!isset($_SESSION['cart_array'] ) || empty($_SESSION['cart_array'] )) { $_SESSION['cart_array'] = … |
| | im making a small web app as e-commerce site im storing the product id selected by a visitor into session product id as an array now what i want to accomplish is: also store the quantity associated with the product selected and then update that sessions for quantity if visitor … |
| | Im building a shopping cart for every product that is clicked, i append them to $_SESSION['product_id] and put comma so if producct 1 is clicked, the value of the $_SESSION['product_id] is 1 then if producct 2 is clicked, the value of the $_SESSION['product_id] becomes 1,2 and then I explode the … |
| | if I use session in a web app can I be assured that every guest who visits the site has a unique session id? and for example I use a rand() to generate and store a $_SESSION['customer_id'] can I be assured that every set of rand() is also unique? say …  |
| | I have set my table to InnoDB which has parent to child relation table 2(child) has FK Reference to table 1 (parent) PK table 2 has cascade on update and delete I am trying to insert a record in table 2 which PK doesnt exist yet in table 1 my …  |
| | Im building a very small website which has an admin and public area what i want to know is your prefence when it comes to reporting or logging ie. when admin or user insert, update, delete, from and to the database changes will be written to either a database or … |
| | Hi! Im changing my database engine from MyISAM to InnoDB its because I learned online that if I were to use FK's that its more likely that I have to use InnoDB my question is: if I have a one-to-many relationship tables: ie. one PK in table 1 can have: …  |
| | Hi! I need to know if theres a function that is simmilar to mysql_insert_id function where it gets the last inserted id but the thing is my id is not auto increment i tried doing the select statement but not working my scenario is: i am updating a record from … |
| | I know that php can validate data input before querying to the database but which is more preferable by the developer or user experience? validation thru php? or validation thru javascript? whats your insight about this? thank you! |
| | form1.Hide(); form1.Visible = false; form1.Transparency = 0; |
| | I want to be able to insert and update 2 different tables at the same time heres the scenario: if i insert a new record, the it will create a primary key for me as auto increment then once that primary key is created, I want to use that to … |
| | Database query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 [CODE]<?php ob_start(); require_once("includes/connection.php"); include_once("includes/header.php"); //get category id according to selected record $category_id = $_GET['cat_id']; //fetch data to populate … |
| | Im building a simple yet robust small e commerce site what i wanna know is: is it more safe and secure to add the mysql commands such as select add update delete in the same html form or create another php file for that as a process? example: i have …  |
| | Hi Im new to php programming as part of my academics, Im building an e-commerce website can you give me some tips on how to build robust site? |
| | use ob_start(); after the <?php at the very first php code and ob_flush(); before the the end tag ?> |
| | Hi! im new to php programming im trying to output the file image uploaded to a directory in localhost im using xampp i tried several things im unable to get image displayed it shows only blank page if not it shows a very small icon which indicates that pic cannot …  |
 | return means you want to return "something" from your method. for example: you have a method called "addNumbers" here it is: [CODE]private void addNumbers(int a, int b) { return a + b; }[/CODE] once you call the method by passing values: [CODE]addNumbers(9, 8);[/CODE] it will "return" a value "back" to … |
| | how about using sqlcommandbuilder and using dataset and data adapter using a datarow, you can loop through its row. |
 | 1. initialize a counter i and set to 0 2. give a condition: while counter is less than 2 3. while number 2 is true (meaning counter is still less than 2) execute the code inside the curly braces. 4. then increment the counter 5. check if the counter is … |
| | You can start by knowing what c# can do for developing a program then start with the Data Types then with the Logical, Operators, Comparator then Control Statements then Loops then Arrays then Methods then Classes while you are learning these, you can either use: console application (command line in … |
| | Re: Editor I use visual c# express 2010 edition and its free IDE which you can download at microoft website. but if you want to have a really lightweight editor, I use notepad++, its just a text editor with advance features and supports other programming and scripting languages. hope this helps! |
| | Hi! Im working on a really simple client server app I have a windows forms which is connected to ms sql db using string conn a dataset and a data adapter presented in a datagridview in a form in my table, theres a column for price what i want to … |
| | I know how to pull data from a db and present it in a textbox in a form my question is, how can i pull data from a db and present it in a datagridview? and another thing, once a certain row is double clicked, new form will show and … |
| | Hi! I created a really simple CRUD app in C# using MS SQL as back end. I connected the DB using connection string and use dataset, and data adapter to pull data from the db Im searching for the simplest way of checking record if it exist in a table …  |
| | I am developing a small online shopping website. My question is: Do I still have to use session if I wont allow customers to add items to cart when they are not registered? Meaning, once they want to order, they will have to register and login to their account Thank …  |
| | Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO … |
| | Hi! Im new to php web development. I am developing an online shopping system where theres an admin page that allows him to add, edit, delete category and products. to cut the story short, what I want to know is, is it safe to save the table for admin username …  |
| | I created a code in C# but cant see any resource online to convert it to php can you help me? Bitmap printscreen = new Bitmap(Screen.PrimaryScreen.Bounds.Width, Screen.PrimaryScreen.Bounds.Height); Graphics graphics = Graphics.FromImage(printscreen as Image); graphics.CopyFromScreen(0, 0, 0, 0, printscreen.Size); printscreen.Save(@"C:\printscreen.jpg", ImageFormat.Jpeg); |
| | I made a program which converts binary with ft pt but cant get it work, what could be wrong here? [CODE]import java.io.*; import java.util.Scanner; public class NumberConverter { public static void main(String args[])throws Exception { Scanner sc = new Scanner(System.in); System.out.print("Enter a number: "); String string_input = sc.nextLine(); double double_input … |
| | Ive been learning java since last month and I wonder if theres any website that you can suggest which will force me to do a problem solving to enhance my program logic skills? Like homework or assignments from beginner to intermediate to advance. I know there are lots of tutorials …  |
| | I created a console program in jcreator (java) which asks the user to enter a number in string and converts that string value into char array and then converts each char array into an integer which I also stored each as an array and then adds all the value from … |
| | I created a console program in jcreator (java) which asks the user to enter a number in string and converts that string value into char array and then converts each char array into an integer which I also stored each as an array and then adds all the value from … |
| | Re: Multiple Windows [CODE]private void button1_Click(object sender, EventArgs e) { //showing the form 2 Form form2 = new Form(); form2.show(); //hiding the form 1: this.hide(); }[/CODE] if you use the show dialog, you cant hide the form1 afaik. |
| | Im a newbie and im working with 4 forms, first form is a main menu which has 6 buttons, if one of the button is clicked, a view only form is shown. this view only form has add edit and delete buttons. if edit or add is clicked, a single …  |
| | [CODE]if (textBox1.Text.Length < 10) { MessageBox.Show("char input is less than 10"); }[/CODE] |
| | [CODE]private void button1_Click(object sender, EventArgs e) { ClassLogin clgn = new ClassLogin(); bool sts = clgn.Check(textBox2.Text, textBox1.Text); if (sts == true) { MessageBox.Show("OK"); } else { MessageBox.Show("Your Username or password is incorrect"); } [/CODE]  |
| | Are you working with console window or forms? If you are working with forms, in your textbox.text method you could validate the string by: if (textbox1.Text == 6) // this is to check if the string input is equal to 6 chars. { your code here } else { MessageBox.Show("The … |
| | I am working with multiple forms in C#. My startup Form /or/ Parent Form /or/ Form1 is a login form. on my Form1, I have a textbox1 for username and textbox2 for password and a buttons for submit and cancel. on click event of submit button,if textbox1.text && textbox2.text are … |
The End.